hello:
my name is Ali Abdolrahmani ([email protected]). i am a beginner in Microsoft .NET taking some courses. i want to know about goods and bads of using datasets. more clearly, what are the advantages and disadvantages of datasets and using them. is there any article or something like that i can read and learn?

thanks in advance

Advantages are that you can cache the data and do simple filtering and sorting, something that you will need for basis things. For advanced things, they are pretty much useless as it is more problem then support.

For instance, to filter columns, to construct advanced SQL queeries or something like that, you will have to apply whole set of workarounds, probably learn XPath (form of SQL in XML world) as none of those every day operations are not possible native using DataSets...

So, if you just need to grab some tables localy and use simple cursor to read them all, dataset is good enough. If your project is evolving, better see some other solution...

Instead of thinking of advantages and disadvantages
od datast. Use must compare dataset with datareader as both solves different needs. If u just want to fetch data and display , u must use datareader.Its Very fast.But u cannot do DML in radareader. Aslo datareader canot be stored in memory for future updates. This is solved by dataset.which can be stored inmemory , we can insert , update or delete the records in dataset , then we can push the changes to original datasource at future.

>>>Its Very fast.
Yeah... beside the fact that you keep connection open all the time.
And for large tables, and multiple users.....