DAL/DBHelper.cs

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

namespace DAL
{
    public class DBHelper
    {
        private static string str = ConfigurationManager.ConnectionStrings["Student"].ConnectionString;
        private DataTable GetDataTable(string strSql)
        {
            SqlConnection conn = new SqlConnection(str);
            if (conn.State == ConnectionState.Closed)
            {
                conn.Open();
            }
            SqlCommand comm = new SqlCommand(strSql,conn);
            SqlDataAdapter da = new SqlDataAdapter(comm);
            DataTable dt = new DataTable();
            da.Fill(dt);
            conn.Close();
            conn.Dispose();
            return dt;
        }
        private int ExecuteSql(string strSql, SqlParameter[] pars)
        {
            SqlConnection conn = new SqlConnection(str);
            if (conn.State == ConnectionState.Closed)
            {
                conn.Open();
            }
            SqlCommand comm = new SqlCommand(strSql,conn);
            if (pars != null)
            {
                comm.Parameters.AddRange(pars);
            }
            int i = 0;
            i = comm.ExecuteNonQuery();
            conn.Close();
            return i;
        }
    }
}