Page view counter

Data Access Layers in ASP.NET Applications

In this video, part 1 of 3, Joe Stagner creates a data access layer using a typed data set for a simple ASP.NET application. For additional information about this video, read the Creating a Data Access Layer data access tutorial.

Presented by Joe Stagner

Duration: 11 minutes, 50 seconds

Date: 7 August 2008

Watch the video   |   Download the video   |   Get VB code  or  C# code

Video downloads: WMV | Zune | iPod | PSP | MPEG-4 | 3GP

Audio downloads: AAC | WMA | MPEG-4 | MPEG-3 | MPEG-2

Comments : 21

Leave a Comment

Davester : On August 09, 2008 1:32 AM said:

Great video.  More More !

Davester : On August 09, 2008 1:32 AM said:

Great video.  More More !

JoeStagner : On August 10, 2008 2:16 PM said:

THANKS  MORE on the way !!!

muhammed : On August 11, 2008 1:12 AM said:

execelent video more........

eshwar7 : On August 12, 2008 11:27 AM said:

Good one....

kikit2008 : On August 12, 2008 12:38 PM said:

Hello, like always the video's are very clear presented.. compliments. Regarding to this video i don't really understand why you still want to use the dataset instead of linq? Please fill me in :)

pinfeather4200 : On August 13, 2008 2:59 PM said:

I'm having trouble with the c# code.  Is there a c# video?

Jayman911 : On August 14, 2008 8:26 PM said:

Great video. Thank you.  One question i have been struggling with is how do i refresh my dataset in the designer once i make a change to the database of some sort (i.e. add/remove a column etc).  Would i have to rebuild it from scratch and if so would i need to redo any custom methods created?

SALADINE : On August 16, 2008 12:22 PM said:

thnk you so much

*salah eddine bekhouche*

abelanet : On August 19, 2008 3:16 AM said:

Great Video - Simple and to the point. Thanks

enochgenesis : On August 22, 2008 2:48 PM said:

Hey Joe,

This was great and to the point.  Would you be willing to make something like this that shows how to create and use datasets that involve more than one (preferrably 3 or more) table with relationships.  Also, would you be able to address whether it is worth using a dataset for an entire Database, or a different dataset for each table or relationship aspect, etc.

I always see everyone creating one table examples, but nobody seems to address multiple tables with relationships.  It would be a great help to many I'm sure.

Thanks again for all you do!  I'm a big fan of your videos.

asater : On August 26, 2008 2:42 PM said:

we need more videos about dataset and when to use them

Thank you

kebailey : On August 31, 2008 9:53 PM said:

These are amazing.  Finally Microsoft is thinking like  prospective users/developers!

ReginK : On September 01, 2008 11:25 AM said:

Joe, Your videos are simple keeps me interested all along. I have watched some videos by other guys where after a few mins, me and the presenter are both on different pages!

Thanks... and really looking forward to more on this series - probably a huge series like the one u have on Ajax. :)

Attractive : On September 21, 2008 5:07 AM said:

Thanks joe

But what if I extracted only one record and I want to save its attributes in variables..

thanks again

yamu : On October 02, 2008 10:20 AM said:

Hello thanks for these type of video.. But I am looking help,

Scenario: I am using ASP .Net 3.5, I made up Form, where I have Textbox (txtDeptID and txtDeptName) and I have Table Department in Department Table I have two fields (DeptID and DeptName).. Now I want to Connect txtDeptID and txtDeptName and perform simple operation Add Record, Delete Record, Update Record

help will be appreciable

Regard

yamu

nader_s : On October 20, 2008 3:17 PM said:

Hello Joe,

I always enjoy your tutorials, thanks, I looked at your data access (the 3 videos), scott's tutorial on Data Access (www.asp.net/.../data-access) and LINQ video tutorials (www.asp.net/.../linq-videos). It seems that there are many ways to achieve data access, and this is good, but some times you need to know which fits better, why would I use LINQ to SQL data models, or why to use strongly typed data sets, there is also (still in work) Dynamic data, we need to know how to build an ARCHITECTURE.

I am now looking at Enterprise Library and just trying to decide if this is good for me, or should I go to strongly typed data sets and custom BLL or the mighty LINQ.

Regards,

Nader

aicha2007 : On October 20, 2008 4:28 PM said:

think's for all

inferano : On October 21, 2008 8:18 AM said:

Very well structured video. Thanks for the same.

agoyal : On October 25, 2008 2:17 PM said:

Very informative for new ASP.net developers.  Need more Videos on this series

ronald_yoh : On November 05, 2008 10:14 PM said:

dude... ur sample is not working.. when I tried to call the video adapter (by typing "as vidoeTable.."), the VB does not have the list.. but I manager to preview the data on the videoDS.xsd

Leave a Comment

You must be logged in to leave a comment. Click here to log in.

Microsoft Communities