DataSets Tutorials

Question

Now I am at the planning stage of the project, and I had an interesting question (for me) - how do f * do DataSets anyway?

I mean, since now I always used simple SQL expressions written in the code, but this does not seem so complicated for me. So basically I want to start using DataSets, but there are no tutorials on this. I mean, of course, I can design them in VS, but how can I access them in my code? I searched all day, but could not find any useful textbook for this ...

Is it because DataSets are not good, or simply because no one is using them?

I would be very grateful for any information regarding this ...

Answer 1

I think you will be interested in the first few tutorials in the Microsoft ASP.NET Data Access Tutorial . In this tutorial, you can create a simple ASP.NET site that has access to data in a Northwind database (SQL Server 2005).

It does a decent job of creating, configuring, and using Typed DataSets.

Answer 2

Datasets are an important part of ADO.NET and work as objects in memory and are widely used. You can store more than 1 table in a DataSet and, if necessary, apply some relationships between them. It also works both when reading and writing data, while DataReader is designed to read data only.

You can follow this link for a better understanding.

http://msdn.microsoft.com/en-us/library/system.data.dataset(VS.71).aspx