Solved

ASP.NET and SQL Integration

Posted on 2008-06-26
5
420 Views
Last Modified: 2010-04-21
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.)
0
Comment
Question by:sgerling
  • 2
  • 2
5 Comments
 
LVL 8

Accepted Solution

by:
sbagireddi earned 500 total points
ID: 21876590
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
 
LVL 1

Author Comment

by:sgerling
ID: 21877431
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
 
LVL 1

Author Closing Comment

by:sgerling
ID: 31471035
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
 
LVL 8

Expert Comment

by:sbagireddi
ID: 21878721
Lucky strike ! Good luck
0
 

Expert Comment

by:Crazy_Penguins
ID: 22013479
Wow - never know how useful the ASP.net pages are...
http://www.asp.net/learn/data-access/tutorial-01-vb.aspx
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question