DbHelper

usingCat.Database;

web.config

<connectionStrings>
<addname="ConnectionString"connectionString="server=.,1791;uid=xxx;pwd=xxx;database=pubs;trusted_connection=no;MultipleActiveResultSets=true;"providerName="System.Data.SqlClient"/>
<!--<add name="ConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=|DataDirectory|d_b.mdb" providerName="System.Data.OleDb"/>-->
</connectionStrings>

Usage

DbHelperdb=newDbHelper();Repeater1.DataSource=db.GetDataTable("select * from [jobs]");Repeater1.DataBind();SqlParameterpar=newSqlParameter("@job_id",1);msg.Text=db.ExecuteScalar<string>("select job_desc from jobs where job_id=@job_id",par);

Paging

DbPagerpager=newDbPager();pager.field="*";pager.tableName="jobs";pager.primaryKey="job_id";pager.orderSql="job_id desc";//pager.appendSql = "left join jobs on jobs.job_id=employee.job_id";pager.pagerSize=Pager1.PageSize;pager.pagerIndex=Pager1.CurPage;//pager.kind = DbPagerKind.TableVar;Repeater1.DataSource=pager.GetData();Pager1.RecordCount=pager.pagerCount;Repeater1.DataBind();

Insert

DbInsertinsert=newDbInsert();insert.Add("job_desc",TextBox1.Text);insert.Add("min_lvl",TextBox2.Text);insert.Add("max_lvl",TextBox2.Text);insert.Execute("jobs");

Update

DbUpdateupdate=newDbUpdate();update.Add("max_lvl",TextBox2.Text);SqlParameterpar=newSqlParameter("@job_id",1);update.Execute("jobs","where job_id=@job_id",par);

Transaction

DbHelperdb=newDbHelper();db.BeginTransaction();try{db.ExecuteNonQuery('sql...1');db.ExecuteNonQuery('sql...2');inta=0;intb=1/a;//exception codedb.ExecuteNonQuery('sql...3');db.CommitTransaction();}catch(Exception){db.RollbackTransaction();}