亚洲免费在线-亚洲免费在线播放-亚洲免费在线观看-亚洲免费在线观看视频-亚洲免费在线看-亚洲免费在线视频

簡單C#數(shù)據(jù)庫操作類

系統(tǒng) 2000 0

using ?System;
using ?System.Data;
using ?System.Data.SqlClient;
using ?System.Configuration;
using ?System.Web;
using ?System.Web.Security;
using ?System.Web.UI;
using ?System.Web.UI.WebControls;
using ?System.Web.UI.WebControls.WebParts;
using ?System.Web.UI.HtmlControls;

/// ? <summary>
/// ?SqlHelper?的摘要說明
/// ? </summary>

public ? class ?SqlHelper
{
????
public ?SqlHelper()
????
{
????????
//
????????
// ?TODO:?在此處添加構(gòu)造函數(shù)邏輯
????????
//
????}

????
/// ? <summary>
????
/// ?獲取數(shù)據(jù)庫連接字符串
????
/// ? </summary>
????
/// ? <returns></returns>

???? private ? static ? string ?sqlConnectionString
????
{
????????
get
????????
{
????????????
// 直接在這里獲取數(shù)據(jù)庫聯(lián)接
????????????
// return??"Data?Source?=?(local);?Initial?Catalog=window;Integrated?Security=SSPI;";
????????????
// VS.NET2003下的使用方式
????????????
// return?System.Configuration.ConfigurationSettings.AppSettings["ConnectDataBase"];
????????????
// VS.NET2005下的使用方式
???????????? return ?System.Configuration.ConfigurationManager.AppSettings[ " ConnectDataBase " ];
????????}

????}

????
/// ? <summary>
????
/// ?獲取數(shù)據(jù)庫連接
????
/// ? </summary>
????
/// ? <returns> Conn </returns>

???? private ? static ?SqlConnection?sqlConn
????
{
????????
get
????????
{
????????????
// VS.NET2003下的使用方式
????????????
// return?System.Configuration.ConfigurationSettings.AppSettings["ConnectDataBase"];
????????????
// VS.NET2005下的使用方式
????????????
// ConnStrings?=?System.Configuration.ConfigurationManager.AppSettings["ConnectDataBase"];
???????????? string ?ConnStrings? = ? " Data?Source?=?(local);?Initial?Catalog=window;Integrated?Security=SSPI; " ;
????????????SqlConnection?Conn?
= ? new ?SqlConnection();
????????????Conn.ConnectionString?
= ?ConnStrings;
????????????
return ?Conn;
????????}

????}

????
/// ? <summary>
????
/// ?執(zhí)行sql語句,返回DataSet
????
/// ? </summary>
????
/// ? <param?name="sqlString"> sql語句參數(shù) </param>
????
/// ? <returns> DataSet </returns>

???? public ? static ?DataSet?ExecuteDataSet( string ?sqlString)
????
{
????????DataSet?dsSet?
= ? new ?DataSet();
????????SqlDataAdapter?adp?
= ? new ?SqlDataAdapter(sqlString,?sqlConnectionString);
????????
try
????????
{
????????????adp.Fill(dsSet);
????????}

????????
catch ?(Exception?e)
????????
{
????????????
throw ?(e);
????????}

????????
finally
????????
{
????????????adp.Dispose();
????????}

????????
return ?dsSet;
????}

????
/// ? <summary>
????
/// ?執(zhí)行sql語句,返回DataTable
????
/// ? </summary>
????
/// ? <param?name="sqlString"> sql語句參數(shù) </param>
????
/// ? <returns> DataTable </returns>

???? public ? static ?DataTable?ExecuteDataTable( string ?sqlString)
????
{
????????DataTable?dt?
= ? new ?DataTable();
????????SqlDataAdapter?adp?
= ? new ?SqlDataAdapter(sqlString,?sqlConnectionString);
????????
try
????????
{
????????????adp.Fill(dt);
????????}

????????
catch ?(Exception?e)
????????
{
????????????
throw ?(e);
????????}

????????
finally
????????
{
????????????adp.Dispose();
????????}

????????
return ?dt;
????}

????
/// ? <summary>
????
/// ?執(zhí)行存儲過程返回DataSet
????
/// ? </summary>
????
/// ? <param?name="spName"> 存儲過程名稱 </param>
????
/// ? <param?name="commandParameters"> 存儲過程參數(shù) </param>
????
/// ? <returns> DataSet </returns>

???? public ? static ?DataSet?ExecuteDataSet( string ?spName,?SqlParameter[]?commandParameters)
????
{
????????SqlConnection?conn?
= ?sqlConn;
????????conn.Open();
????????SqlCommand?sqlcommand?
= ? new ?SqlCommand();
????????SqlDataAdapter?adapter?
= ? new ?SqlDataAdapter();
????????DataSet?dataSet?
= ? new ?DataSet();
????????sqlcommand.Connection?
= ?conn;
????????sqlcommand.CommandText?
= ?spName;
????????sqlcommand.CommandType?
= ?CommandType.StoredProcedure;
????????
if ?(commandParameters? != ? null )
????????
{
????????????
foreach ?(SqlParameter?p? in ?commandParameters)
????????????
{
????????????????
if ?((p.Direction? == ?ParameterDirection.InputOutput)? && ?(p.Value? == ? null ))
????????????????
{
????????????????????p.Value?
= ?DBNull.Value;
????????????????}

????????????????sqlcommand.Parameters.Add(p);
????????????}

????????}

????????adapter.SelectCommand?
= ?sqlcommand;
????????
try
????????
{
????????????adapter.Fill(dataSet);
????????}

????????
catch ?(Exception?e)
????????
{
????????????
throw ?(e);
????????}

????????
finally
????????
{
????????????sqlcommand.Parameters.Clear();
????????????sqlcommand.Dispose();
????????????adapter.Dispose();
????????????conn.Close();
????????}

????????
return ?dataSet;
????}

????
/// ? <summary>
????
/// ?執(zhí)行存儲過程返回DataTable
????
/// ? </summary>
????
/// ? <param?name="spName"> 存儲過程名稱 </param>
????
/// ? <param?name="commandParameters"> 存儲過程參數(shù) </param>
????
/// ? <returns> DataTable </returns>

???? public ? static ?DataTable?ExecuteDataTable( string ?spName,?SqlParameter[]?commandParameters)
????
{
????????SqlConnection?conn?
= ?sqlConn;
????????conn.Open();
????????SqlCommand?sqlcommand?
= ? new ?SqlCommand();
????????SqlDataAdapter?adapter?
= ? new ?SqlDataAdapter();
????????DataTable?dataTable?
= ? new ?DataTable();
????????sqlcommand.Connection?
= ?conn;
????????sqlcommand.CommandText?
= ?spName;
????????sqlcommand.CommandType?
= ?CommandType.StoredProcedure;
????????
if ?(commandParameters? != ? null )
????????
{
????????????
foreach ?(SqlParameter?p? in ?commandParameters)
????????????
{
????????????????
if ?((p.Direction? == ?ParameterDirection.InputOutput)? && ?(p.Value? == ? null ))
????????????????
{
????????????????????p.Value?
= ?DBNull.Value;
????????????????}

????????????????sqlcommand.Parameters.Add(p);
????????????}

????????}

????????adapter.SelectCommand?
= ?sqlcommand;
????????
try
????????
{
????????????adapter.Fill(dataTable);
????????}

????????
catch ?(Exception?e)
????????
{
????????????
throw ?(e);
????????}

????????
finally
????????
{
????????????sqlcommand.Parameters.Clear();
????????????sqlcommand.Dispose();
????????????adapter.Dispose();
????????????conn.Close();
????????}

????????
return ?dataTable;
????}

????
/// ? <summary>
????
/// ?執(zhí)行存儲過程
????
/// ? </summary>
????
/// ? <param?name="spName"> 存儲過程名稱 </param>
????
/// ? <param?name="commandParameters"> 存儲過程參數(shù) </param>
????
/// ? <returns> true?or?false </returns>

???? public ? static ? bool ?ExecuteProcedure( string ?spName,?SqlParameter[]?commandParameters)
????
{
????????
bool ?result? = ? false ;
????????SqlConnection?conn?
= ?sqlConn;
????????conn.Open();
????????SqlCommand?sqlcommand?
= ? new ?SqlCommand();
????????sqlcommand.Connection?
= ?conn;
????????sqlcommand.CommandText?
= ?spName;
????????sqlcommand.CommandType?
= ?CommandType.StoredProcedure;
????????
if ?(commandParameters? != ? null )
????????
{
????????????
foreach ?(SqlParameter?p? in ?commandParameters)
????????????
{
????????????????
if ?((p.Direction? == ?ParameterDirection.InputOutput)? && ?(p.Value? == ? null ))
????????????????
{
????????????????????p.Value?
= ?DBNull.Value;
????????????????}

????????????????sqlcommand.Parameters.Add(p);
????????????}

????????}

????????
try
????????
{
????????????sqlcommand.ExecuteNonQuery();
????????????result?
= ? true ;
????????}

????????
catch ?(Exception?e)
????????
{
????????????
throw ?(e);
????????}

????????
finally
????????
{
????????????sqlcommand.Parameters.Clear();
????????????sqlcommand.Dispose();
????????????conn.Close();
????????}

????????
return ?result;
????}

????
/// ? <summary>
????
/// ?執(zhí)行存儲過程返回一個object對象
????
/// ? </summary>
????
/// ? <param?name="spName"> 存儲過程名稱 </param>
????
/// ? <param?name="commandParameters"> 存儲過程參數(shù) </param>
????
/// ? <returns> object </returns>

???? public ? static ? object ?ExecuteProcedures( string ?spName,?SqlParameter[]?commandParameters)
????
{
????????
object ?ret? = ? new ? object ();
????????ret?
= ?DBNull.Value;
????????SqlConnection?conn?
= ?sqlConn;
????????conn.Open();
????????SqlCommand?sqlcommand?
= ? new ?SqlCommand();

????????? sqlcommand.Connection = conn;//2009/2/27丟掉的Connection連接
????????sqlcommand.CommandText?
= ?spName;
????????sqlcommand.CommandType?
= ?CommandType.StoredProcedure;
????????
if ?(commandParameters? != ? null )
????????
{
????????????
foreach ?(SqlParameter?p? in ?commandParameters)
????????????
{
????????????????
if ?((p.Direction? == ?ParameterDirection.InputOutput)? && ?(p.Value? == ? null ))
????????????????
{
????????????????????p.Value?
= ?DBNull.Value;
????????????????}

????????????????sqlcommand.Parameters.Add(p);
????????????}

????????}

????????
try
????????
{
????????????ret?
= ?sqlcommand.ExecuteScalar();
????????}

????????
catch ?(Exception?e)
????????
{
????????????
throw ?(e);
????????}

????????
finally
????????
{
????????????sqlcommand.Parameters.Clear();
????????????sqlcommand.Dispose();
????????????conn.Close();
????????}

????????
return ?ret;
????}

????
/// ? <summary>
????
/// ?執(zhí)行sql語句,返回一個object對象
????
/// ? </summary>
????
/// ? <param?name="sqlString"> 自定義sql語句 </param>
????
/// ? <returns> object </returns>

???? public ? static ? object ?ExecuteScalar( string ?sqlString)
????
{
????????
object ?ret? = ? new ? object ();
????????ret?
= ?DBNull.Value;
????????SqlConnection?conn?
= ?sqlConn;
????????SqlCommand?sqlcommand?
= ? new ?SqlCommand(sqlString,?conn);
????????
try
????????
{
????????????ret?
= ?sqlcommand.ExecuteScalar();
????????}

????????
catch ?(Exception?e)
????????
{
????????????
throw ?(e);
????????}

????????
finally
????????
{
????????????sqlcommand.Dispose();
????????????conn.Close();
????????}

????????
return ?ret;
????}

????
/// ? <summary>
????
/// ?執(zhí)行自定義sql語句
????
/// ? </summary>
????
/// ? <param?name="sqlString"> 自定sql語句 </param>
????
/// ? <returns> true?or?false </returns>

???? public ? static ? bool ?ExecuteNoQueryString( string ?sqlString)
????
{
????????
bool ?result? = ? false ;
????????SqlCommand?sqlcommand?
= ? new ?SqlCommand();
????????SqlConnection?conn?
= ? new ?SqlConnection();
????????conn.Open();
????????sqlcommand.Connection?
= ?conn;
????????
try
????????
{
????????????sqlcommand.ExecuteScalar();
????????????result?
= ? true ;
????????}

????????
catch
????????
{
????????????result?
= ? false ;
????????}

????????
finally
????????
{
????????????sqlcommand.Dispose();
????????????conn.Close();
????????}

????????
return ?result;
????}

}

