ASP.NET and SQL Integration

I am looking for the easiest way to integrate a web-based form with a SQL database.  My reach so far has pushed me toward ASP.NET.  I am proficient in tSQL and HTML, but have not not done any ASP.NET development.  I do have an IIS server setup that is already running some .NET apps from outside vendors.  This looks like it would be a two part piece: 1) The web page the user interacts with, and 2) a backend piece that interacts with SQL (through ODBC?).

A possible solution would be a project example/training aid that I could open in Microsoft Visual Web Developer and customize to fit.

Specific examples of what I need to accomplish fall into two categories:
-A web based form that allows a user to fill in several values and submit the data as a new record in a SQL table.
-A web based form that will allow a user to enter a value that is pushed through to a stored procedure that retrieves a record and displays it to the user.  (User enters an order number and then specific details from that order are returned.)
LVL 1
sgerlingAsked:
Who is Participating?
 
sbagireddiConnect With a Mentor Commented:
I think your best bet is to pick up a book on ASP.net, something which has real world applications.
You can check out some books on amazon, they have very good reviews.
Also you can check out this site:

http://www.asp.net/
0
 
sgerlingAuthor Commented:
I certainly agree with "doing it right".  I have every intention of taking the time to learn ASP.NET, but an 800-1000 page book definitely takes some time to get through.  Since what I'm looking for is relatively basic as I understand it, I was hoping to find a starting point or something I could modify.

I do appreciate your response though, and am in the process of evaluating books.
0
 
sgerlingAuthor Commented:
Found an excellent video on www.asp.net that let me build exactly what I needed in Visual Web Developer with ASP.NET AJAX.
0
 
sbagireddiCommented:
Lucky strike ! Good luck
0
 
Crazy_PenguinsCommented:
Wow - never know how useful the ASP.net pages are...
http://www.asp.net/learn/data-access/tutorial-01-vb.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.