DropDownList绑定 调用类

  string strqry = "";
                strqry = "select * From bigclassname ";
                DBFun.FillDwList(DropDownList1, "Select * from bigclassname");
                DropDownList1.Items.Add(new ListItem("所有分类", "0"));

                //绑定数据
                DataView dvlist = DBFun.GetDataView(strqry);
              //  AspNetPager1.RecordCount = dvlist.Table.Rows.Count;
                Session["dvlist"] = dvlist;
                bindData();

 

 

DBFun.cs中

 

 

public class DBFun
{
    protected static OleDbConnection conn = new OleDbConnection();
    protected static OleDbCommand comm = new OleDbCommand();

    public DBFun()
    {
        //
        // TODO: 在此处添加构造函数逻辑
        //
    }

    /// <summary>
    /// 打开数据库连接
    /// </summary>
    //51_a_s_p_x.c_o_m

    private static void openConnection()
    {
        if (conn.State == ConnectionState.Closed )
        {
            conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
                + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["DbPath"].ToString());
            comm.Connection = conn;
            try
            {
                conn.Open();
               
            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }
        }
    }
    /// <summary>
    /// 关闭当前数据库连接
    /// </summary>
    private static void closeConnection()
    {
        if (conn.State == ConnectionState.Open)
            conn.Close();
        conn.Dispose();
        comm.Dispose();
    }

 public static void FillDwList(DropDownList ddlist, string strqry)
    {
        //用SQL语句填充下拉列表
        try
        {
            DataView dv = GetDataView(strqry);
            ddlist.DataValueField = dv.Table.Columns[0].Caption.ToString();
            ddlist.DataTextField = dv.Table.Columns[1].Caption.ToString();
            ddlist.DataSource = dv;
            ddlist.DataBind();
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message);
        }
    }

｝