【文件属性】:
文件名称:c#操作数据库类-sql
文件大小:13KB
文件格式:TXT
更新时间:2014-10-01 14:36:18
c# 类 数据库类 操作
public class DataBase
{
#region //数据连接字符串
protected static string ConnectionStr = "Server=127.0.0.1;DataBase=Gdd005;User ID=sa;PWD=";
SqlConnection Conn = new SqlConnection(ConnectionStr);
#endregion
//打开数据库
#region
public static void Open()
{
try
{
SqlConnection Conn = new SqlConnection(ConnectionStr);
Conn.Open();
}
catch (Exception ex)
{
MessageBox.Show("打开数据库出错");
}
}
#endregion
#region SQL操作
///
/// 执行SQL语句,返回影响的记录数
///
public static int ExecuteSQL(string SQLString)
{
SqlConnection Conn = new SqlConnection(ConnectionStr);
SqlCommand Cmd = new SqlCommand(SQLString, Conn);
try
{
Conn.Open();
int rows = Cmd.ExecuteNonQuery();
return rows;
}
catch (System.Data.SqlClient.SqlException E)
{
throw new Exception(E.Message.ToString());
}
}
///
/// 执行两条SQL语句,实现数据库事务
///