没有合适的资源?快使用搜索试试~ 我知道了~
DBHelper.cs类(万能)
4星 · 超过85%的资源 需积分: 33 32 下载量 132 浏览量
2012-12-06
10:21:30
上传
评论
收藏 11KB TXT 举报
温馨提示
试读
12页
DBHelper.cs类(万能)public class DBHelp { public static SqlConnection connection; public static SqlConnection Connection
资源推荐
资源详情
资源评论
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using BookShop.Models;
namespace BookShop.DAL
{
public class DBHelp
{
public static SqlConnection connection;
public static SqlConnection Connection
{
get
{
string connectionString = ConfigurationManager.ConnectionStrings["mybookshop"].ConnectionString;
if (connection == null)
{
connection = new SqlConnection(connectionString);
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Closed)
{
connection = new SqlConnection(connectionString);
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Broken)
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
using BookShop.Models;
namespace BookShop.DAL
{
public class DBHelp
{
public static SqlConnection connection;
public static SqlConnection Connection
{
get
{
string connectionString = ConfigurationManager.ConnectionStrings["mybookshop"].ConnectionString;
if (connection == null)
{
connection = new SqlConnection(connectionString);
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Closed)
{
connection = new SqlConnection(connectionString);
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Broken)
{
connection.Close();
connection.Open();
}
return connection;
}
}
#region 增,删,改ExecuteNonQuery
/// <summary>
/// 单个数据增,删,改
/// </summary>
/// <param name="safeSql"></param>
/// <returns></returns>
public static int ExecuteCommand(string safeSql)
{
try
{
using (SqlCommand cmd = new SqlCommand(safeSql, Connection))
{
int result = cmd.ExecuteNonQuery();
return result;
}
}
catch (SqlException ex)
{
connection.Close();
connection.Open();
}
return connection;
}
}
#region 增,删,改ExecuteNonQuery
/// <summary>
/// 单个数据增,删,改
/// </summary>
/// <param name="safeSql"></param>
/// <returns></returns>
public static int ExecuteCommand(string safeSql)
{
try
{
using (SqlCommand cmd = new SqlCommand(safeSql, Connection))
{
int result = cmd.ExecuteNonQuery();
return result;
}
}
catch (SqlException ex)
{
剩余11页未读,继续阅读
资源评论
- zwjmouse2013-01-15可以用,但是用处不大
- 至尊宝♬2013-01-18不错,可以使用。
- qq8520432652013-01-06不好,没有针对性,用起来不方便
- robinKzz2015-04-15不错,可以使用。
iseehz
- 粉丝: 0
- 资源: 3
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功