public void LoadCtls() { string strSQL = "SELECT * FROM LK_BoardType WHERE BoardCategory = 1 ORDER BY iValue"; IDBManager dbManager = new DBManager(DataProvider.SqlServer); dbManager.ConnectionString = ConfigurationManager.ConnectionStrings["myConn"].ConnectionString; DataSet dsItems = new DataSet(); try { dbManager.Open(); dsItems = dbManager.ExecuteDataSet(CommandType.Text, strSQL); cboBoardType.Items.Clear(); cboBoardType.DataSource = dsItems; cboBoardType.DataMember = dsItems.Tables[0].ToString(); cboBoardType.DataTextField = "BoardType"; cboBoardType.DataValueField = "iValue"; cboBoardType.DataBind(); cboBoardType.Items.Add("Pick one"); cboBoardType.ClearSelection(); cboBoardType.SelectedIndex = cboBoardType.Items.Count - 1; } catch (Exception ex) { ErrorLog.ErrorRoutine(false, "AddAlert:LoadCtls:Error:" + ex.Message); } finally { dbManager.Close(); dbManager.Dispose(); } }
public void BindEnumToDDL(System.Web.UI.WebControls.DropDownList ddl, Enum e) { FieldInfo[] fs = e.GetType().GetFields(); DataTable dt = new DataTable(); DataColumn dc = new DataColumn("Text"); dt.Columns.Add(dc); dc = new DataColumn("Value"); dt.Columns.Add(dc); DataRow dr; foreach (FieldInfo f in fs) { dr = dt.NewRow(); dr[0] = f.Name; if (f.IsPublic) { dr[1] = (e.GetType().InvokeMember(f.Name, BindingFlags.GetField, null, null, null)).ToString(); } dt.Rows.Add(dr); } ddl.DataSource = dt; ddl.DataValueField = "Value"; ddl.DataTextField = "Text"; ddl.DataBind(); ddl.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--请选择--", "0")); }
public static void BindProperty(System.Web.UI.WebControls.DropDownList ddl, DataTable dt) { ddl.DataSource = dt; ddl.DataTextField = "Text"; ddl.DataValueField = "Value"; ddl.DataBind(); }
public static object DropDownFillCity(System.Web.UI.WebControls.DropDownList Dropdown, string stateid) { OracleConnection connection = new OracleConnection(); String query; String DISTINCT = ""; query = "Select var_city_name,num_city_id from AOUP_LCOPRE_CITY_DEF where num_city_stateid = " + stateid + " order by var_city_name"; connection = new OracleConnection(ConfigurationSettings.AppSettings["ConString"].ToString().Trim()); connection.Open(); OracleCommand cmd = new OracleCommand(query, connection); OracleDataReader dr = cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Columns.Add("var_city_name", typeof(String)); dt.Columns.Add("num_city_id", typeof(String)); dt.Rows.Add("-- Select City --", 0); while (dr.Read()) { dt.Rows.Add(dr[0].ToString(), dr[1].ToString()); } Dropdown.DataSource = dt; Dropdown.DataTextField = dt.Columns[0].ToString(); Dropdown.DataValueField = dt.Columns[1].ToString(); Dropdown.DataBind(); connection.Close(); return(Dropdown); }
public static void BindToDropDownFromDescriptions(ref System.Web.UI.WebControls.DropDownList ddl, Type enumType, ListItemSortType sortType) { ddl.DataSource = GetItemListByDescription(enumType, sortType); ddl.DataTextField = "key"; ddl.DataValueField = "value"; ddl.DataBind(); }
/// <summary> /// Bind ListDictionaryStringString to DropDownList the val is the first column and txt is second /// </summary> /// <param name="ddl"></param> /// <param name="ldss"></param> /// <param name="dataTextField"></param> /// <param name="dataValueField"></param> public static void DropDownListBindData(System.Web.UI.WebControls.DropDownList ddl, List <Dictionary <string, string> > ldss, string dataTextField = "txt", string dataValueField = "val") { try { ddl.DataTextField = dataTextField; ddl.DataValueField = dataValueField; System.Data.DataTable dt = new System.Data.DataTable(); dt.Columns.Add(dataValueField); dt.Columns.Add(dataTextField); ldss.Select(delegate(Dictionary <String, String> _dss) { try { System.Data.DataRow dr = dt.NewRow(); // dr.ItemArray = _dss.Select((KeyValuePair<string, string> x, int i) => { return x.Value; }).ToArray(); dr.ItemArray = new object[] { _dss[dataValueField], _dss[dataTextField] }; dt.Rows.Add(dr); } catch (Exception exa) { } return(_dss); }).ToArray(); ddl.DataSource = dt; ddl.DataBind(); } catch (Exception ex) { ddl.SelectedValue = ddl.Items[0].Value; } }
public void BindAllReturnInstitutions(System.Web.UI.WebControls.DropDownList ddplist, int ritypeid) { DataTable dataTable = new DataTable(); if (ritypeid > 0) { List <QueryStore> result = new List <QueryStore>(); string sqlQuery = String.Format("SELECT a.ri_id, a.fullname FROM t_core_reporting_institution a JOIN t_core_ri_mapping b ON a.ri_id = b.ri_id JOIN t_core_ri_type c ON b.ri_type_id = c.ri_type_id WHERE c.ri_type_id = @ritypeid"); using (SqlCommand command = new SqlCommand(sqlQuery, DatabaseOps.OpenSqlConnection())) { command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@ritypeid", ritypeid); SqlDataAdapter adapter = new SqlDataAdapter(command); adapter.Fill(dataTable); ddplist.DataSource = dataTable; ddplist.DataValueField = "ri_id"; ddplist.DataTextField = "fullname"; ddplist.DataBind(); ddplist.Items.Insert(0, "-Select Institution-"); } } }
/// <summary> /// 绑定菜单下拉列表——显示所有的数据 /// </summary> public void BandDropDownListShowUnit(Page page, System.Web.UI.WebControls.DropDownList ddl) { //在内存中筛选记录 var dt = DataTableHelper.GetFilterData(GetDataTable(), "1", "1", PROD_UNITTable.Id, " asc"); try { //显示值 ddl.DataTextField = PROD_UNITTable.UNIT_NAME; //显示key ddl.DataValueField = PROD_UNITTable.UNIT_ID; //数据层次 //绑定数据源 ddl.DataSource = dt; ddl.DataBind(); //ddl.SelectedIndex = 0; //ddl.Items.Insert(0, new FineUI.ListItem("请选择大类", "")); //ddl.SelectedValue = ""; } catch (Exception e) { // 记录日志 CommonBll.WriteLog("", e); } }
/// <summary> /// 绑定菜单下拉列表——显示所有的数据 /// </summary> public void BandDropDownListShowProductName_1(Page page, System.Web.UI.WebControls.DropDownList ddl) { //在内存中筛选记录 var dt = DataTableHelper.GetFilterData(GetDataTable(), "1", "1", PRODUCT00Table.Id, ""); try { //显示值 // ddl.DataTextField = PRODUCT00Table.PROD_NAME1; //显示key // ddl.DataValueField = PRODUCT00Table.PROD_ID; //数据层次 //绑定数据源 //绑定数据源 //ddl.DataSource = dt; //ddl.DataBind(); ddl.DataTextField = PRODUCT00Table.PROD_NAME1; ddl.DataValueField = PRODUCT00Table.PROD_ID; ddl.DataSource = dt; ddl.DataBind(); //ddl.Items.Insert(0, new FineUI.ListItem("请选择", "0")); //ddl.SelectedValue = "0"; } catch (Exception e) { // 记录日志 CommonBll.WriteLog("", e); } }
public static void ddlNationLoad(System.Web.UI.WebControls.DropDownList ddl) { ddl.DataSource = Db.ExecuteQuery("SELECT nationId,commonName FROM nation ORDER BY nationId", out bool boolDbError, out string strDbError); ddl.DataTextField = "commonName"; ddl.DataValueField = "nationId"; ddl.DataBind(); }
public override System.Web.UI.Control RenderControl(DataEditorSetting sender) { ddl.ID = sender.GetName(); ddl.Items.Clear(); List <KeyValuePair <String, String> > items = new List <KeyValuePair <String, String> >(); string[] preValuesSource = { "@createDate", "@creatorName", "@level", "@nodeType", "@nodeTypeAlias", "@pageID", "@pageName", "@parentID", "@path", "@template", "@updateDate", "@writerID", "@writerName" }; string fieldSql = "select distinct alias from cmsPropertyType order by alias"; IRecordsReader dataTypes = umbraco.BusinessLogic.Application.SqlHelper.ExecuteReader(fieldSql); ddl.DataTextField = "alias"; ddl.DataValueField = "alias"; ddl.DataSource = dataTypes; ddl.DataBind(); foreach (string s in preValuesSource) { ddl.Items.Add(new System.Web.UI.WebControls.ListItem(s, s.Replace("@", ""))); } System.Web.UI.WebControls.ListItem li = new System.Web.UI.WebControls.ListItem("Choose...", ""); li.Selected = true; ddl.Items.Insert(0, li); ddl.SelectedValue = _val; return(ddl); }
private void BindData(DbObject dbobj) { DataSet dsobj = new DataSet(); SqlParameter[] parameters2 = { new SqlParameter("@OrgId", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Default, OrgId), }; dsobj = dbobj.dsRunProcedure("sp_SelectEquipAltLists", parameters2, "Lists"); ddStatusId.DataSource = dsobj; ddStatusId.DataMember = "Lists"; ddStatusId.DataValueField = "id"; ddStatusId.DataTextField = "vchName"; ddStatusId.DataBind(); ddPMScheduleId.DataSource = dsobj; ddPMScheduleId.DataMember = "Lists1"; ddPMScheduleId.DataValueField = "id"; ddPMScheduleId.DataTextField = "vchName"; ddPMScheduleId.DataBind(); ddPMScheduleId.Items.Insert(0, ""); ddInspectionId.DataSource = dsobj; ddInspectionId.DataMember = "Lists2"; ddInspectionId.DataValueField = "id"; ddInspectionId.DataTextField = "vchName"; ddInspectionId.DataBind(); ddInspectionId.Items.Insert(0, ""); }
/// <summary> /// 下拉列表绑定数据 /// </summary> /// <param name="dropDownList">下列表框</param> /// <param name="dt">数据源</param> /// <param name="dataTextField"></param> /// <param name="dataValueField"></param> public static void SetDropDownListDataBind(this System.Web.UI.WebControls.DropDownList dropDownList, DataTable dt, string dataTextField, string dataValueField) { if (null == dropDownList) { return; } if (null == dt) { return; } if (true == dataTextField.AsNullOrWhiteSpace()) { return; } if (true == dataValueField.AsNullOrWhiteSpace()) { return; } if (0 == dt.Rows.Count) { return; } dropDownList.DataSource = dt; dropDownList.DataTextField = dataTextField; dropDownList.DataValueField = dataValueField; dropDownList.DataBind(); }
/// <summary> /// 绑定菜单下拉列表——显示所有的数据 /// </summary> public void BandDropDownListShowKind(Page page, System.Web.UI.WebControls.DropDownList ddl) { //在内存中筛选记录 System.Collections.Generic.List <Solution.DataAccess.DbHelper.ConditionFun.SqlqueryCondition> conditionList = new System.Collections.Generic.List <Solution.DataAccess.DbHelper.ConditionFun.SqlqueryCondition>(); conditionList.Add(new Solution.DataAccess.DbHelper.ConditionFun.SqlqueryCondition(SubSonic.Query.ConstraintType.Where, "1", SubSonic.Query.Comparison.Equals, "1", false, false)); var dt = DataTableHelper.GetFilterData(GetDataTable(false, 0, null, 0, 0, conditionList, null), "1", "1", PROD_KINDTable.Id, " asc"); try { //显示值 ddl.DataTextField = PROD_KINDTable.KIND_NAME; //显示key ddl.DataValueField = PROD_KINDTable.KIND_ID; //数据层次 //绑定数据源 ddl.DataSource = dt; ddl.DataBind(); //ddl.SelectedIndex = 0; //ddl.Items.Insert(0, new FineUI.ListItem("请选择大类", "")); //ddl.SelectedValue = ""; } catch (Exception e) { // 记录日志 CommonBll.WriteLog("", e); } }
public static void LlenarCombo <T>(System.Web.UI.WebControls.DropDownList dropDownList, List <T> lista, string DataTextField, string DataValueField) { dropDownList.Items.Clear(); dropDownList.DataSource = lista; dropDownList.DataTextField = DataTextField; dropDownList.DataValueField = DataValueField; dropDownList.DataBind(); }
public static void CargarComboUsuario(System.Web.UI.WebControls.DropDownList ddl, string columnasConcatenar, string columna, string id, string tabla) { ddl.DataSource = AccesoLogica.Select(columnasConcatenar, tabla); ddl.DataTextField = columna; ddl.DataValueField = id; ddl.DataBind(); ddl.Items.Insert(0, "---"); }
public static void DDLBind(string sql, System.Web.UI.WebControls.DropDownList D1, string VField, string TField) { D1.DataSource = AccessDB.GetDataSet(sql).Tables[0].DefaultView; D1.DataTextField = TField; D1.DataValueField = VField; D1.DataBind(); D1.Items.Insert(0, ""); }
public static void FillDropDownList(System.Web.UI.WebControls.DropDownList ddl, System.Data.DataSet ds, string valueField, string textField) { ddl.Items.Clear(); ddl.DataTextField = textField; ddl.DataValueField = valueField; ddl.DataSource = ds; ddl.DataBind(); }
public void ListaTiposFiltroCartasSHF(ref System.Web.UI.WebControls.DropDownList oddlF, bool IncluirValorInicial = true) { DLSoftware DataLayerSoftware = new DLSoftware(); oddlF.DataSource = DataLayerSoftware.ListaTiposFiltroMaxI(IncluirValorInicial); oddlF.DataValueField = "Valor"; oddlF.DataTextField = "Descripcion"; oddlF.DataBind(); }
/// <summary> /// 根据特定条件,下拉框数据加载 /// </summary> /// <param name="DDL_Items">下拉框</param> /// <param name="tablename">表名</param> /// <param name="mtext">名称字段</param> /// <param name="mvalue">编号字段</param> /// <param name="RowName">条件字段名</param> /// <param name="oValue">条件字段值</param> public static void LoadSelection(ref System.Web.UI.WebControls.DropDownList DDL_Items, string tablename, string mtext, string mvalue, string RowName, string oValue) { DDL_Items.DataSource = GetSelections(tablename, RowName, oValue); DDL_Items.Items.Clear(); DDL_Items.DataTextField = mtext; DDL_Items.DataValueField = mvalue; DDL_Items.DataBind(); }
/// <summary> /// 根据特定条件,下拉框数据加载 /// </summary> /// <param name="DDL_Items">下拉框</param> /// <param name="tablename">表名</param> /// <param name="mtext">名称字段</param> /// <param name="mvalue">编号字段</param> /// <param name="RowName">条件字段名</param> /// <param name="oValue">条件字段值</param> public static void LoadSelectionBySql(ref System.Web.UI.WebControls.DropDownList DDL_Items, string sql, string mtext, string mvalue) { DDL_Items.DataSource = CSql.CreateDataSet(sql); DDL_Items.Items.Clear(); DDL_Items.DataTextField = mtext; DDL_Items.DataValueField = mvalue; DDL_Items.DataBind(); }
/// <summary> /// 绑定币别 /// </summary> private void DataBindCurrency() { DataSet dsBaseCurrency = PurchaseOrderHelper.GetBaseCurrency(); ddlCurrency.DataTextField = "Name_CN"; ddlCurrency.DataValueField = "ID"; ddlCurrency.DataSource = dsBaseCurrency; ddlCurrency.DataBind(); }
/// <summary> /// 获得数据列表 /// </summary> //public DataSet GetList(int PageSize,int PageIndex,string strWhere) //{ //return dal.GetList(PageSize,PageIndex,strWhere); //} public void LogTypeBind(System.Web.UI.WebControls.DropDownList ddlControl) { string str = "select Distinct LOGTYPE from SYS_OperateLog"; ddlControl.DataSource = DbHelperSQL.DQuery(str); ddlControl.DataTextField = "LOGTYPE"; ddlControl.DataValueField = "LOGTYPE"; ddlControl.DataBind(); ddlControl.Items.Insert(0, new System.Web.UI.WebControls.ListItem("请选择操作类型", "")); }
/// <summary> /// 根据特定条件,下拉框数据加载 /// </summary> /// <param name="DDL_Items">下拉框</param> /// <param name="tablename">表名</param> /// <param name="mtext">名称字段</param> /// <param name="mvalue">编号字段</param> /// <param name="ConStr">条件字段</param> public static void LoadSelection(ref System.Web.UI.WebControls.DropDownList DDL_Items, string tablename, string mtext, string mvalue, string ConStr) { string sqlTxt = "SELECT * FROM " + tablename + " where " + ConStr; DDL_Items.DataSource = CSql.CreateDataSet(sqlTxt); DDL_Items.Items.Clear(); DDL_Items.DataTextField = mtext; DDL_Items.DataValueField = mvalue; DDL_Items.DataBind(); }
//绑定外包医院下拉框 private void BindDropSendCustomer(System.Web.UI.WebControls.DropDownList ddlcustomer) { if (ViewState["SendCustomer"] == null) { ViewState["SendCustomer"] = dictCustomerService.GetDictCustomerListByType("1").Where <Dictcustomer>(c => c.Dictlabid == Convert.ToDouble(DropDictLab.SelectedValue)).ToList <Dictcustomer>(); } ddlcustomer.DataTextField = "Customername"; ddlcustomer.DataValueField = "Dictcustomerid"; ddlcustomer.DataSource = ViewState["SendCustomer"] as IList <Dictcustomer>; ddlcustomer.DataBind(); ddlcustomer.Items.Insert(0, new System.Web.UI.WebControls.ListItem("请选择", "-1")); }
private void BindData(DbObject dbobj) { DataSet dsobj = new DataSet(); SqlParameter[] parameters2 = { new SqlParameter("@OrgId", SqlDbType.Int) }; parameters2[0].Value = OrgId; dsobj = dbobj.dsRunProcedure("sp_SelectEquipTypesMakesModels", parameters2, "Types"); dsobj.Relations.Add(new DataRelation("Types_Makes", dsobj.Tables["Types"].Columns["Id"], dsobj.Tables["Types1"].Columns["TypeId"])); dsobj.Relations.Add(new DataRelation("Makes_Models", dsobj.Tables["Types1"].Columns["Id"], dsobj.Tables["Types2"].Columns["MakeId"])); ddTypeId.DataSource = dsobj; ddTypeId.DataMember = "Types"; ddTypeId.DataValueField = "id"; ddTypeId.DataTextField = "vchName"; ddTypeId.DataBind(); ddTypeId.Items.Insert(0, ""); ddMakeId.DataSource = dsobj; ddMakeId.DataMember = "Types1"; ddMakeId.DataValueField = "id"; ddMakeId.DataTextField = "vchMakeName"; ddMakeId.DataBind(); ddMakeId.Items.Insert(0, ""); ddModelId.DataSource = dsobj; ddModelId.DataMember = "Types2"; ddModelId.DataValueField = "id"; ddModelId.DataTextField = "vchModelName"; ddModelId.DataBind(); ddModelId.Items.Insert(0, ""); ddDeptId.DataSource = dsobj; ddDeptId.DataMember = "Types3"; ddDeptId.DataValueField = "id"; ddDeptId.DataTextField = "vchName"; ddDeptId.DataBind(); ddDeptId.Items.Insert(0, ""); ddLocationId.DataSource = dsobj; ddLocationId.DataMember = "Types4"; ddLocationId.DataValueField = "id"; ddLocationId.DataTextField = "vchName"; ddLocationId.DataBind(); ddLocationId.Items.Insert(0, ""); ListLink1.DataBind(); ListLink2.DataBind(); }
public System.Web.UI.WebControls.DropDownList FillCombo(System.Web.UI.WebControls.DropDownList combo, string query, string textField, string valueField) { DataTable dt = new DataTable(); SqlDataAdapter adap = new SqlDataAdapter(query, GetConnectionForAdapter()); adap.Fill(dt); combo.DataSource = dt; combo.DataTextField = textField; combo.DataValueField = valueField; combo.DataBind(); return(combo); }
public static void CargarCombo_inner(System.Web.UI.WebControls.DropDownList ddl, string id, string columna, string tabla_uno, string tabla_dos, string parametro) { try { ddl.DataSource = AccesoLogica.Select_inner_join(id + ", " + columna, tabla_uno, tabla_dos, parametro); ddl.DataTextField = columna; ddl.DataValueField = id; ddl.DataBind(); ddl.Items.Insert(0, "---"); } catch { } }
protected void FillDDL(ref System.Web.UI.WebControls.DropDownList ddl, System.Data.SqlClient.SqlCommand sql, string textField, string valueField) { try { ddl.DataSource = getData(sql); ddl.DataTextField = textField; ddl.DataValueField = valueField; ddl.DataBind(); } catch (System.Exception ex) { conCloseNo(); } }
public static void DropDownListBindData(System.Web.UI.WebControls.DropDownList ddl, System.Data.DataTable dt, string dataTextField = "txt", string dataValueField = "val") { try { ddl.DataTextField = dataTextField; ddl.DataValueField = dataValueField; ddl.DataSource = dt; ddl.DataBind(); } catch (Exception ex) { ddl.SelectedValue = ddl.Items[0].Value; } }