DBHelper/SqlHelper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
//导入命名空间
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace Phone.DBHelper
{
    public class SqlHelper
    {
        //获取连接字符串
        private static readonly string connectionString = 
           ConfigurationManager.ConnectionStrings["sqlserver"].ConnectionString;
        /// <summary>
        /// 执行sql语句返回受影响的行数
        /// </summary>
        /// <param name="sql">sql文本</param>
        /// <param name="parameters">可变参数数组</param>
        /// <returns>返回受影响行数</returns>
        public static int ExecuteSQL(string sql,params SqlParameter[] parameters)
        {
            int rows = 0;
            using (SqlConnection conn=new SqlConnection(connectionString))
            {
                //打开数据库连接
                conn.Open();
                using (SqlCommand cmd = new SqlCommand(sql, conn))
                {
                    if(parameters != null && parameters.Length>0)
                    {
                        cmd.Parameters.AddRange(parameters);
                    }
                    rows = cmd.ExecuteNonQuery();
                }
            }
            return rows;
        }
        /// <summary>
        /// 执行查询sql,返回结果集
        /// </summary>
        /// <param name="sql">sql文本</param>
        /// <param name="parameters">可变参数组</param>
        /// <returns>返回结果集</returns>
        public static DataTable GetDataTable(string sql, string tableName, params SqlParameter[] parameters)
        {
            DataTable dt = new DataTable(tableName);
            using (SqlConnection conn=new SqlConnection(connectionString))
            {
                using (SqlDataAdapter sda=new SqlDataAdapter(sql,conn))
                {
                    if (parameters != null && parameters.Length > 0)
                    {
                        sda.SelectCommand.Parameters.AddRange(parameters);
                    }
                    sda.Fill(dt);
                }