ASP.NET

Sonia Gupta wrote:

this is the sort of thing i wanted to do

Sonia Gupta wrote:

this is the sort of thing i wanted to do

DataSet ds= //get dataset method here
//your ds returns two table one for parent and second child table.

DataRelation dr = new DataRelation("new_relation",ds.Tables[0].Columns["PKey"],dst.Tables[1].Columns["Pkey"]);
//PKey is PrimaryKey of one table and foreign key of second table that creat //relation.
ds.Relations.Add(dr);
parentGridView.DataSource=ds.Table[1];
parentGridView.DataBind();
//your parent gridview bind with table[1]

GridView rp = (GridView)(e.Row.FindControl("ChildGridViewID"));
	rp.DataSource=((DataRowView)(e.Row.DataItem)).CreateChildView("new_relation");
rp.DataBind();