lazycode数据操作类

代码下载：http://download.csdn.net/source/2508693

 

 

using System;
using Lazy.DBUtility;

public partial class LazyDBUtility : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        lazySQLHelper.ExecuteNonQuery();
        lazySQLHelper.ExecuteReader();
        lazySQLHelper.ExecuteScalar();
        lazySQLHelper.ReturnDataset();
        lazySQLHelper.ReturnNonQurey();
        lazySQLHelper.ReturnReader();
        lazySQLHelper.ReturnScalar()
        //string sql = "select a from b";
        //lazySQLHelper.ReturnDataset(sql);//返回dataset
        //string insertSql="insert into (a)values('v')";
        //lazySQLHelper.ReturnNonQurey(insertSql);//返回int大于0为执行成功
    }
}

 

 

DBUtility namespace copy了 petshop 的sqlhelper类可以直接使用

如：

 

 string sql = "select a from b";
        lazySQLHelper.ReturnDataset(sql);//返回dataset
        string insertSql="insert into (a)values('v')";
        lazySQLHelper.ReturnNonQurey(insertSql);//返回int大于0为执行成功

 

 

如果使用Return开始的执行操作请配置webconfig connectionStrings name 为 ConnString 

 <connectionStrings>
    <add name="ConnString" connectionString="server=.; database=test; uid=admin; pwd=pass"/>
  </connectionStrings>
/////name="ConnString"

 

 

 

其它操作直接传入SqlConnection conn;