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