App.Configure中
<connectionStrings>
<add name= “connStr” connectionStrings= "server=.;database=LoginDB;uid=sa;pwd=123456" />
</connectionStrings>
SQLHelper.cs中
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using Models;
public class SQLHelper
{
private static string connection = ConfigurationManager.ConnectionStrings["connStr"].ToString();
/// <summary>
/// 执行增删改
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static int Update(string sql)
{
SqlConnection conn = new SqlConnection(connection);
SqlCommand cmd = new SqlCommand(sql,conn);
try
{
conn.Open();
return cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception("执行方法public static int Update(string sql)发生异常:" + ex.Message);
}
finally
{
conn.Close();
}
}
/// <summary>
/// 执行单一结果查询
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static object GetSingleResult(string sql)
{
SqlConnection conn = new SqlConnection(connection);
SqlCommand cmd = new SqlCommand(sql,conn);
try
{
conn.Open();
return cmd.ExecuteScalar();
}
catch (Exception ex)
{
throw new Exception("执行方法public static object GetSingleResult(string sql)发生异常:" + ex.Message);
}
finally
{
conn.Close();
}
}
public static SqlDataReader GetReader(string sql)
{
SqlConnection conn = new SqlConnection(connection);
SqlCommand cmd = new SqlCommand(sql,conn);
try
{
conn.Open();
//添加枚举CommandBehavior.CloseConnection之后,将来reader对象的链接会跟随reader对象的关闭自动关闭
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (Exception ex)
{
throw new Exception("执行方法 public static SqlDataReader GetReader(string sql)时发生异常:" + ex.Message);
}
}
}