一个自定义的C#数据库操作基础类 SqlHelper的代码

下面代码段是关于一个自定义的C#数据库操作基础类 SqlHelper的代码。
{
public class SQLHelper
{
private string strConn = null;
private SqlConnection Conn = null;
private SqlCommand Cmd = null;
private SqlDataReader Sqlsdr = null;
public SQLHelper()
{
strConn = ConfigurationManager.ConnectionStrings[“strConn”].ConnectionString;
Conn = new SqlConnection(strConn);
}

    private SqlConnection GetConn()  
    {  
        if (Conn.State == ConnectionState.Closed)  
        {  
            Conn.Open();  
        }  
        return Conn;  
    }  


    public int ExecuteNonQuery(string CmdText, CommandType CmdType)  
    {  
        int res;  
        try  
        {  
            Cmd = new SqlCommand(CmdText, GetConn());  
            Cmd.CommandType = CmdType;  
            res = Cmd.ExecuteNonQuery();  

        }  
        catch (Exception ex)  
        {  

            throw ex;  
        }  
        finally  
        {  
            if (Conn.State == ConnectionState.Open)  
            {  
                Conn.Close();  
            }  
        }  
        return res;  
    }  

    public int ExecuteNonQuery(string CmdText, SqlParameter[] Parameters, CommandType CmdType)  
    {  
        int res;  
        try  
        {  
            Cmd.Parameters.AddRange(Parameters);  
            Cmd = new SqlCommand(CmdText, GetConn());  
            Cmd.CommandType = CmdType;  
            res = Cmd.ExecuteNonQuery();  
        }  
        catch (Exception ex)  
        {  

            throw ex;  
        }  
        finally  
        {  
            if (Conn.State == ConnectionState.Open)  
            {  
                Conn.Close();  
            }  
        }  
        return res;  
    }  


    public DataTable ExecuteQuery(string CmdText, CommandType CmdType)  
    {  
        DataTable dt = new DataTable();  

        using (Sqlsdr = Cmd.ExecuteReader(CommandBehavior.CloseConnection))  
        {  
            Cmd = new SqlCommand(CmdText, GetConn());  
            Cmd.CommandType = CmdType;  
            dt.Load(Sqlsdr);  
        }  
        return dt;  
    }  

    public DataTable ExecuteQuery(string CmdText, SqlParameter[] Parameters, CommandType CmdType)  
    {  
        DataTable dt = new DataTable();  

        using (Sqlsdr = Cmd.ExecuteReader(CommandBehavior.CloseConnection))  
        {  
            Cmd = new SqlCommand(CmdText, GetConn());  
            Cmd.CommandType = CmdType;  
            Cmd.Parameters.AddRange(Parameters);  
            dt.Load(Sqlsdr);  
        }  
        return dt;  
    }  
}  

}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值