Problem in the application after enabling cascading dropdownlist

For Ex: I'm having Country and State in my Gridview as both Country & State as Dropdownlist. Now after selecting the Country, in the state dropdownlist the states which are tagged to that particular country should list down the values from the database. How to do this without using cascading? Please give the sample code in C#. Thanks.

This is the code using inside the Gridview_RowDataBound

if (e.Row.RowType == DataControlRowType.DataRow)
{
con.Open();
DropDownList ddl = e.Row.FindControl("DropDownList2") as DropDownList;
SqlCommand cmd = new SqlCommand("Select a1.CountryName from Country a1 order by a1.CountryName", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
ddl.DataSource = ds;
ddl.DataTextField = "CountryName";
ddl.DataValueField = "CountryName";
ddl.DataBind();
ddl.Items.Insert(0, new ListItem("--Select--", "0"));

con.Open();
DropDownList ddl2 = e.Row.FindControl("DropDownList3") as DropDownList;
//DropDownList ddl3 = e.Row.FindControl("DropDownList2") as DropDownList;
SqlCommand cmd1 = new SqlCommand("Select a1.StateName from State a1 Join Country a2 on a1.CountryName=a2.CountryName where a2.CountryName='" + ddl.SelectedItem.Selected + "' order by a1.StateName", con);
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
DataSet de = new DataSet();
da1.Fill(de);
con.Close();
ddl2.DataSource = de;
ddl2.DataTextField = "StateName";
ddl2.DataValueField = "StateName";
ddl2.DataBind();
ddl2.Items.Insert(0, new ListItem("--Select--", "0"));
}


But this is not getting the State Names which are under the selected Country.