Building a DAL using Strongly Typed TableAdapters and DataTables in VS 2005 and ASP.NET 2.0: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Building a DAL using Strongly Typed TableAdapters and DataTables in VS 2005 and ASP.NET 2.0

page 3 of 11

by Scott Guthrie
Feedback

Average Rating:

Views (Total / Last 10 Days): 22083/ 461

Article Contents:

Tutorial 2: Launching the DataSet Designer

To create our Northwind DAL, right-click on the project node in the solution explorer, and select "Add New Item". Then select the "DataSet" option and name it "Northwind.xsd":

Figure 4

This will prompt me as to whether I want to add it under the “App_Code” directory. When I click “yes” it will bring up a data-design surface, and (if in a web project) automatically launch the “Create TableAdapter” wizard (if you are in a class library project you need to right click and choose “Add->Table Adapter to launch this wizard):

Figure 5

« (Page 2)

View Entire Article

(Page 4) »

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 2 and 8 and type the answer here:

User Comments

Title: Pain is just me....
Name: Mohammad Javed
Date: 6/18/2008 6:27:59 AM
Comment:
Using Insert, Update, and Delete DBDirect Commands on TableAdapters is very good articles fo us...

Title: Saeeedaa Khannnnnnnn
Name: Mohammad Javed
Date: 6/18/2008 6:24:56 AM
Comment:
I've been using ASP for 5yrs and felt the need to become current in my coding practices. I Spent 2 weeks trying to find a suitable method to work with Access DB so I could update my code and then update my DB to SQL. MS built in functionaliy is not very flexible. This functionality is so much better than RecordSet in ASP and your Demo actually Works. Good Job! Now I can get something done.

Title: Badal Verma
Name: Badal Verma
Date: 6/18/2008 6:23:29 AM
Comment:
I think this is very helpfull articles for all person beginner as well as professional.

Title: Very Good
Name: Badal Verma
Date: 6/18/2008 6:22:06 AM
Comment:
Very good articles..

Title: Excellent Articles
Name: Mohammad Javed
Date: 6/18/2008 6:21:06 AM
Comment:
Nice Article.

Title: Good
Name: John
Date: 11/27/2007 2:39:07 AM
Comment:
nice Article

Title: Good article
Name: Basir
Date: 9/27/2007 1:12:37 PM
Comment:
I found the information you have provided very useful and thorough. Thanks.

Title: Building a DAL using Strongly Typed TableAdapters and DataTables in VS 2005 and ASP.NET 2.0
Name: William
Date: 7/19/2007 11:43:06 PM
Comment:
I've been using ASP for 5yrs and felt the need to become current in my coding practices. I Spent 2 weeks trying to find a suitable method to work with Access DB so I could update my code and then update my DB to SQL. MS built in functionaliy is not very flexible. This functionality is so much better than RecordSet in ASP and your Demo actually Works. Good Job! Now I can get something done.

Title: MR
Name: Baktash Ahmed
Date: 2/22/2007 4:38:16 AM
Comment:
This a very helptful and detailed explanation of how to create a data source and and modify and the table adapters. It has certainly helped me alot on my project thanks alot Scott for good job and keep it up

Title: This is willl help a great deal
Name: tope Fatayo
Date: 2/17/2007 6:29:50 AM
Comment:
This is a wonderful article. this should meet my data access need in my final year project

Title: nice explanation
Name: B.D
Date: 11/9/2006 3:26:56 AM
Comment:
Clear Explanation with a good examples!!!!!!!!!!!

thankz a lot

Title: perfect !!
Name: Jan
Date: 10/4/2006 4:17:05 PM
Comment:
Thank you

Title: Many thanks
Name: Rolly
Date: 9/8/2006 10:09:08 AM
Comment:
Many thanks for taking the time to put this together. It is the first time i use a Tableadapter and the blinkers are off my eyes. Cheers

Title: Well-done
Name: Susantha Soysa
Date: 8/22/2006 8:42:21 AM
Comment:
This opened my eyes to use partial classes effectively. Many thanks for your time.

Title: Great Article BUT...
Name: Chester West
Date: 7/12/2006 7:29:43 PM
Comment:
This is a great article telling the user how to setup a datasource HOWEVER it doesn't mention using the source in a web service (Microsoft got smart...they realized that the most time consuming part of the web service is getting data...therefore in the .NET 2.0 version they made it hard to create/use datasets in order to discourage anybody from using the web service)

Product Spotlight