asp.net的DropDownList通用绑定代码
标签: | ||||
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
/// <summary>
/// comboxControl 的摘要说明
/// </summary>
public class comboxControl
{
public comboxControl()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
/*********************************************************************----通用-通用-通用-通用-通用-通用-通用-通用-通用-通用---
** 描述:设置Combobox,显示名称,对应valuemember是代码(编码)
** 输入参数:ComboBox控件名称,编码字段名称IDCode,要在下拉列表中显示名称的字段名DisName,表名TableName,处理模块名称P_No
*********************************************************************************/
public static void FUN_SET_COMBOBOX_IDCode_DisName(DropDownList comboBox, String IDCode, String DisName, String TableName)
{
conn db = null;
try
{
db = conn.getInstance();
String sqlStr = "SELECT Trim(" + IDCode + ") as id , Trim(" + DisName + ") as name FROM " + TableName + " ORDER BY " + DisName;
DataSet ds = db.executeQueryGetDataset(sqlStr, "TB_ID_NAME");
ds.Tables["TB_ID_NAME"].BeginInit();
comboBox.DataSource = ds.Tables["TB_ID_NAME"];
comboBox.DataTextField = "name";
comboBox.DataValueField = "id";
comboBox.DataBind();
ds.Tables["TB_ID_NAME"].EndInit();
comboBox.SelectedValue = "";
}
catch (Exception e)
{
e.ToString();
}
finally
{
if (db != null)
{
try
{
db.rollback();
db.closeDatabase();
}
catch (Jsmsa_webException je1)
{
je1.ToString();
}
}
}
}
/*******************************************************----通用-通用-通用-通用-通用-通用-通用-通用-通用-通用
** 描述:设置 Combobox
** 输入参数:ComboBox名称要在下拉列表里显示的字段名,表名,处理模块名字
** 功能:填充下拉列表 有空行的--多用于查询 ******************************************************************/
public static void FUN_SET_COMBOBOX_DisName(DropDownList comboBox, String IDCode, String DisName, String TableName)
{
conn db = null;
try
{
db = conn.getInstance();
string sqlStr = "SELECT Trim(" + IDCode + ") as id , Trim(" + DisName + ") as name FROM " + TableName + " ORDER BY " + DisName;
DataSet ds = new DataSet();
ds.Clear();
ds = db.executeQueryGetDataset(sqlStr, "table_NameDisplay");
DataTable dt = ds.Tables["table_NameDisplay"];
//dt.Rows.Add(dt.NewRow());
DataRow mydatarow;
mydatarow = dt.NewRow();
mydatarow["id"] = "";
mydatarow["name"] = "";
dt.Rows.InsertAt(mydatarow, 0);
comboBox.Items.Clear();
dt.BeginInit();
comboBox.DataSource = dt;
comboBox.DataTextField = "name";
comboBox.DataValueField = "id";
comboBox.DataBind();
dt.EndInit();
comboBox.SelectedValue = "";
}
catch (Exception e)
{
e.ToString();
}
finally
{
if (db != null)
{
try
{
db.rollback();
db.closeDatabase();
}
catch (Jsmsa_webException je1)
{
je1.ToString();
}
}
}
}
}