C#SqlServer数据库增删改查的类

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();
                }
            }
        }
    }
}