C# SQL操作数据库
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
namespace HelperLibrary
{
public class DatabaseHelper
{
//连接字符串
public static readonly string ConnectionString = ConfigurationManager.AppSettings["SqlConnection"];
/// <summary>
/// 执行SQL查询语句返回DataTable
/// </summary>
/// <param name="sqlString">SQL语句</param>
/// <param name="cmdParams">命令参数</param>
/// <returns>查询DataTable</returns>
public static DataTable ExecuteDataTable(string sqlString,IEnumerable<SqlParameter> cmdParams=null)
{
using (var conn = new SqlConnection(ConnectionString))
{
var cmd = new SqlCommand();
PrepareCommand(cmd, conn, null, sqlString, cmdParams);
try
{
using (var da = new SqlDataAdapter(cmd))
{
var d