Tips:DBHelp代码在文章底部。
如果显示 Configuration不存在,则需在引用中添加
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace 命名空间名称
{
class DBHelpers
{
//连接字符串
static string conString = ConfigurationManager.ConnectionStrings[""].ConnectionString;
/// <summary>
/// //查询, 返回DataTable
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static DataTable GetDataTable(string sql)
{
DataTable dt = new DataTable();
//1.创建连接对象
using (SqlConnection con=new SqlConnection(conString))
{
//2.创建适配器对象,执行SQL语句,填充Datatable
SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, con);
dataAdapter.Fill(dt);
}
return dt;
}
/// <summary>
/// 查询单个值,如聚合函数
/// </summary>
public static object GetOneValue(string sql)
{
//1.创建连接对象
using (SqlConnection con = new SqlConnection(conString))
{
//2.打开连接
con.Open();
//3.创建命令对象,执行SQL语句
SqlCommand cmd = new SqlCommand(sql, con);
object obj = cmd.ExecuteScalar();
return obj;
}
}
/// <summary>
/// 执行 增,删,改
/// </summary>
/// <returns></returns>
public static bool ExcuteDML(string sql)
{
//1.创建连接对象
using (SqlConnection con = new SqlConnection(conString))
{
//2.打开连接
con.Open();
//3.创建命令对象,执行SQL语句
SqlCommand cmd = new SqlCommand(sql, con);
int n =cmd.ExecuteNonQuery();
return n>0;
}
}
}
}