protected void ddl_Location_SelectedIndexChanged(object sender, EventArgs e) { String filmCode = ddl_Play.SelectedValue; String Location = ddl_Location.SelectedValue; dateofshow.Text = "Select"; ddl_Date.Items.Clear(); ddl_Date.Items.Add(new ListItem("Select", "0")); ddl_Date.Items[0].Selected = true; DataTable dtplaydate = VistaBOL.Select_AuditPlayDate(Location, filmCode); foreach (DataRow dr in dtplaydate.Rows) { if (!(dr[0].ToString().Equals("2012.12.31"))) { ddl_Date.Items.Add(new ListItem(Convert.ToDateTime(dr[0].ToString()).ToString("ddd, MMM dd,yyyy"), Convert.ToDateTime(dr[0].ToString()).ToString("dd/MM/yyyy"))); } } }