void loadState()
{
conn.Open();
cmd = new SqlCommand("select stateid, statename from states", conn);
ListState.DataSource = cmd.ExecuteReader();
ListState.DataTextField = "statename";
ListState.DataValueField = "stateid";
ListState.DataBind();
conn.Close();
}
