My code below does not display any err msg but it is not displaying the desired result. I am querying a database using a dropdown list control and I want the result to display on specified textboxes.


protected void stateList_SelectedIndexChanged(object sender, EventArgs e)
{

sqlquerypopulation.SelectCommandType = SqlDataSourceCommandType.Text;
String qry = "select Males,Females,Bothsexes,Landsize from Population where LGA = '"+ stateList.SelectedItem.Value.ToString()+"'";
System.Data.SqlClient.SqlConnection myCon = new System.Data.SqlClient.SqlConnection("server=BANCAS S\\SQLEXPRESS;database=Ruralconnect;uid=sa;pwd=");
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(qry,myCon);
myCon.Open();
System.Data.SqlClient.SqlDataReader dr = cmd.ExecuteReader();
if(dr.Read()) {
txtpopulate.Text = dr[0].ToString ();
male.Text = dr[1].ToString ();
fmale.Text = dr [2].ToString ();
bsexes.Text = dr [3].ToString ();
landsize.Text = dr[4].ToString ();

}
dr.Close();
myCon.Close();


}