DAL/DBHelper.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data .SqlClient ;
using System.Data;
using System.Configuration;
namespace DAL
{
   public class DBHelper
    {
       public DBHelper()
       { 
       
       }
      // private static SqlConnection connection;
       public static SqlConnection CreatConn()
       {
           SqlConnection conn = new SqlConnection();
           conn.ConnectionString = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
           return conn;
       }
       public static DataTable GetTable(string strsql)
       {
           //SqlDataAdapter daap = new SqlDataAdapter(cmd);
           SqlConnection conn = CreatConn();
           SqlCommand cmd = new SqlCommand();
           cmd.Connection = conn;
           cmd.CommandText = strsql;
           DataTable dt = new DataTable();
           SqlDataAdapter daap = new SqlDataAdapter();
           daap.SelectCommand = cmd;
           daap.Fill(dt);
           return dt;
       }

     //通用的方法，已知增删改的sql语句，用于实现增删改操作
       public static int changeData(string strSql)
       {
           int result = 0;
           SqlConnection conn = CreatConn();
           SqlCommand cmd = new SqlCommand(strSql, conn);
           try
           {
               conn.Open();
               result = cmd.ExecuteNonQuery();
           }
           catch (Exception ex)
           {
               Console.WriteLine(ex.Message);
           }
           finally
           {
               conn.Close();
           }
           return result;
       }
    }
}