在根目录下添加类找到应用程序配置文件默认名称App.config不要进行更改
引用一个命名空间添加引用命名空间
using System.Configuration;
App.config数据库连接字符串
<connectionStrings>
<add name="connString" connectionString="Server=.;DataBase=SMDB;Uid=sa;Pwd=123456"/>
</connectionStrings>
连接字符串调用
public static readonly string connString = ConfigurationManager.ConnectionStrings["connString"].ToString();
编写通用数据访问类(不带参数的访问方法)
执行增删改操作
public static int Update(string sql)
{
SqlConnection conn =new SqlConnection(connString);
SqlCommand cmd=new SqlCommand(sql, conn);
try
{
conn.Open();
return cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
//将异常信息写入日志...
throw ex;
}
finally
{
conn.Close();
}
执行单一结果查询
public static object GetSingleResult(string sql)
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand(sql, conn);
try
{
conn.Open();
return cmd.ExecuteScalar();
}
catch (Exception ex)
{
//将异常信息写入日志...
throw ex;
}
finally
{
conn.Close();
}
}
执行一个结果集的查询
public static SqlDataReader GetReader(string sql)
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand(sql, conn);
try
{
conn.Open();
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (Exception ex)
{
//将异常信息写入日志...
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
throw ex;
}
}
执行返回数据集的查询
public static DataSet GetDataSet(string sql)
{
SqlConnection conn = new SqlConnection(connString);
SqlCommand cmd = new SqlCommand(sql, conn);
//创建数据适配器对象
SqlDataAdapter da=new SqlDataAdapter(cmd);
DataSet ds= new DataSet();
try
{
conn.Open();
da.Fill(ds); //使用数据适配器填充数据集
return ds;
}
catch (Exception ex)
{
//将异常信息写入日志...
throw ex;
}
finally
{
conn.Close();
}
}
获取数据库服务器的时间
public static DateTime GetServerTime()
{
return Convert.ToDateTime(GetSingleResult("select getdate()"));
}