public static void BuildComboDistinct(DropDownList zCombo, string TableName, string TextFiledName, string ValueFieldName, string OrderFieldName, string WhereString, string BlankText, string BlankValue) { ComboSourceFlow cmbFlow = new ComboSourceFlow(); DataTable dt = cmbFlow.GetSourceDistinct(TableName, TextFiledName, ValueFieldName, OrderFieldName, WhereString); if (dt != null) { zCombo.Items.Clear(); zCombo.DataSource = dt; zCombo.DataTextField = TextFiledName; zCombo.DataValueField = ValueFieldName; zCombo.DataBind(); if (BlankText != null || BlankValue != null) { ListItem itm = new ListItem(BlankText, BlankValue); zCombo.Items.Insert(0, itm); } } }
public static void BuildComboDistinct(ComboBox zCombo, string TableName, string TextFiledName, string ValueFieldName, string OrderFieldName, string WhereString, string BlankText, string BlankValue) { ComboSourceFlow cmbFlow = new ComboSourceFlow(); DataTable dt = cmbFlow.GetSourceDistinct(TableName, TextFiledName, ValueFieldName, OrderFieldName, WhereString); if (dt != null) { zCombo.Items.Clear(); if (BlankText != null || BlankValue != null) { DataRow dRow = dt.NewRow(); dRow[TextFiledName] = BlankText; dRow[ValueFieldName] = BlankValue; dt.Rows.InsertAt(dRow, 0); } zCombo.DataSource = dt; zCombo.DisplayMember = TextFiledName; zCombo.ValueMember = ValueFieldName; } }