protected void departon_SelectedIndexChanged(object sender, EventArgs e) { if (departon.SelectedIndex == 0) { DepartureTime.Enabled = false; } else { DepartureTime.Enabled = true; } string connStr = ConfigurationManager.ConnectionStrings["BusTicketingConnectionString"].ConnectionString; DepartureTime.Items.Clear(); DataTable dtime = new DataTable(); using (SqlConnection con = new SqlConnection(connStr)) { try { SqlDataAdapter adapter = new SqlDataAdapter("SELECT departTime FROM dbo.Schedule WHERE departureDate='" + departon.SelectedValue + "'", con); adapter.Fill(dtime); DepartureTime.DataSource = dtime; DepartureTime.DataTextField = "departTime"; DepartureTime.DataValueField = "departTime"; DepartureTime.DataBind(); } catch (Exception ex) { // Handle the error } } }