?

這個文件在網(wǎng)上應(yīng)該是很流行的。不做 解釋,記錄在案以后使用。

下邊是調(diào)用 存儲過程 的方法 帶參數(shù)的:

??????? public bool InsertUsers(Users user)
??????? {
??????????? SqlParameter[] parms = {
??????????????? new SqlParameter("@UserName",user.userName),
??????????????? new SqlParameter("@UserPass",user.userPass),
??????????????? new SqlParameter("@UserRole",user.userRole),
??????????????? new SqlParameter("@UserEmail",user.userEmail),
??????????????? new SqlParameter("@Remark",user.remark)
??????????? };
??????????? return SQLHelper.ExecuteProcedure("tfwk_InsertUser", parms);
??????? }


簡單C#數(shù)據(jù)庫操作類


更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主

微信掃碼或搜索:z360901061

微信掃一掃加我為好友

QQ號聯(lián)系: 360901061

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。

【本文對您有幫助就好】

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描上面二維碼支持博主2元、5元、10元、自定義金額等您想捐的金額吧,站長會非常 感謝您的哦!!!

發(fā)表我的評論
最新評論 總共0條評論
主站蜘蛛池模板: 亚洲综合久久久 | 婷婷在线综合 | 国模无水印一区二区三区 | 番茄视频在线观看黄版本免费 | 国外欧美一区另类中文字幕 | 国产视频不卡 | 久久伊人草 | 日韩中文字幕在线视频 | 热久久这里是精品6免费观看 | 深夜国产福利 | www国产精品com| 欧美日本在线视频 | 欧美成人免费xxx大片 | 日本一级在线播放线观看免 | 激情91| 日日嗷| 99毛片| 久久综合香蕉久久久久久久 | 东京99热 | 亚洲高清一区二区三区久久 | 亚洲精品三区 | 五月天婷婷一区二区三区久久 | 国产亚洲影院 | 青春草国产成人精品久久 | 欧美精品h在线播放 | 久久91精品国产一区二区 | 国产精品美女久久久久 | 中文字幕一区二区日产乱码 | 国产中文字幕免费 | 国产精品18久久久久久小说 | 精品国产九九 | 亚洲视频国产 | 手机在线一区二区三区 | 国产精品99精品久久免费 | 天天干人人干 | 狠狠综合久久久久尤物丿 | 99久久国内精品成人免费 | 日日日日日操 | 午夜dj影院在线视频观看完整 | 亚洲欧美日韩综合 | 性生生活网站免费 |