db.cs

来自「gridview右键菜单,可实现查看修改」· CS 代码 · 共 38 行

using System;
using System.Data;
using System.Data.SqlClient;

public class DB
{
	public DB()
	{
		
	}

    public static SqlConnection SqlConn
    {
        get { return new SqlConnection("server=(local);database=tempdb;uid=sa;pwd=;"); }
    }

    public static DataTable GetTable(string sql)
    {
        using (SqlConnection conn = SqlConn)
        {
            SqlDataAdapter da = new SqlDataAdapter(sql, conn);
            DataSet ds = new DataSet();
            da.Fill(ds);
            return ds.Tables[0];
        }
    }

    public static int Execute(string sql)
    {
        using (SqlConnection conn = SqlConn)
        {
            SqlCommand cmd = new SqlCommand(sql, conn);
            conn.Open();
            return cmd.ExecuteNonQuery();
        }
    }
}