using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
namespace ReliabilityDev
{
class SqlDataHelp
{
/// <summary>
/// 执行增删改操作,并返回受影响的行数
/// </summary>
/// <param name="sql">sql语句</param>
/// <returns>受影响的行数</returns>
public static int ExecuteNonQuery(string sql)
{
SqlConnection conn = new SqlConnection();
try
{
conn.ConnectionString = "Server = ZV50N0P2P2VUZNX; DataBase = Reliability; user ID = sa; password = 123456";
conn.Open();
SqlTransaction trans = conn.BeginTransaction();
try
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
cmd.Transaction = trans;
try
{
int result = cmd.ExecuteNonQuery();
trans.Commit();
return result;
}
catch (Exception exp1)
{
throw exp1;
}
}
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
}
catch (Exception ex)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
throw ex;
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
/// <summary>
/// 执行sql查询语句,获得数据表
/// </summary>
/// <param name="sql">sql语句</param>
/// <returns>数据表</returns>
public static DataTable ReadTable(string sql)
{
SqlConnection conn = new SqlConnection();
try
{
conn.ConnectionString = "Server = ZV50N0P2P2VUZNX; DataBase = Reliability; user ID = sa; password = 123456";
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
return dt;
}
catch (Exception ex)
{
conn.Close();
throw ex;
}
finally
{
if (ConnectionState.Open == conn.State)
{
conn.Close();
}
}
}
}
}
C#SqlServer数据库增删改查的类
最新推荐文章于 2019-05-16 10:45:29 发布