What is the purpose of Dataset in ADO.NET?

In your applications, you might want to connect to a data store (for example, SQL Server), fetch data, do some manipulations on the data and update the changes in datastore. For this, the recommended approach is to connect and fetch data from data store.




Disconnect the connection, manipulate the data and then post the changes to the data store by establishing a connection again. This approach is possible in ADO.NET using dataset object. Dataset object helps you to manipulate on set of records obtained from disconnected data store.

The architecture of dataset object is shown below:



In the diagram, 1..n means “one or many instances”. For example, DataTable(1..n) means that Dataset can contain one or more DataTable objects. And the rhombus indicates parent/child relationship that exists between the DataTables.

_______________________________________________________________________

Add to My Yahoo!


FREE Subscription

Subscribe to our mailing list and receive new articles
through email. Keep yourself updated with latest
developments in the industry.

Name:
Email:

Note : We never rent, trade, or sell my email lists to
anyone. We assure that your privacy is respected
and protected.

Visit .NET Programming Tutorial Homepage

______________________________________________________

Recommended Resource

| What is Private Access Modifier in C#? | What is Protected Access Modifier in C#? | What is Protected Internal Access Modifier in C#? | What is Public Access Modifier in C#? | What is the difference between virtual and abstract keywords in .NET? | What is the importance of Microsoft Application Blocks in .NET Architecture? | What is the need for Factory Method in C# | What is the purpose of ArrayList in .NET? | What is the purpose of Datareader in ADO.NET? | What is the purpose of Dataset in ADO.NET? | What is the purpose of finally block in C#? | What is the purpose of interlocked class in .NET? | What is the purpose of main() function in C# | What is the purpose of ManualResetEvent in .NET? | What is the purpose of sealed method in C#? | What is the purpose of Thread.Join() method in .NET? | What is the purpose of Thread.Sleep() method in .NET? | What is the purpose of throw keyword in C#? | What is the usage of ENUM in .NET? |


| Privacy Policy for www.dotnet-guide.com | Disclosure | Contact |

Copyright - © 2004 - 2017 - All Rights Reserved.