代碼 // 執行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元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。
【本文對您有幫助就好】元
