代碼
//
執行SQL語句
public
static
void
ExecSqlCommand()
{
DbHelper db
=
new
DbHelper();
DbCommand command
= db.GetSqlStringCommond(
"
select * from t1_insert
"
);
db.ExecuteNonQuery(command);
}
//
執行存儲過程
public
static
void
ExecStoredProcedure()
{
DbHelper db
=
new
DbHelper();
DbCommand command
= db.GetStoredProcCommond(
"
t1_insert
"
);
db.AddInParameter(command,
"
@id
"
, DbType.String,
"
heihei
"
);
db.AddInParameter(command,
"
@id
"
, DbType.String,
"
heihei
"
);
db.ExecuteNonQuery(command);
}
//
返回DataTable
public
static
void
GetDataTable()
{
DbHelper db
=
new
DbHelper();
DbCommand command
= db.GetSqlStringCommond(
"
t1_findall
"
);
DataTable dt
=
db.ExecuteDataTable(command);
}
//
獲取各種返回值
public
static
void
GetAllParameter()
{
DbHelper db
=
new
DbHelper();
DbCommand command
= db.GetStoredProcCommond(
"
t2_insert
"
);
db.AddInParameter(command,
"
@timeticks
"
, DbType.Int64, DateTime.Now.Ticks);
db.AddOutParameter(command,
"
@outString
"
, DbType.String,
20
);
db.AddReturnParameter(command,
"
@returnValue
"
, DbType.Int32);
db.ExecuteNonQuery(command);
string
s = db.GetParameter(command,
"
@outString
"
).Value
as
string
;
//
out parameter
int
r = Convert.ToInt32(db.GetParameter(command,
"
@returnValue
"
).Value);
//
return value
}
//
DateReader操作
public
static
void
GetDataReader()
{
DbHelper db
=
new
DbHelper();
DbCommand command
= db.GetStoredProcCommond(
"
t2_insert
"
);
db.AddInParameter(command,
"
@timeticks
"
, DbType.Int64, DateTime.Now.Ticks);
db.AddOutParameter(command,
"
@outString
"
, DbType.String,
20
);
db.AddReturnParameter(command,
"
@returnValue
"
, DbType.Int32);
using
(DbDataReader reader =
db.ExecuteReader(command))
{
//
dt.Load(reader);
}
string
s = db.GetParameter(command,
"
@outString
"
).Value
as
string
;
//
out parameter
int
r = Convert.ToInt32(db.GetParameter(command,
"
@returnValue
"
).Value);
//
return value
}
//
獲取DataSet
public
static
void
GetDataSet()
{
DbHelper db
=
new
DbHelper();
DbCommand command
= db.GetSqlStringCommond(
"
select * from t1
"
);
DataSet ds
=
db.ExecuteDataSet(command);
}
//
事務的使用.(項目中需要將基本的數據庫操作組合成一個完整的業務流時,代碼級的事務是必不可少的哦)
public
void
DoBusiness()
{
using
(Trans t =
new
Trans())
{
try
{
D1(t);
throw
new
Exception();
//
如果有異常,會回滾滴
D2(t);
t.Commit();
}
catch
{
t.RollBack();
}
}
}
public
void
D1(Trans t)
{
DbHelper db
=
new
DbHelper();
DbCommand cmd
= db.GetStoredProcCommond(
"
t2_insert
"
);
db.AddInParameter(cmd,
"
@timeticks
"
, DbType.Int64, DateTime.Now.Ticks);
db.AddOutParameter(cmd,
"
@outString
"
, DbType.String,
20
);
db.AddReturnParameter(cmd,
"
@returnValue
"
, DbType.Int32);
if
(t ==
null
)
db.ExecuteNonQuery(cmd);
else
db.ExecuteNonQuery(cmd,t);
string
s = db.GetParameter(cmd,
"
@outString
"
).Value
as
string
;
//
out parameter
int
r = Convert.ToInt32(db.GetParameter(cmd,
"
@returnValue
"
).Value);
//
return value
}
public
void
D2(Trans t)
{
DbHelper db
=
new
DbHelper();
DbCommand cmd
= db.GetSqlStringCommond(
"
insert t1 (id)values(‘..‘)
"
);
if
(t ==
null
)
db.ExecuteNonQuery(cmd);
else
db.ExecuteNonQuery(cmd, t);
}
其中 DbCommand 位于 using System.Data.Common 命名空間
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
