public HtmlSelect FetchCourseMoLrnPtrnWiseLaunchedBranchListCombined(long UniID, long FacID, long CrID, long MoLrnID, long PtrnID, string HtmlSelCrBrnID, int LevelFlag) { DataTable dt = crRepository.ListCourseModeOfLearningPatternWiseLaunchedBranches(UniID, FacID, CrID, MoLrnID, PtrnID); HtmlSelect htmlSel = new HtmlSelect(); htmlSel.ID = HtmlSelCrBrnID; htmlSel.Attributes.Add("class", "selectbox"); htmlSel.Attributes.Add("onchange", "setValue(document.getElementById(hidBrnClientID).id,this.value);FillCoursePart(this.value);ClearDropDowns(3," + LevelFlag + ");"); htmlSel.DataSource = dt; if (dt.Rows.Count > 0) { htmlSel.DataTextField = "Text"; htmlSel.DataValueField = "Value"; htmlSel.DataBind(); ListItem li = new ListItem("--- Select ---", "-1"); htmlSel.Items.Insert(0, li); } else { htmlSel.DataBind(); ListItem li = new ListItem("--- No Branch ---", "-1"); htmlSel.Items.Insert(0, li); } return(htmlSel); }
public void SP_populateHTMLSelect(HtmlSelect GroupSelect, string sStoredProc, string sDVF, string sDTF, string sDefault, List <string> sParams) { SqlDataReader objDataReader = ExecuteReader(sConnection, sStoredProc, sParams); GroupSelect.DataSource = objDataReader; GroupSelect.DataValueField = sDVF; GroupSelect.DataTextField = sDTF; GroupSelect.DataBind(); if (sDefault == "N") { } else if (sDefault == "Y") { GroupSelect.Items.Insert(0, new ListItem("All", "0")); } else if (sDefault == "T") { GroupSelect.Items.Insert(0, new ListItem("Default, All", "0")); } else if (sDefault == "U") { GroupSelect.Items.Insert(0, new ListItem("Default, All", "0")); } else { GroupSelect.Items.Insert(0, new ListItem("-Please Select-", "0")); } }
public static void BindDropDownList(HtmlSelect Ddl, DataTable Dt, string Value, string Text) { Ddl.DataValueField = Value; Ddl.DataTextField = Text; Ddl.DataSource = Dt.DefaultView; Ddl.DataBind(); }
public HtmlSelect FetchCollegeWiseConfirmedFacultyListNew(string UniID, string InstID, string ddlFacDescID) { InstituteRepository oInstituteRepository = new InstituteRepository(); HtmlSelect htmlSel = new HtmlSelect(); DataTable listFaculty = oInstituteRepository.AssignedConfirmedFaculties(UniID, InstID.Split('|')[0]); try { if (listFaculty != null) { htmlSel.ID = ddlFacDescID; htmlSel.Attributes.Add("class", "selectbox"); htmlSel.Attributes.Add("onchange", "setValue(hid_Fac_id,this.value);FillCourse(this.value);ClearDropDowns(1,5)"); htmlSel.DataSource = listFaculty; htmlSel.DataTextField = "Fac_Desc"; htmlSel.DataValueField = "pk_Fac_ID"; htmlSel.DataBind(); ListItem li = new ListItem("--- Select ---", "-1"); htmlSel.Items.Insert(0, li); } } catch (Exception ex) { throw new Exception(ex.Message); } return(htmlSel); }
public void PopulateCombo1(string sql, string TextField, string ValueField, HtmlSelect Combo) { DBOpen(); try { DA = new SqlDataAdapter(sql, con); DS = new DataSet(); DA.Fill(DS); Combo.Items.Add(new ListItem("Please Select", "")); if (DS.Tables[0].Rows.Count > 0) { Combo.DataSource = DS; Combo.DataTextField = TextField; Combo.DataValueField = ValueField; Combo.DataBind(); } } catch (Exception EX) { } finally { DBClose(); DS.Dispose(); } }
/// <summary> /// 绑定方法自定义 /// </summary> /// <param name="dropdownlist">控件名称</param> /// <param name="dt">数据源</param> /// <param name="columeText">显示的文本</param> /// <param name="columnValue">隐藏在val里的值</param> /// <param name="columnParentsValue">mydata里的值</param> /// <param name="msg"></param> public void BindDdlParentsMore(HtmlSelect dropdownlist, DataTable dt, string columeText, string columnValue, string columnParentsValue, string msg) { if (dt.Rows.Count > 0) { dropdownlist.DataSource = dt; dropdownlist.DataTextField = columeText; dropdownlist.DataValueField = columnValue; dropdownlist.DataBind(); dropdownlist.Items.Insert(0, new ListItem(msg, "")); for (int i = 1; i < dropdownlist.Items.Count; i++) { for (int j = 0; j < dt.Rows.Count; j++) { string dd = dropdownlist.Items[i].Value; string ddd = dt.Rows[j][columnValue].ToString(); if (dropdownlist.Items[i].Value == dt.Rows[j][columnValue].ToString())//判断如果该行option的val值与dt的该行val值相等 { dropdownlist.Items[i].Attributes["mydata"] = dt.Rows[j][columnParentsValue].ToString(); break; } } } } else { dropdownlist.Items.Clear(); dropdownlist.Items.Insert(0, new ListItem(msg, "")); } }
/// <summary> /// This is a helper stub to fill a select in 1 line... /// </summary> /// <typeparam name="source">IEnumerable object to fill the select with</typeparam> /// <param name="nameCol">The parameterName to use for the DataTextField when filling the select</param> /// <param name="valCol">The parameterName to use for the DataValueField when filling the select</param> public static void FillSelect <t>(this HtmlSelect select, t source, string nameCol, string valCol) where t : IEnumerable { select.DataSource = source; select.DataTextField = nameCol; select.DataValueField = valCol; select.DataBind(); }
private HtmlSelect CreateSelect(Configuration.SearchInputFieldRow searchInputFieldRow) { HtmlSelect select = new HtmlSelect(); using (OleDbCommand command = searchInputFieldRow.GetDatabaseCommand()) { if (command.Parameters.Count > 0) { command.Parameters[0].Value = AppUser.GetRole(); } using (OleDbDataAdapter adapter = new OleDbDataAdapter(command)) { DataTable list = new DataTable(); adapter.Fill(list); select.DataSource = list; select.DataValueField = list.Columns[0].ColumnName; select.DataBind(); } command.Connection.Dispose(); } select.Items.Insert(0, new ListItem("", "")); return(select); }
public HtmlSelect FetchFacultyWiseLaunchedCourseList(long UniID, long FacID, string HtmlSelCrID, int LevelFlag) //Developed by Madhu { DataTable dt = crRepository.ListFacultyWiseLaunchedCourses(UniID, FacID); HtmlSelect htmlSel = new HtmlSelect(); htmlSel.ID = HtmlSelCrID; htmlSel.Attributes.Add("class", "selectbox"); if (LevelFlag <= 2) { htmlSel.Attributes.Add("onchange", "setValue(document.getElementById(hidCrClientID).id,this.value);"); } else { // htmlSel.Attributes.Add("onchange", "setValue(document.getElementById(hidCrClientID).id,this.value);FetchCourseWiseLaunchedModeOfLearningList('tdModeLrnDesc',document.getElementById(hidUniClientID).value,document.getElementById(hidFacClientID).value,document.getElementById(hidCrClientID).value,document.getElementByID(hidMoLrnClientID).id," + LevelFlag + ");ClearDropDowns(2," + LevelFlag + ");"); htmlSel.Attributes.Add("onchange", "setValue(document.getElementById(hidCrClientID).id,this.value);FetchCourseWiseLaunchedModeOfLearningList('tdModeLrnDesc',document.getElementById(hidUniClientID).value,document.getElementById(hidFacClientID).value,document.getElementById(hidCrClientID).value, ddlModeLrnDescClient ," + LevelFlag + ");ClearDropDowns(2," + LevelFlag + ");"); //document.getElementById(hidCrPrClientID).value = val; } htmlSel.DataSource = dt; htmlSel.DataTextField = "Text"; htmlSel.DataValueField = "Value"; htmlSel.DataBind(); ListItem li = new ListItem("--- Select ---", "-1"); htmlSel.Items.Insert(0, li); return(htmlSel); }
public void PopulateCombo1(string sql, string textfiled, string valuefield, HtmlSelect combo) { DBopen(); try { DA = new SqlDataAdapter(sql, con); DS = new DataSet(); DA.Fill(DS); //combo.Items.Add(0, "Please Select"); if (DS.Tables[0].Rows.Count > 0) { combo.DataSource = DS; combo.DataTextField = textfiled; combo.DataValueField = valuefield; combo.DataBind(); } } catch (Exception ex) { } finally { DBClose(); } }
/// <summary> /// 数据列表绑定 /// </summary> /// <param name="slt">列表对象</param> public void Bind(HtmlSelect slt) { slt.DataSource = this.EnumList; slt.DataTextField = "Name"; slt.DataValueField = "Num"; slt.DataBind(); }
private void AddSalesTypeField(HtmlGenericControl container) { using (HtmlGenericControl salesTypeDiv = HtmlControlHelper.GetField()) { salesTypeDiv.ID = "SalesTypeDiv"; salesTypeDiv.Attributes.Add("style", "width:200px"); using (HtmlGenericControl field = HtmlControlHelper.GetField()) { using (HtmlGenericControl label = HtmlControlHelper.GetLabel(Titles.SalesType, "SalesTypeSelect")) { field.Controls.Add(label); } using (HtmlSelect salesTypeSelect = new HtmlSelect()) { salesTypeSelect.ID = "SalesTypeSelect"; salesTypeSelect.DataSource = this.GetSalesTypes(); salesTypeSelect.DataTextField = "Text"; salesTypeSelect.DataValueField = "Value"; salesTypeSelect.DataBind(); field.Controls.Add(salesTypeSelect); } salesTypeDiv.Controls.Add(field); } container.Controls.Add(salesTypeDiv); } }
public HtmlSelect FetchCoursePartWiseCoursePartChildList(string UniID, string InstID, string FacID, string CrID, string MoLrnID, string PtrnID, string BrnID, string CrPrDetails_ID, string HtmlSelCrBrnID) { InstituteRepository oInstituteRepository = new InstituteRepository(); DataTable dt = oInstituteRepository.AssignCoursePartTerm(UniID, InstID, FacID, CrID, MoLrnID, PtrnID, BrnID, CrPrDetails_ID); HtmlSelect htmlSel = new HtmlSelect(); htmlSel.ID = HtmlSelCrBrnID; htmlSel.Attributes.Add("class", "selectbox"); // htmlSel.Attributes.Add("onchange", "FetchCourseMoLrnPtrnBrnWiseCoursePartList('tdCrPrDesc', hidUniID.value, hidFacID.value, hidCrID.value, hidMoLrnID.value, hidPtrnID.value, hidBrnID.value, 'ddlCrPrDesc'); ");//ClearDropDowns(5," + levelflag + ");"); //htmlSel.Attributes.Add("onchange", "setValue('hidCrPrID',this.value);"); htmlSel.Attributes.Add("onchange", "setCrPartTerm(this.value);"); //hCrPart.Attributes.Add("onchange", "setCrPart(this.value);"); htmlSel.DataSource = dt; htmlSel.DataTextField = "text"; htmlSel.DataValueField = "value"; htmlSel.Style.Add("width", "230px"); htmlSel.DataBind(); ListItem li = new ListItem("--- Select ---", "-1"); htmlSel.Items.Insert(0, li); return(htmlSel); }
public HtmlSelect FetchCourseMoLrnPtrnWiseLaunchedBranchWiseCrPartsCombined(long UniID, long FacID, long CrID, long MoLrnID, long PtrnID, long BrnID, string HtmlSelCrBrnID, int LevelFlag) { DataTable dt = crRepository.ListCourseModeOfLearningPatternBrnWiseLaunchedCourseParts(UniID, FacID, CrID, MoLrnID, PtrnID, BrnID); HtmlSelect htmlSel = new HtmlSelect(); htmlSel.ID = HtmlSelCrBrnID; htmlSel.Attributes.Add("class", "selectbox"); if (LevelFlag <= 5) { htmlSel.Attributes.Add("onchange", "setValue(document.getElementById(hid_CrPrDet_id).id,this.value);FillCrPartChild(this.value);ClearDropDowns(5," + LevelFlag + ");"); } else { //htmlSel.Attributes.Add("onchange", "setValue('hidBrnID',this.value);FetchCourseMoLrnPtrnBrnWiseLaunchedCoursePartList('tdCrPrDesc',hidUniID.value,hidFacID.value,hidCrID.value, hidMoLrnID.value, hidPtrnID.value, hidBrnID.value, 'ddlCrPrDesc'," + LevelFlag + ");ClearDropDowns(5," + LevelFlag + ");"); //htmlSel.Attributes.Add("onchange", "setValue(document.getElementById(hidBrnClientID).id,this.value);"); htmlSel.Attributes.Add("onchange", "setValue(document.getElementById(hid_CrPrDet_id).id,this.value);FillCrPartChild(this.value);ClearDropDowns(5," + LevelFlag + ");"); } //htmlSel.Attributes.Add("onchange", "setBranchDetails(this.value);"); htmlSel.DataSource = dt; htmlSel.DataTextField = "Text"; htmlSel.DataValueField = "Value"; htmlSel.DataBind(); ListItem li = new ListItem("--- Select ---", "-1"); htmlSel.Items.Insert(0, li); return(htmlSel); }
private void AddLanguageField(HtmlGenericControl container) { using (HtmlGenericControl field = new HtmlGenericControl("div")) { field.Attributes.Add("class", "field"); using (HtmlGenericControl label = HtmlControlHelper.GetLabel(Titles.SelectLanguage, "LanguageSelect")) { field.Controls.Add(label); } using (HtmlSelect languageSelect = new HtmlSelect()) { languageSelect.ID = "LanguageSelect"; languageSelect.DataTextField = "Text"; languageSelect.DataValueField = "Value"; languageSelect.DataSource = this.GetLanguages(); languageSelect.DataBind(); field.Controls.Add(languageSelect); } container.Controls.Add(field); } }
public HtmlSelect FetchCourseMoLrnwiseLaunchedCoursePatternsList(long UniID, long FacID, long CrID, long MoLrnID, string HtmlSelCrPtrnID, int LevelFlag) { DataTable dt = crRepository.ListCourseModeOfLearningWiseLaunchedCoursePatterns(UniID, FacID, CrID, MoLrnID); HtmlSelect htmlSel = new HtmlSelect(); htmlSel.ID = HtmlSelCrPtrnID; htmlSel.Attributes.Add("class", "selectbox"); if (LevelFlag <= 4) { htmlSel.Attributes.Add("onchange", "setValue(document.getElementById(hidPtrnClientID).id,this.value);"); } else { htmlSel.Attributes.Add("onchange", "setValue(document.getElementById(hidPtrnClientID).id,this.value);FetchCourseMoLrnPtrnWiseLaunchedBranchList('tdCrBrnDesc',document.getElementById(hidUniClientID).value,document.getElementById(hidFacClientID).value,document.getElementById(hidCrClientID).value, document.getElementById(hidMoLrnClientID).value, document.getElementById(hidPtrnClientID).value, ddlCrBrnDescClient ," + LevelFlag + ");ClearDropDowns(4," + LevelFlag + ");"); } htmlSel.DataSource = dt; htmlSel.DataTextField = "Text"; htmlSel.DataValueField = "Value"; htmlSel.DataBind(); ListItem li = new ListItem("--- Select ---", "-1"); htmlSel.Items.Insert(0, li); return(htmlSel); }
public static void SetHtmlSelect(HtmlSelect list) { list.DataSource = GetDataTable(); list.DataTextField = "Name"; list.DataValueField = "Value"; list.DataBind(); }
private void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 if (!Page.IsPostBack) { DeptID = (Request.QueryString["DeptID"] == null)?"":Request.QueryString["DeptID"].ToString(); displayType = (Request.QueryString["displayType"] == null)?"":Request.QueryString["displayType"].ToString(); selectedID = (Request.QueryString["StaffIDS"] == null)?"":Request.QueryString["StaffIDS"].ToString(); backfilepath = (Request.QueryString["BackFilePath"] == null)?"":Request.QueryString["BackFilePath"].ToString(); SqlDataReader dr; UDS.Components.Database db = new UDS.Components.Database(); db.RunProc("SP_Ext_GetDepartment", out dr); Department.DataSource = dr; Department.DataTextField = "Department_Name"; Department.DataValueField = "Department_ID"; Department.DataBind(); } if (Request.QueryString["ReturnPage"] != null) { ReturnPage = Int32.Parse(Request.QueryString["ReturnPage"].ToString()); } else { ReturnPage = 0; } }
//允许显示的菜单栏目 private void CreateRightAccount(HtmlSelect listcontrolright, int TopMenuId) { Johnny.CMS.BLL.SystemInfo.TopMenuBinding bll = new Johnny.CMS.BLL.SystemInfo.TopMenuBinding(); listcontrolright.DataSource = bll.GetList(TopMenuId); listcontrolright.DataTextField = "MenuCategoryName"; listcontrolright.DataValueField = "MenuCategoryId"; listcontrolright.DataBind(); }
//拥有权限 private void CreateRightAccount(HtmlSelect listcontrolright, int TopMenuId) { Johnny.CMS.BLL.Access.RolePermission bll = new Johnny.CMS.BLL.Access.RolePermission(); listcontrolright.DataSource = bll.GetList(RoleId, PermissionCategoryId); listcontrolright.DataTextField = "PermissionName"; listcontrolright.DataValueField = "PermissionId"; listcontrolright.DataBind(); }
public static void BindDropDownList(HtmlSelect Ddl, DataTable Dt, string Value, string Text, string DefaultValue, string DefaultText) { Ddl.DataValueField = Value; Ddl.DataTextField = Text; Ddl.DataSource = Dt.DefaultView; Ddl.DataBind(); Ddl.Items.Insert(0, new ListItem("", "")); }
public static void LoadCombobox(HtmlSelect sl, string sql, string Text, string Value, string TextSelect) { sl.DataSource = Connect.GetTable(sql); sl.DataTextField = Text; sl.DataValueField = Value; sl.DataBind(); sl.Items.Add(new ListItem(TextSelect, "-1")); sl.Items.FindByValue("-1").Selected = true; }
/// <summary> /// 绑定HtmlSelect /// </summary> public static void BindCtrlHTMLDDL(DataSet ds, string textField, string valueField, HtmlSelect ddlControlName) { if (ddlControlName.Items.Count <= 1) { ddlControlName.DataSource = ds; ddlControlName.DataTextField = textField; ddlControlName.DataValueField = valueField; ddlControlName.DataBind(); } }
/// <summary> /// 绑定HtmlSelect带默认值 /// </summary> public static void BindCtrlHTMLDDL(DataSet ds, string textField, string valueField, HtmlSelect ddlControlName, string ddlDefaultValue) { if (ddlControlName.Items.Count <= 1) { ddlControlName.DataSource = ds; ddlControlName.DataTextField = textField; ddlControlName.DataValueField = valueField; ddlControlName.DataBind(); ddlControlName.Items.FindByValue(ddlDefaultValue).Selected = true; } }
public static void LoadDropDownList(HtmlSelect ddl, string StringArray) { string[] myArr = ConvertToArray(StringArray); List <ListItem> items = StringArray2ListItem(myArr); for (int i = 0; i < items.Count; i++) { ddl.Items.Add(items[i]); } ddl.DataBind(); }
/// <summary> /// 绑定IList<T>:HtmlSelect下拉列表框 /// </summary> /// <param name="dt">DataTable</param> /// <param name="dropdownlists">控件名称</param> /// <param name="_Name">绑定字段名称</param> /// <param name="_ID">绑定字段主键</param> /// <param name="_Memo">默认显示值</param> public static void BindHtmlSelect <T>(IList <T> list, HtmlSelect select, string _Name, string _ID, string _Memo) { select.DataSource = list; select.DataTextField = _Name; select.DataValueField = _ID; select.DataBind(); if (!string.IsNullOrEmpty(_Memo.Trim())) { select.Items.Insert(0, new ListItem(_Memo, "")); } }
//数据绑定HtmlSelect public static void BindHtmlSelect(HtmlSelect objTmp, string strValueField, string strTextField, string strSql) { objTmp.Items.Clear(); DataTable dt; dt = SqlHelper.GetTable(strSql); objTmp.DataSource = dt; objTmp.DataValueField = strValueField; objTmp.DataTextField = strTextField; objTmp.DataBind(); }
/// <summary> /// 绑定DataTable:HtmlSelect下拉列表框 /// </summary> /// <param name="dt">DataTable</param> /// <param name="dropdownlists">控件名称</param> /// <param name="_Name">绑定字段名称</param> /// <param name="_ID">绑定字段主键</param> /// <param name="_Memo">默认显示值</param> public static void BindHtmlSelect(DataTable dt, HtmlSelect select, string _Name, string _ID, string _Memo) { select.DataSource = dt; select.DataTextField = _Name; select.DataValueField = _ID; select.Attributes.Add("title", "123"); select.DataBind(); if (!string.IsNullOrEmpty(_Memo.Trim())) { select.Items.Insert(0, new ListItem(_Memo, "")); } }
/// <summary> /// 绑定路局 /// </summary> public static void Bind_DDLLj(HtmlSelect ddlLjbh) { DataTable dt = DAL_G_Common.GetList("ShLjb", ""); if (dt.Rows.Count > 0) { ddlLjbh.DataSource = dt; ddlLjbh.DataBind(); } ddlLjbh.Items.Add("==请选择=="); ddlLjbh.SelectedIndex = ddlLjbh.Items.Count - 1; }
/// <summary> /// 绑定所属段 /// </summary> public static void Bind_DDL_Ssgwd(HtmlSelect ddlGwdID, string strWhere) { DataTable dt = DAL_G_Common.GetList("ShJwd", strWhere); if (dt.Rows.Count > 0) { ddlGwdID.DataSource = dt; ddlGwdID.DataBind(); } ddlGwdID.Items.Add("==请选择=="); ddlGwdID.SelectedIndex = ddlGwdID.Items.Count - 1; }
private HtmlSelect CreateSelect(Configuration.SearchInputFieldRow searchInputFieldRow) { HtmlSelect select = new HtmlSelect(); using (OleDbCommand command = searchInputFieldRow.GetDatabaseCommand()) { if (command.Parameters.Count > 0) { command.Parameters[0].Value = AppUser.GetRole(); } using (OleDbDataAdapter adapter = new OleDbDataAdapter(command)) { DataTable list = new DataTable(); adapter.Fill(list); select.DataSource = list; select.DataValueField = list.Columns[0].ColumnName; select.DataBind(); } command.Connection.Dispose(); } select.Items.Insert(0, new ListItem("", "")); return select; }