可以綁定Datagrid，DataList，DropDownList，RadioList，，，等控件。很想把DataGrid的很多操作都封裝了，免得每次copy代碼那么累
using System;
using System.Data ;
using System.Data.SqlClient ;
using System.Web.SessionState;

namespace LiJiangRiverWeb
{
?/// <summary>
?/// BindListControl 綁定ListControl類控件。
?/// </summary>
?public class BindListControl
?{
??private? SqlConnection SqlConn=new SqlConnection("Data Source=localhost;User Id=sa;Password=sa;Initial Catalog=DB_LiJiangRiver;");
??/// <summary>
??/// 鏈接字符串
??/// </summary>
??private string m_tableName;
??/// <param name="MyCheckBox"></param>
??/// <param name="MyCheckBoxName"></param>
??private System.Web.UI.WebControls.ListControl m_ListControl;
??/// <summary>
??/// 綁定ListControl名稱
??/// </summary>
??/// <param name="myListControl"></param>
??/// <param name="TableName"></param>\
??private string m_sqlQuery;
??/// <summary>
??/// 查詢語句
??/// </summary>
??/// <param name="myListControl"></param>
??/// <param name="TableName"></param>
??private System.Web.UI.WebControls.BaseDataList m_DataList;
??/// <summary>
??/// DataGrid
??/// </summary>
??/// <param name="myListControl"></param>
??/// <param name="TableName"></param>
??/// <param name="sqlQuery"></param>
??public BindListControl(System.Web.UI.WebControls.ListControl myListControl,string TableName,string sqlQuery)
??{
???this.m_ListControl = myListControl;
???this.m_tableName = TableName;
???this.m_sqlQuery =sqlQuery;
???Bind_ListControl();

??}
??public BindListControl(System.Web.UI.WebControls.ListControl myListControl,string TableName)
??{
???this.m_ListControl = myListControl;
???this.m_tableName = TableName;
???Bind_ListControl();
??}
??//public BindListControl()
??public BindListControl(System.Web.UI.WebControls.BaseDataList? myDataList,string sqlQuery,string TableName)
??{
???this.m_DataList = myDataList;
???this.m_sqlQuery = sqlQuery;
???this.m_tableName=TableName;
???Bind_DataList();
??}

??private void Bind_ListControl()//綁定ListControl函數
??{
???//
???// TODO: 在此處添加構造函數邏輯
???//
???//?SqlConnection SqlConn=new SqlConnection("Data Source=localhost;User Id=sa;Password=sa;Initial Catalog=DB_LiJiangRiver;");
???DataSet ds = new DataSet();

??
???if (m_sqlQuery == null)
????m_sqlQuery = "Select * from "+ m_tableName;
???SqlConn.Open();
???SqlDataAdapter sqldpt = new SqlDataAdapter (m_sqlQuery,SqlConn);
???sqldpt.Fill (ds,m_tableName);
???m_ListControl.DataSource = ds.Tables [m_tableName].DefaultView ;
???m_ListControl.DataValueField =ds.Tables[m_tableName].Columns[0].Caption ;
???m_ListControl.DataTextField =ds.Tables [m_tableName].Columns[1].Caption ;
???m_ListControl.DataBind();
???SqlConn.Close ();

??}
??private void Bind_DataList()//綁定dataList函數
??{
???//SqlConnection SqlConn=new SqlConnection("Data Source=localhost;User Id=sa;Password=sa;Initial Catalog=DB_LiJiangRiver;");
???DataSet ds = new DataSet();
???SqlConn.Open();
???SqlDataAdapter sqldpt = new SqlDataAdapter (m_sqlQuery,SqlConn);
???sqldpt.Fill (ds,m_tableName);
??????????? m_DataList.DataSource = ds.Tables [m_tableName].DefaultView ;
???m_DataList.DataBind();
???SqlConn.Close();
??}
?}
}

轉載于:https://www.cnblogs.com/playboy2005/archive/2004/06/03/13098.html

總結

以上是生活随笔為你收集整理的封装绑定以BaseDataList , ListControl 为基类的函数库的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。