//填充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);
}
