DBHelper类使用

1.先在Web.config 文件中加入要连接的数据库

在<configuration>里面加入

    <connectionStrings  >
      <add name="logisDb" connectionString="Data Source=.;Initial Catalog=logis;Integrated Security=True"/>
    </connectionStrings>

name:是自己起的名字

connectionString：连接数据库字段

2.编写DBHelper类

先引入命名空间：using System.Configuration;

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Data.Sql;
using System.Configuration;
namespace HP_DAL
{
    public class DBHelper
    {
        /// <summary>
        /// 连接字符串
        /// </summary>
       private readonly static string config = ConfigurationManager.ConnectionStrings["logisDb"].ConnectionString;
        /// <summary>
        /// 离线查询，返回DataTable
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="par"></param>
        /// <returns></returns>
        public static DataTable ExecuteTable