Solved

ASP.NET and SQL Integration

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

705 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

18 Experts available now in Live!

Get 1:1 Help Now