Solved

ASP.NET and SQL Integration

Posted on 2008-06-26
5
419 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
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…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

770 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