protected void DDLJobGroup_SelectedIndexChanged(object sender, EventArgs e) { JobRepository jr = new JobRepository(); DDLJob.DataSource = jr.getJobsByGroupID(DDLJobGroup.SelectedValue.ToString().ToInt()); DDLJob.DataTextField = "JobTitle"; DDLJob.DataValueField = "JobID"; DDLJob.DataBind(); DDLJob.Items.Insert(0, new ListItem("-", "-1")); tbxSearch.Value = ""; }
private void ShowJobInfo() { string strConn = ConfigurationSettings.AppSettings["strConn"]; SqlConnection SqlConn = new SqlConnection(strConn); SqlDataAdapter SqlCmd = new SqlDataAdapter("select * from JobInfo", SqlConn); DataSet SqlDS = new DataSet(); SqlCmd.Fill(SqlDS, "JobInfo"); DDLJob.DataSource = SqlDS.Tables["JobInfo"].DefaultView; DDLJob.DataTextField = "JobName"; DDLJob.DataValueField = "JobID"; DDLJob.DataBind(); SqlConn.Dispose(); ListItem strTmp = new ListItem("--请选择--", "0"); DDLJob.Items.Add(strTmp); }
private void fillDDLs() { JobGroupsRepository r = new JobGroupsRepository(); DDLJobGroup.DataSource = r.getJobGroups(); DDLJobGroup.DataTextField = "JobGroupTitle"; DDLJobGroup.DataValueField = "JobGroupID"; DDLJobGroup.DataBind(); DDLJobGroup.Items.Insert(0, new ListItem("-", "-1")); JobRepository jr = new JobRepository(); DDLJob.DataSource = jr.getJobsByGroupID(DDLJobGroup.SelectedValue.ToString().ToInt()); DDLJob.DataTextField = "JobTitle"; DDLJob.DataValueField = "JobID"; DDLJob.DataBind(); DDLJob.Items.Insert(0, new ListItem("-", "-1")); }