1 项目配置文件
<!--方式1-->
<appSettings>
<add key="sjk" value="Data Source=0064ABBCE6D7\MSSQLSERVER01;Initial Catalog=property;Integrated Security=True"/>
</appSettings>
<!--方式2-->
<connectionStrings>
<add name="shujuku" connectionString="Data Source=0064ABBCE6D7\MSSQLSERVER01;Initial Catalog=property;Integrated Security=True"/>
</connectionStrings>
2 ado增删改查
//1
private static string scon = System.Configuration.ConfigurationSettings.AppSettings["sjk"];//方式1
private static string scon2 = ConfigurationManager.ConnectionStrings["shujuku"].ToString();//方式2
public static SqlConnection con = new SqlConnection(scon2);
//可以不使用static修饰
private static SqlConnection cion = DBHelperlist.con;//获取数据库连接
/// <summary>
/// 返回执行影响行数 增删改
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static bool getboolean(string sql) {
try
{
op();
SqlCommand cmd = new SqlCommand(sql, cion);
int i = cmd.ExecuteNonQuery();
return i > 0;
}
catch (Exception)
{
return false;
}
finally {
co();
}
}
/// <summary>
/// 查询数据
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static DataSet GetDataset(string sql) {
try
{
op();
//SqlCommand cmd = new SqlCommand(sql, cion);
SqlDataAdapter sqlData = new SqlDataAdapter(sql,cion);//创建连接数据库
DataSet set = new DataSet();//创建一个容器
sqlData.Fill(set);//把查询到的数据放在容器里面
return set;//把容器放出去
}
catch (Exception)
{
return null;//没有数据
}finally {
co();
}
}
private static void op() {
if (cion.State == ConnectionState.Closed) {
cion.Open();
}
}
private static void co() {
if (cion.State==System.Data.ConnectionState.Open)
{
cion.Close();
}
}
评论