using System;
using System.Data;
using System.Configuration;
using System.Data.OleDb;
namespace xxxxx
{
/// <summary>
/// Access数据库访问类
/// </summary>
public class DataAccess
{
private static OleDbConnection conn = new OleDbConnection();
private static OleDbCommand comm = new OleDbCommand();
private static string asscessPath = @".\PoliScan.mdb";
/// <summary>
/// 设置Access数据库路径
/// </summary>
/// <param name="path">完整的路径字符串</param>
public static void SetAccessPath(string path)
{
asscessPath = path;
}
/// <summary>
/// 打开数据库
/// </summary>
/// <returns>成功返回 true；失败返回 false；异常时抛出异常</returns>
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;
/// <summary>
/// DataBase 的摘要说明
/// </summary>
public class DataBase : IDisposable
{
public DataBase()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
private SqlConnection con; //创建连接对象
#region 打开数据库连接
/// <summary>
/// 打开数据库连接.
/// </summary>
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();
}
- 1
- 2
前往页