DBHelper.cs

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

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

namespace WindowsFormsApplication1
{
    class DBHelper
    {
       public static readonly string constr= @"Data Source=.;Initial Catalog=yzr60;Integrated Security=True";

       public static DataTable GetData(string sql) {
           SqlConnection connection = new SqlConnection(constr);
           SqlDataAdapter ada = new SqlDataAdapter(sql, connection);
           DataTable datatable = new DataTable();
           connection.Open();
           ada.Fill(datatable);
           return datatable;
       }

       public static int AddOrUpdateOrDelete(string sql) {
           SqlConnection connection = new SqlConnection(constr);
           SqlCommand command = new SqlCommand(sql,connection);
           connection.Open();
           return command.ExecuteNonQuery();
       }

    }
}