SqlHelper类执行数据库

最新推荐文章于 2021-03-13 10:01:17 发布

一笑而过者也

最新推荐文章于 2021-03-13 10:01:17 发布

阅读量286

点赞数

分类专栏： C#笔记

本文链接：https://blog.csdn.net/u012326462/article/details/49311725

版权

C#笔记专栏收录该内容

17 篇文章 1 订阅

订阅专栏

class SqlHelper
    {
        public static string connStr = ConfigurationManager.ConnectionStrings["connStrConfig"].ConnectionString;
        public static int ExecuteNonQuery(string strSql,params SqlParameter[] sqlParameters)
        {
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = strSql;
                    cmd.Parameters.AddRange(sqlParameters);
                    return cmd.ExecuteNonQuery();

                }
            }
        }

        public static object ExecuteScalar(string strSql, params SqlParameter[] sqlParameters)
        {
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                using (SqlCommand cmd = new SqlCommand(strSql, conn))
                {
                    cmd.Parameters.AddRange(sqlParameters);
                    return cmd.ExecuteScalar();
                }
            }
        }

        public static DataTable ExecuteDataTable(string strSql, params SqlParameter[] sqlParameters)
        {
            using (SqlConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = strSql;
                    cmd.Parameters.AddRange(sqlParameters);
                    DataSet dataSet = new DataSet();
                    SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                    adapter.Fill(dataSet);
                    return dataSet.Tables[0];
                }
            }
        }