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
}
}
}
