代码下载: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为执行成功
}
}
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为执行成功
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"
< add name = " ConnString " connectionString = " server=.; database=test; uid=admin; pwd=pass " />
</ connectionStrings >
/// //name="ConnString"
其它操作直接传入SqlConnection conn;