The DataSet class represents a memory-resident database. It is a container for the DataTable and DataRelation classes.DataRelationIt is a Class to establish relation with more than one data in the dataset.
DataRelation class constructor takes three arguments to establish relationship with other table.
1. Strdatarelationname(String type).
2. Parent table columan name.
3. Child table columan name.
To get all data againsed parent table column name you have to use GetChildRows method, which takes one
arguments( Strdatarelationname). and after getting all fields value of child table you can go further with your own code whatever you want.
Here below code gives you example to relate two table using particular field of table.
DataSet ds = null;
protected void Page_Load(object sender, EventArgs e)
ds = new DataSet();