SqlHelper的编写

最新推荐文章于 2021-11-11 18:47:00 发布

weixin_30412577

最新推荐文章于 2021-11-11 18:47:00 发布

阅读量48

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/buzi521/archive/2013/02/27/2935445.html

static class SqlHelper
{
    private static string strConn = ConfigurationManager.ConnectionStrings["连接字符串的名字"].ConnectionString;
    public static int ExecuteNonQuery(string sql,params SqlParameter[] parameters)
    {
        using(SqlConnection conn = new SqlConnection(strConn))
        {
            conn.Open();
            using(SqlCommand cmd = conn.CreateCommand())
            {
                cmd.CommandText = sql;
                cmd.Parameters.AddRange(parameters);
                return cmd.ExecuteNonQuery();
            }
        }
    }
    
    public static Object ExecuteScalar(string sql,params SqlParameter[] parameters)
    {
        using(SqlConnection conn = new SqlConnection(strConn))
        {
            conn.Open();
            using(SqlCommand cmd = conn.CreateCommand())
            {
                cmd.CommandText = sql;
                cmd.Parameters.AddRange(parameters);
                return cmd.ExecuteScalar();
            }
        }
    }
    public static DataTable ExecuteDataTable(string sql,params SqlParameter[] parameters)
    {
        using(SqlConnection conn = new SqlConnection(strConn))
        {
            conn.Open();
            using(SqlCommand cmd = conn.CreateCommand())
            {
                cmd.CommandText = sql;
                cmd.Parameters.AddRange(parameters);
                SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                DataSet dataset = new DataSet();
                adapter.Fill(dataset);
                return dataset.Tables[0];
            }
        }
    }
}