一个简单的数据库操作类
<br> 类代码<br> <br> using System;<br> using System.Data;<br> using System.Data.SqlClient;<br> <br> <br> namespace exchange<br> {<br> public class MyDataOp<br> {<br> private String StrSql;<br> private String StrConn;<br> private SqlConnection Conn;<br> public MyDataOp(String ss) <br> { <br> StrSql = ss;<br> StrConn = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];<br> }<br> <br> public SqlDataReader CreateReader()<br> {<br> Conn=new SqlConnection(StrConn);<br> SqlCommand Comm=new SqlCommand(StrSql,Conn);<br> Conn.Open();<br> SqlDataReader MyReader = Comm.ExecuteReader();<br> return MyReader;<br> }<br> public DataSet CreateDataSet()<br> {<br> Conn=new SqlConnection(StrConn);<br> Conn.Open();<br> SqlDataAdapter Adpt=new SqlDataAdapter(StrSql,Conn);<br> DataSet Ds=new DataSet();<br> Adpt.Fill(Ds);<br> return Ds;<br> }<br> public SqlCommand ExecuteCommand()<br> {<br> Conn=new SqlConnection(StrConn);<br> SqlCommand Comm=new SqlCommand(StrSql,Conn);<br> Conn.Open();<br> Comm.ExecuteNonQuery();<br> return Comm;<br> }<br> public void Close()<br> {<br> Conn.Close();<br> }<br> }<br> }<br> <br> <br> <br> 基本用法<br> <br> namespace exchange<br> {<br> using System;<br> using System.Web.UI;<br> using System.Web.UI.WebControls;<br> using System.Data;<br> using System.Data.SqlClient;<br> using System.Web;<br> using System.Security.Cryptography;<br> <br> <br> public class newjoin : System.Web.UI.UserControl<br> {<br> <br> protected DataList newjoinlist;<br> public newjoin()<br> {<br> this.Init= new System.EventHandler(Page_Init);<br> }<br> <br> protected void Page_Load(object sender, System.EventArgs e) <br> { <br> if(!IsPostBack)<br> {<br> LoadData();<br> }<br> }<br> <br> protected void LoadData()<br> {<br> String StrSql = "select top 10 id,left(corpname,13) as corpname from crop order by id desc";<br> MyDataOp mdo = new MyDataOp(StrSql);<br> DataSet ds = mdo.CreateDataSet();<br> newjoinlist.DataSource = ds.Tables.DefaultView;<br> newjoinlist.DataBind();<br> mdo.Close();<br> }<br> <br> private void Page_Init(object sender, EventArgs e)<br> {<br> InitializeComponent();<br> }<br> private void InitializeComponent()<br> { <br> this.Load= new System.EventHandler(this.Page_Load);<br> }<br> }<br> } <
页:
[1]