 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
.NET Forum / ASP.NET / General / October 2007Can we access database (SQL) using AJAX ?
Hi, Can we access database (SQL) using AJAX ? Thanks, Bhuwan > Hi, > > Can we access database (SQL) using AJAX ? > > Thanks, > Bhuwan 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.  SignatureGöran Andersson _____ http://www.guffa.com 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) >> Hi, >> [quoted text clipped - 9 lines] > 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 ? 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... SignatureMark Rae ASP.NET MVP http://www.markrae.net 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 >> Can we access database (SQL) using AJAX ? > [quoted text clipped - 3 lines] > > Can you explain your question in a bit more detail... > I am making a page that contains text boxes for email id, Name, date of > birth, address ... [quoted text clipped - 4 lines] > of the form would fill accordingly without postback. Can I use Ajax in > this scenario I believe so... > or what are the other options. I use this: http://anthemdotnet.com It would meet your requirements with no problem at all... SignatureMark Rae ASP.NET MVP http://www.markrae.net Thanks Mark, I am following the link. Thanks & Regards, Bhuwan >> I am making a page that contains text boxes for email id, Name, date of >> birth, address ... [quoted text clipped - 12 lines] > > It would meet your requirements with no problem at all... u can use sqlxml, so it's 'almost direct' > Hi Mark, > [quoted text clipped - 25 lines] > > - Show quoted text - 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. SignatureGregory A. Beamer MVP, MCP: +I, SE, SD, DBA ************************************************* | Think outside the box! ************************************************* > Hi, > > Can we access database (SQL) using AJAX ? > > Thanks, > Bhuwan Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.