Select from database after string entered in AJAX (ASP.NET)

Question

This is probably simple, but I'm unsure of which tools to use for the job. Basically, the user needs to enter either an account number or name (same text box), and when they click search their account details will appear below in detailsviews and gridviews. What tools do I use so all this can happen on the same page?

Answer 1

Use stored procedures, don't even think about going down the route of creating in-line SQL, especially when account details are involved. I'm assuming your database is MSSQL? If so this link should help. From the stored procedure you'll be returned a datatable, to which you can bind your gridview for displaying to the user.