protected void dateofshow_TextChanged(object sender, EventArgs e) { String PlayDate; if (dateofshow.Text.ToString() == "" || dateofshow.Text.ToString() == "Select") { PlayDate = "0"; dateofshow.Text = "Select"; } else { PlayDate = Convert.ToDateTime(dateofshow.Text.ToString()).ToString("dd/MM/yyyy"); } String filmCode = ddl_Play.SelectedValue; String Location = ddl_Location.SelectedValue; ddl_ShowTimes.Items.Clear(); ddl_ShowTimes.Items.Add(new ListItem("Select", "0")); foreach (DataRow dr in VistaBOL.Select_PlayTime_AuditReport(Location, filmCode, PlayDate).Rows) { ddl_ShowTimes.Items.Add(new ListItem(Convert.ToDateTime(dr[0].ToString()).ToShortTimeString(), dr[1].ToString().Trim())); } }