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.)