【文件属性】:
文件名称:C# 数据库访问类 SQLServer 和 Access
文件大小:3KB
文件格式:ZIP
更新时间:2013-04-25 13:02:30
C# 数据库访问 类 SQLServer 和
using System;
using System.Data;
using System.Configuration;
using System.Data.OleDb;
namespace xxxxx
{
///
/// Access数据库访问类
///
public class DataAccess
{
private static OleDbConnection conn = new OleDbConnection();
private static OleDbCommand comm = new OleDbCommand();
private static string asscessPath = @".\PoliScan.mdb";
///
/// 设置Access数据库路径
///
/// 完整的路径字符串
public static void SetAccessPath(string path)
{
asscessPath = path;
}
///
/// 打开数据库
///
/// 成功返回 true;失败返回 false;异常时抛出异常
public static bool OpenConnection()
{
bool retval = false;
if (conn.State != ConnectionState.Open)
{
conn.ConnectionString = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + asscessPath;
comm.Connection = conn;
try
{
conn.Open();
if (conn.State == ConnectionState.Open)
{
retval = true;
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
............................
............................
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Data.SqlClient;
///
/// DataBase 的摘要说明
///
public class DataBase : IDisposable
{
public DataBase()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
private SqlConnection con; //创建连接对象
#region 打开数据库连接
///
/// 打开数据库连接.
///
private void Open()
{
// 打开数据库连接
if (con == null)
{
con = new SqlConnection("Data Source = . ;Database = CET ;Integrated Security = SSPI ");
}
if (con.State == System.Data.ConnectionState.Closed)
con.Open();
}
【文件预览】:
DataBaseAccess.cs
DataBaseSQL.cs