protected void LoadDropDownListVenue() { string[] venues = db.GetVenues(); DropDownListVenue.DataSource = venues; DropDownListVenue.DataBind(); DropDownListVenue.Items.Insert(0, "Choose a Venue"); }
private void BindDropDown() { PmsSysBiz pmsSysBiz = new PmsSysBiz(); IList <PmsSys> listPmsSys = pmsSysBiz.SelectData2ByTypeData1("PM", "MeetingMinute", "MeetingType"); DropDownListMeetingMinuteType.DataSource = listPmsSys; DropDownListMeetingMinuteType.DataTextField = "data2"; DropDownListMeetingMinuteType.DataValueField = "data2"; DropDownListMeetingMinuteType.DataBind(); DropDownListMeetingMinuteType.Items.Insert(0, new ListItem()); DropDownListMeetingMinuteType.Items[0].Text = ""; DropDownListMeetingMinuteType.Items[0].Value = ""; IList <PmsSys> listPmsSysVenue = pmsSysBiz.SelectData2ByTypeData1("PM", "MeetingMinute", "Venue"); DropDownListVenue.DataSource = listPmsSysVenue; DropDownListVenue.DataTextField = "data2"; DropDownListVenue.DataValueField = "data2"; DropDownListVenue.DataBind(); DropDownListVenue.Items.Insert(0, new ListItem()); DropDownListVenue.Items[0].Text = ""; DropDownListVenue.Items[0].Value = ""; IList <PmsSys> listPmsSysHour = pmsSysBiz.SelectData2ByTypeData1("PM", "MeetingTime", "Hour"); DropDownListStartHour.DataSource = listPmsSysHour; DropDownListStartHour.DataTextField = "data2"; DropDownListStartHour.DataValueField = "data2"; DropDownListStartHour.DataBind(); DropDownListEndHour.DataSource = listPmsSysHour; DropDownListEndHour.DataTextField = "data2"; DropDownListEndHour.DataValueField = "data2"; DropDownListEndHour.DataBind(); // 选中 10; IList <PmsSys> listPmsSysMinute = pmsSysBiz.SelectData2ByTypeData1("PM", "MeetingTime", "Minute"); DropDownListStartMinute.DataSource = listPmsSysMinute; DropDownListStartMinute.DataTextField = "data2"; DropDownListStartMinute.DataValueField = "data2"; DropDownListStartMinute.DataBind(); DropDownListEndMinute.DataSource = listPmsSysMinute; DropDownListEndMinute.DataTextField = "data2"; DropDownListEndMinute.DataValueField = "data2"; DropDownListEndMinute.DataBind(); //选中 00; }
protected void Page_Load(object sender, EventArgs e) { Calendar1.SelectedDate = DateTime.Today; if (User.Identity.IsAuthenticated) { string username = User.Identity.Name; userName.Text = username; } if (!IsPostBack) { string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { //for event dropdown SqlCommand cmd = new SqlCommand("Select eId, eName from tblEvents", con); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); DropDownListEvents.DataTextField = "eName"; DropDownListEvents.DataValueField = "eId"; DropDownListEvents.DataSource = rdr; DropDownListEvents.DataBind(); } using (SqlConnection con2 = new SqlConnection(CS)) { //for venue dropdown SqlCommand cmd2 = new SqlCommand("Select vId, vName, vLocation, vImage, vDescription, vCapacity from tblVenues", con2); con2.Open(); SqlDataReader rdr2 = cmd2.ExecuteReader(); DropDownListVenue.DataTextField = "vName"; DropDownListVenue.DataValueField = "vId"; DropDownListVenue.DataSource = rdr2; DropDownListVenue.DataBind(); } } }