using System;
using System.Data;
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;
using System.Data.SqlClient;
/// <summary>
/// DB 的摘要描述
/// </summary>
public class DB
{
public DB()
{
//
// TODO: 在此加入建構函式的程式碼
//
}
/// <summary>
/// 取得DataTable
/// </summary>
/// <param name="SQL"></param>
/// <returns></returns>
public static DataTable GetDataTable(string SQL, string ConnString)
{
DataTable dt = new DataTable();
using (SqlConnection sc = new SqlConnection(ConfigurationManager.ConnectionStrings[ConnString].ToString()))
{
using (SqlCommand cmd = new SqlCommand(SQL, sc))
{
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
try
{
sc.Open();
da.Fill(dt);
sc.Close();
}
catch
{
}
}
}
}
return dt;
}
/// <summary>
/// 取得DataTableTrn
/// </summary>
/// <param name="cmd"></param>
/// <returns></returns>
public static DataTable GetDataTableWithTran(SqlCommand Cmd, string ConnString)
{
DataTable dt = new DataTable();
using (SqlConnection sc = new SqlConnection(ConfigurationManager.ConnectionStrings[ConnString].ToString()))
{
sc.Open();
//using (var trans = sc.BeginTransaction(IsolationLevel.ReadUncommitted ))
using (var trans = sc.BeginTransaction( ))
{
try
{
using (var cmd = Cmd)
{
cmd.Connection = sc;
cmd.Transaction = trans;
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
}
trans.Commit();
}
catch (Exception ex)
{
if (trans != null) trans.Rollback();
throw ex;
}
}
sc.Close();
}
return dt;
}
/// <summary>
/// 取得DataTable
/// </summary>
/// <param name="cmd"></param>
/// <returns></returns>
public static DataTable GetDataTable(SqlCommand cmd, string ConnString)
{
DataTable dt = new DataTable();
using (SqlConnection sc = new SqlConnection(ConfigurationManager.ConnectionStrings[ConnString].ToString()))
{
cmd.Connection = sc;
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
try
{
sc.Open();
da.Fill(dt);
sc.Close();
}
catch (Exception ex)
{
throw ex ;
}
}
}
return dt;
}
/// <summary>
/// 執行SQL
/// </summary>
/// <param name="SQL"></param>
public static void ExecuteNonQuery(string SQL, string ConnString)
{
using (SqlConnection sc = new SqlConnection(ConfigurationManager.ConnectionStrings[ConnString].ToString()))
{
using (SqlCommand cmd = new SqlCommand(SQL, sc))
{
try
{
sc.Open();
cmd.ExecuteNonQuery();
sc.Close();
}
catch
{
}
}
}
}
/// <summary>
/// 執行SQL
/// </summary>
/// <param name="cmd"></param>
public static void ExecuteNonQuery(SqlCommand cmd, string ConnString)
{
using (SqlConnection sc = new SqlConnection(ConfigurationManager.ConnectionStrings[ConnString].ToString()))
{
cmd.Connection = sc;
try
{
sc.Open();
cmd.ExecuteNonQuery();
sc.Close();
}
catch
{
}
finally
{
}
}
}
}
2023-05-23
置頂文章
DB CRUD
- 261
- 0
- 2023-05-24