asp.net的DropDownList通用绑定代码

asp.net的DropDownList通用绑定代码

作者：大海仙逝 2007-05-31 21:32:19

标签：

 //一个是带空行的,一个不不带的.

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();
                }
            }
        }

    }
}