Page view counter

How to Work with Datasets and Filters from an ASP Application

Please install Silverlight or click download to watch video locally.

In this video, part 3 of 3, Joe Stagner demonstrates how to return a filtered set of data from the overall application dataset. For additional information about this video, read the Creating a Data Access Layer data access tutorial.

Presented by Joe Stagner

Duration: 6 minutes, 1 seconds

Date: 07 August 2008

Watch    Video   |   Download    Video   |   VB Code    C# Code

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

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

Comments : 38

Leave a Comment

namhyuk : On August 09, 2008 5:10 PM said:

We need some more advanced topices, like 3-tier.

lonelyhero : On August 12, 2008 12:55 PM said:

We need alot of advaned topices, like 3-tier. Thanks alot.

pnv.ravikiran : On August 12, 2008 11:46 PM said:

Hi Joe, thanks for the video. If deliver some advanced filtering on datasets and datatables, that would be great.

Cheers

retroviz : On August 13, 2008 9:22 AM said:

Hi Joe, another well presented video. With the introduction of LINQ it would be useful to outline the differences in using typed datasets as both approaches offer similar advantages. Also as mentioned above, a video on creating an n-tier app with multi DALs (e.g.SQLServer, MSAccess, XML) using Object DataSources would be great. Thanks

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

thank you mr

*salah eddine bekhouche*

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

Thanks - very good. Watching a video is so much more faster then reading pages.

asater : On August 26, 2008 3:06 PM said:

I agree with Lonelyhero

Thank you

Pakistan : On September 06, 2008 7:22 AM said:

Thank you so much for such a nice training.

Pakistan : On September 06, 2008 7:25 AM said:

how can i connect dataset file with textbox

that i enter id in textbox and only that id related data shown

in the gridview. if some help me i will be very thankful

orphan : On September 13, 2008 2:09 AM said:

Great Videos !

But "lonelyhero" is right, this is too basic

chmzeeshan : On September 20, 2008 5:11 AM said:

Great work , but expecting more detail tutorial soon.

atarikg : On October 04, 2008 1:34 AM said:

Although it's a very basic and easy way of working with datas but it's not a recommended way to work with database when binding and working with datas. Because when using quick datasets like that hold all data when paging and when filtering. so it's not an effective way so it does really not matter to know how to work datasets...

leopold : On October 08, 2008 2:55 PM said:

very nice, I like your videos....it gives a little glue how to start, but there should be more details about the tabeladapter for instance (update, insert queries and using it as datasource for grieds)

or what drives you to the decision of using adapters instead of binding it directly to the db

hope the next episode is coming soon

hashad : On October 21, 2008 4:31 PM said:

Thank you for this

is so nice training.

agoyal : On October 25, 2008 3:19 PM said:

Nice video.  Please some more Videos for creating BLL

troubleshooter : On November 01, 2008 7:32 AM said:

joe,

i would appreciate, if you put on a data access tutorial, how could we make use of the datarelation in strongly typed dataset to get childrows using parent keys and vice-versa. e.g. dataTable.ParentRelations, dr.GetChildRows(.... something extra and useful. Isn't it?

ronald_yoh : On November 06, 2008 4:18 AM said:

hey Joe,

can't get this working..  the code does not pick the videoDS table adapter while typing "As new...."

any idea?

prasanthmcpd08 : On November 27, 2008 2:13 PM said:

Interesting to c these type of videos, thankz joe nd i hav a suggestion that make more contentful  videos in future.

coolwater : On December 02, 2008 9:57 AM said:

Nice tutorials. More please. How to use stored Procedures as data source (Add, edit delete, select tutorials).

rami_nassar : On December 02, 2008 4:00 PM said:

nice taturial... please complete the series

Almon Ing : On December 14, 2008 2:08 PM said:

You are my hero.  These videos are all superb.

pinfeather4200 : On December 16, 2008 1:07 PM said:

Good videos;however, not to clear on the dim statements you wrote them but didn't describe the calls that well to me.  Also when listening on head phones the asp.net intro and exit fadeins have those obnoxious tones to them.  Good work.

kathirvelmm : On January 20, 2009 6:43 AM said:

Its a very good training session

kathivelmariappan.blogspot.com

Vamsi2 : On January 20, 2009 4:14 PM said:

Hi joe -

Thanks for a good series of tutorials again.

Any chance you will be publishing videos to edit data using DataSets?

- Vamsi

BobCharlie : On January 31, 2009 12:30 AM said:

great video

Dimi : On February 09, 2009 10:02 AM said:

Good introduction but could go kind of deeper into this.

bohunt : On February 13, 2009 5:49 PM said:

Brilliant!

blad3runn69 : On February 15, 2009 6:56 PM said:

thanks Joe, muchly appreciated

AjarnMark : On February 17, 2009 2:18 PM said:

Good introduction trilogy.  Would really like to see some demos on using Stored Procedures with datasets, especially for UpdateCommand.

J.Bey : On March 04, 2009 11:46 AM said:

Nice and clean! Great!

Kaikass : On March 06, 2009 6:56 PM said:

Great!

(except 4 "Catagory"...)

Djibril_Chimere_DIAW : On March 14, 2009 12:08 PM said:

Thanks! Jërëjëf!

broadys : On April 21, 2009 2:06 AM said:

Thanks Joe, great tutorial...

MisterFantastic : On April 27, 2009 8:45 AM said:

A very nice article. Helped in important situations

MisterFantastic : On April 27, 2009 8:45 AM said:

very Nice article. Thanks for the help

dranoelp : On May 06, 2009 3:52 PM said:

Thanks Joe. Keep these tutorials coming. We're all watching.

haithemara : On May 19, 2009 5:00 PM said:

thank you.

Mareczekkk : On May 22, 2009 5:02 PM said:

Thanks

Leave a Comment

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

Microsoft Communities