Problem 1:

i want nesting of grids like in hierarchical format (Expand-collapse) in ASP.Net 2.0, is there any trick to do that without heavy javascript or HTML? is there any way to do that using new GridView control?

i have done something like this (http://www.samspublishing.com/content/images/chap4_0672326744/elementLinks/fig04.jpg)

but i want the child grid only show when i click the select button( itemcommand event) of the parent grid and only current row display the child grid not others...

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

Problem 2:

another example i tried is  http://msdn.microsoft.com/msdnmag/issues/03/10/CuttingEdge/

it has the proper format what i want but when i connect it with my sql server data it is showing me error: "The relation is not parented to the table to which this DataView points"

my tables are:

tbl1:

RegionCode -RegionName
R1   -North Region
R2   -Mumbai Region
R3   -East Region
R4   -South Region
R5   -Gujarat Region
R6   -Maharashtra Region

tbl2:

RegionCode -ZoneCode  -ZoneName
R1   -R1Z1   -Delhi NCR
R1   -R1Z2   -U.P, Bihar & Uttaranchal
R1   -R1Z3   -Haryana
R1   -R1Z4   -Punjab
R1   -R1Z5   -Chandigarh
R1  -R1Z6   -M.P.
R1   -R1Z7   -Jaipur
R2   -R2Z1   -Mumbai
R3   -R3Z1   -Kolkatta
R3   -R3Z2   -Rest of East

code is:

protected void Page_Load(object sender, System.EventArgs e)
  {
   // Put user code to initialize the page here
   if (!IsPostBack)
   {
    SqlDataAdapter adapter = new SqlDataAdapter(
 "SELECT * from tbl1", "SERVER=local;DATABASE=mydata0607;UID=sa;pwd=sa");

    SqlDataAdapter adapter1 = new SqlDataAdapter("select * from tbl2", "SERVER=local;DATABASE=mydata0607;UID=sa;pwd=sa");
               
    DataSet data = new DataSet();
                adapter.Fill(data, "tbl1");
                adapter1.Fill(data, "tbl2");

                data.Tables[0].TableName = "tbl1";
                data.Tables[1].TableName = "tbl2";

                string relName = "tbl12tbl2";
                DataRelation rel = new DataRelation(relName,
                    data.Tables["tbl1"].Columns["RegionCode"],
                    data.Tables["tbl2"].Columns["RegionCode"]);
                data.Relations.Add(rel);

                    Cache["MyData"] = data;
   }
   
   BindData();
 }

  protected void UpdateView(object sender, System.EventArgs e)
  {
   BindData();
  }

 
  private void BindData()
  {
   // Bind the data source
   dataGrid.DataSource = (DataSet) Cache["MyData"];
            dataGrid.DataMember = "tbl1";

   // Bind the data
   dataGrid.DataBind();
  }

//'please help me...