What is actually use of Dataset

What is the actual benifet that we get from Dataset in c#.

I write many programs and understan it that dataset is use for creating relations between tables. But whenever i get ParentRow like

DataRow r = ParentTable.Row[0]; // Get first row in Parent table

Then i try to get ChildRow against the Primary key

DataRow[] cr = r.GetChildRows("RelationName");

And finally use foreach loop for print ChildRow Attributes but it cannot work , i try many time

that is why i am confused and ask this question is this is not allowed or is it please provide me some code so i understand the concept and syntax.

I have two tables

1- Parent(Id,Name,Cgpa)

2 - Child(Cid,Address,Fid) // Fid is foreign key

I know the primary key and want to get Record against that primary key in Child Table.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Mushtaq12y ago
Thanks for link , Now i know the use of dataset , it is use for adding diferent tables and their relations , but in document there is no method/code to add relation , how i define relation between two tables (Parent and child) further hoe i get data of child row with primary key of parent table and wise versa.
Satyapriya Nayak12y ago
http://www.dotnetperls.com/dataset