I'm beginner at C#, asp.net and I took a course about databases (fundamentals of Databases)
I wouldn't ask such question because:
The thing I am required to do is an e-commerce project (small one) and I am stuck after connecting the database from SQL Server to Visual Studio using server explorer?
How in a simple manner can I send SQL queries and retrieve data and display it?
The problem is I have asked this while they know we didn't take web programming courses and I have to deliver the project next week (e-shopping cart + registration + signing in) !!!!
Thank you for the help.
I like the above tutorial - however, a simpler method may be using AJAX to communicate directly to an .asp as shown in the example from W3Schools: http://www.w3schools.com/ajax/ajax_database.asp
The "modern" answer from a web app perspective is to use the Entity Framework or LINQ to SQL. The problem is that I'm not sure that's what they want you to do. There even "Dynamic data" Websites that pretty much build the whole thing for you: http://msdn.microsoft.com/en-us/library/cc488469.aspx
If you need more old school SQL access, look for tutorials on ADO.NET dataAdapters or dataReaders. try this: http://weblogs.asp.net/scottgu/archive/2006/01/15/435498.aspx