how to fill the datagridview2 with information from datagridivew1 c#

i give u an example...

design sql table as below..[set primary key to city]

country city

india chennai
india bangalore

india hydrabad

usa newyork

usa washington

china beiging


set AutopostBack property to True for both Countrydropdownlist and citydropdownlist.

now write query as


function country()
{
string strSQL;
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
strSQL = "SELECT select country from tablename ";
SqlCommand cmdFloorType = new SqlCommand(strSQL, sqlConn);
SqlDataReader drFloor = cmdFloorType.ExecuteReader();
while (drFloor.Read())
{
countryDrpdownlist.Items.Add( drFloor[0]).ToString();

}

sqlConn.Close();
}

call that function into page_load event

page_load()
{
if(!Ispostback)
{
country()
}
now double click countrydropdownlist and write coding

ddlcountry_selectedItem()
{
string strSQL;
string dbConn = ConfigurationManager.ConnectionStrings["CMC"].ConnectionString;
SqlConnection sqlConn = new SqlConnection(dbConn);
sqlConn.Open();
strSQL = "SELECT select City from tablename where Country='"+countryDropdowlist.selectedItem.Tostring()+"' ";
SqlCommand cmdFloorType = new SqlCommand(strSQL, sqlConn);
SqlDataReader drFloor = cmdFloorType.ExecuteReader();
while (drFloor.Read())
{
cityDrpdownlist.Items.Add( drFloor[0]).ToString();

}

sqlConn.Close();
}

}