If you need to populate all the data..then do the following
DataTable dtb = new DataTable();
foreach (DataRow row in ds1.Rows)
{
DataSet ds = new DataSet();
string CountryId = row["Member_Name"].ToString();
SqlCommand cmd = new SqlCommand("select Member_Name,Id,Gender,Member_DOB,[Placement_Side],[City],[Join_Date],IntroducerID,SponsorID,Introducer_Name from Member_registration where Introducer_Name='" + CountryId + "' ", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
foreach (DataRow dr in ds.Rows)
{
dtb.ImportRows(dr);
}
con.Close();
}
gv.DataSource = dtb;
gv.DataBind();
Regards,
Dinesh Kumar.V.