Can we access database (SQL) using AJAX ?

  • Thread starter Thread starter Bhuwan Bhaskar
  • Start date Start date
Bhuwan said:
Hi,

Can we access database (SQL) using AJAX ?

Thanks,
Bhuwan
Click to expand...

Yes, and no.

You can't access the database directly using AJAX.

You can request a page or web service on the server using AJAX, which in
turn can access the database.
 
Can we access database (SQL) using AJAX ?
Click to expand...

AJAX is a mechanism whereby ASPX pages can make HttpRequests via a callback
instead of a postback - there's very little more to it than that...

Can you explain your question in a bit more detail...
 
Hi Mark,

I am making a page that contains text boxes for email id, Name, date of
birth, address ...
Data on the above fields is saved in a table say 'T1" of database say "D1"
of SQL server 2000.

What I want is, after entering email id in a text box, rest of the field of
the form would fill accordingly without postback. Can I use Ajax in this
scinario or what are the other options.

Thank,

Bhuwan
 
I am making a page that contains text boxes for email id, Name, date of
birth, address ...
Data on the above fields is saved in a table say 'T1" of database say "D1"
of SQL server 2000.

What I want is, after entering email id in a text box, rest of the field
of the form would fill accordingly without postback. Can I use Ajax in
this scenario
Click to expand...

I believe so...
or what are the other options.
Click to expand...

I use this: http://anthemdotnet.com

It would meet your requirements with no problem at all...
 
What you have described is a lot like Google forms, so yes, it is possible.
You cannot access the database directly, but with ASP.NET AJAX, you can
create a routine that gets hit as a person types in. It is not as
straightforward, except through third party controls (and perhaps futures),
but it can be accomplished if you are willing to work at it.

If you follow the google forms idea and then get info when the person
selects an email completely, you can AJAX the data return.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

*************************************************
| Think outside the box!
|
*************************************************
 
u can use sqlxml, so it's 'almost direct'
Hi Mark,

I am making a page that contains text boxes for email id, Name, date of
birth, address ...
Data on the above fields is saved in a table say 'T1" of database say "D1"
of SQL server 2000.

What I want is, after entering email id in a text box, rest of the field of
the form would fill accordingly without postback. Can I use Ajax in this
scinario or what are the other options.

Thank,

Bhuwan






- Show quoted text -
Click to expand...
 
actually if you are using sql2005 you can access it directly from ajax.
sqlserver 2005 has a web service interface, which can be called directly
from most ajax libraries. unlike earlier versions, it built in rather
than being an iis filter.

-- bruce (sqlwork.com)
 
Back
Top