bindDrop.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
//获得更有效最新源码请下载看这里：http://www.51aspx.com
namespace Eclipse.HRM.UI
{
    public class bindDrop
    {
        static public void BindDptGridView(DropDownList d)
        {
            d.DataSource = QueryForDptDataSet();
            d.DataTextField = "D_name";
            d.DataValueField = "D_ID";
            d.DataBind();
        }
        //获得更有效最新源码请下载看这里：http://www.51aspx.com
        static private DataSet QueryForDptDataSet()
        {
            String strConn = "Data Source=.;Initial Catalog=Eclipse_HRM;Persist Security Info=True;User ID=sa;Password=51Aspx";
            SqlConnection conn = new SqlConnection(strConn);
            String strSql = "SELECT * FROM dbo.departmentlist ORDER BY D_ID DESC";
            SqlCommand command = new SqlCommand(strSql, conn);
            SqlDataAdapter sda = new SqlDataAdapter(command);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            return ds;
        }
    }
}