Winform中用配置文件连接数据库
数据库连接类YSqlHelper代码:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace WindowsFormsApp1
{
public class YSqlHelper
{
//配置文件的引用对象ConfigurationManager
//ConnectionSQLString:配置文件中数据库连接字符串的标签名
private static string connectionString = ConfigurationManager.ConnectionStrings["ConnectionSQLString"].ConnectionString;
//查询数据库得到结果放入Datatable并返回
public static DataTable ExecuteNonQuery(String cmdText,CommandType ct)
{
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(connectionString))
{
try
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(cmdText, conn))
{
cmd.CommandType = ct;
using (SqlDataReader sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
dt.Load(sdr);
}
}
}
catch(Exception e)
{
System.Diagnostics.Debug.WriteLine(e.Message);
}
finally
{
if