//填充HtmlComboBox控件 private void FillHtmlComboBox(ref HtmlComboBox hcb, string sql) { DataTable val = DBOpt.dbHelper.GetDataTable(sql); if (val == null) { return; } DataRow row = val.NewRow(); val.Rows.InsertAt(row, 0); //第一列是数据列 hcb.DataValueField = val.Columns[0].ColumnName; //如果有第二列,则是显示列,没有则第一列也是显示列。 if (val.Columns.Count > 1) { hcb.DataTextField = val.Columns[1].ColumnName; } else { hcb.DataTextField = val.Columns[0].ColumnName; } hcb.DataSource = val; hcb.DataBind(); }
public static void FillHtmlCombxByTable(ref HtmlComboBox hcb, string TableName, string TextColumn, string ValueColumn, string Orders, string Wheres) { string sql; sql = "select " + ValueColumn + "," + TextColumn + " from " + TableName + " where " + Wheres + " order by " + Orders; DataTable dt = DBOpt.dbHelper.GetDataTable(sql); hcb.Items.Clear(); hcb.DataTextField = TextColumn; hcb.DataValueField = ValueColumn; hcb.DataSource = dt; hcb.DataBind(); }
/// <summary> /// 通过sql添加hcb的数据 /// </summary> /// <param name="hcb">控件名</param> /// <param name="sql">sql语句</param> /// <returns>出错提示</returns> public static string FillHCBBySql(ref HtmlComboBox hcb, string sql) { string str = ""; try { DataTable dt = DBOpt.dbHelper.GetDataTable(sql.Replace('^', '\'')); hcb.Items.Clear(); hcb.DataTextField = dt.Columns[0].ColumnName; hcb.DataValueField = dt.Columns[1].ColumnName; hcb.DataSource = dt; hcb.DataBind(); hcb.Items.Insert(0, ""); } catch { str = "Sql脚本有问题,请修改!"; } return(str); }