protected void DropDownListProject_SelectedIndexChanged1(object sender, EventArgs e)
{
if (DropDownListProject.SelectedIndex != 0)
{
string strTrans = string.Empty;
SqlCommand cmd = new SqlCommand("select TransportAgency from project where proCode='" + DropDownListProject.SelectedValue.ToString() + "'", con);
con.Open();
strTrans = (string)cmd.ExecuteScalar();
con.Close();
txtTransport.Text = strTrans;
}
}