How to Work with Datasets and Filters from an ASP Application

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

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

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

Cheers

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

thank you mr

*salah eddine bekhouche*

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

I agree with Lonelyhero

Thank you

Thank you so much for such a nice training.

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

Great Videos !

But "lonelyhero" is right, this is too basic

Great work , but expecting more detail tutorial soon.

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...

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

Thank you for this

is so nice training.

Nice video.  Please some more Videos for creating BLL

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?

hey Joe,

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

any idea?

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

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

nice taturial... please complete the series

You are my hero.  These videos are all superb.

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.

Its a very good training session

kathivelmariappan.blogspot.com

Hi joe -

Thanks for a good series of tutorials again.

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

- Vamsi

great video

Good introduction but could go kind of deeper into this.

Brilliant!

thanks Joe, muchly appreciated

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

Nice and clean! Great!

Great!

(except 4 "Catagory"...)

Thanks! Jërëjëf!

Thanks Joe, great tutorial...

A very nice article. Helped in important situations

very Nice article. Thanks for the help

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

thank you.

Thanks

Here is one real life question for you: when you data bind your grid to DS like that and want (often HAVE to have) column names to be two word aliases (SPACE between words, no underscore or both in one word) how do you do it? It errors out in query builder when I try to use "some id" for SomeId or 'some id' for SomeId. However it is easy with datasourse since it let's you edit templates. Please let me know. Thanks.

Hi, I can't execute a query filtering with '@' due to Error in WHERE clause near '@'. Unable to parse text.

Suggestions? Thanks!

How about a few more videos on using typed datasets to update and delete. Or how to use multiple datasets to move data around, maybe from one database to another.

Great explanation . Thanks Joe