Cannot have multiple items selected in a DropDownList
protected void Page_Load(object sender, EventArgs e) { for (int month = 1; month < 13; month++) { ddlMonth.Items.Add(month.ToString()); } ddlMonth.Items.FindByValue(System.DateTime.Now.Month.ToString()).Selected = true; for (int year = 1947; year < 2015; year++) { ddlYear.Items.Add(year.ToString()); } ddlYear.Items.FindByValue(System.DateTime.Now.Year.ToString()).Selected = true; FillDays(); } public void FillDays() { ddlDate.Items.Clear(); //getting number of days in selected month & year int noofdays = DateTime.DaysInMonth(Convert.ToInt32(ddlYear.SelectedValue), Convert.ToInt32(ddlMonth.SelectedValue)); //Fill days for (int i = 1; i <= noofdays; i++) { ddlDate.Items.Add(i.ToString()); } ddlDate.Items.FindByValue(System.DateTime.Now.Day.ToString()).Selected = true;// Set current date as selected } protected void save_Click(object sender, EventArgs e) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "Insert_Reminder"; cmd.CommandType = CommandType.StoredProcedure; string datestring = string.Format("{0}-{1}-{2}", ddlMonth.SelectedValue, ddlDate.SelectedValue.PadLeft(2, '0'), ddlYear.SelectedValue.PadLeft(2, '0')); string timestring = ddlHour.SelectedValue +":"+ddlMinute.SelectedValue +":"+ddlsecond.SelectedValue; cmd.Parameters.Add("@birthdate",SqlDbType.Date).Value=datestring; cmd.Parameters.Add("@reminder_time", SqlDbType.Time).Value = timestring.Trim(); cmd.Parameters.Add("@reminder_detail", SqlDbType.Text).Value = txt_reminder.Text.Trim(); cmd.Connection=con; try { con.Open(); cmd.ExecuteNonQuery(); Response.Write("<script>alert('Data Inserted Successfully')</script>"); } catch(Exception ex) { Response.Write(ex.Message); } finally { con.Close(); con.Dispose(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)