Solved

ASP.NET and SQL Integration

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

947 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now