Hi,

 I am new to gridview control. have nested a gridview inside another gridview. The address details in the child gridview is repeating  for all users(candidate name)  and I m not  getting corresponding address for each users.
Plz help me as soon as possible.. here is the code have
 
// Parent Gridview Binding
public void BindData()
    {

           SqlConnection con=new SqlConnection("Server:localhost;Uid=;Password=;Database="Employee");
          SqlCommand cmd=new SqlCommand("Select * from Employee",con);
          SqlDataAdapter da=new SalDataAdapter();
           Dataset ds=new DataSet();
           da.Fill(ds);
 
        ParentGrid.DataSource = ds.Tables[0] ;
        ParentGrid.DataBind();
  
    
    }


//Child Gridview Binding


 protected void ParentGrid_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {


       SqlConnection con=new SqlConnection("Server:localhost;Uid=;Password=;Database="Employee");
           SqlCommand cmd=new SqlCommand("Select Address,Mobile from Employee",con);
           SqlDataAdapter da=new SalDataAdapter();
           Dataset ds=new DataSet();
           da.Fill(ds);
    
            GridView gv2 = new  GridView();

            (GridView)gv2 = ( GridView)e.Row.FindControl("ChildGrid");

           
            gv2.DataSource = ds.Tables[0];
            gv2.DataBind();

        }
}

mr_rajesh86:

SqlCommand cmd=new SqlCommand("Select Address,Mobile from Employee",con);

It’s probably because you’re missing a ‘where’ clause on the line above.

mr_rajesh86:

           SqlCommand cmd=new SqlCommand("Select Address,Mobile from Employee",con);
           SqlDataAdapter da=new SalDataAdapter();
           Dataset ds=new DataSet();
           da.Fill(ds);

You're also not associating cmd with da so you need to say:

da.SelectCommand = cmd;

or initialise ds like so:

Dataset ds=new DataSet(cmd);
 

hi.

    Thanks a lot. 

No worries