定义ACCESS数据库文件地址代码,CSharp代码库,德仔网

代码语言
代码分类
【CSharp】定义ACCESS数据库文件地址
作者:xqf222 / 发布于2014/2/25/ 406
C# 应用程序类中定义ACCESS数据库文件地址的方法
方法一:
数据库访问类
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Data;

namespace Link.DataBase
{
 public class DBManage
 {
 System.Data.OleDb.OleDbConnection gConn = null;

 public OleDbConnection Conn
 {
 get { return gConn; }
 }
 //定义类公开对外的数据库连接对象变量
 static string strConnectionString;
 //设置数据链接参数
 static public string ConnectionString
 {
 set
 {
 strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + value + ";User ID=admin;Password=;Jet OLEDB:Database Password=";
 }
 }

 //数据库连接对象
 public DBManage()
 {
 gConn = new OleDbConnection(strConnectionString);
 }
 //查询数据库资料
 public OleDbDataReader ExecuteReader(string SQL)
 {
 OleDbDataReader reValue = null;
 OleDbCommand comm = new OleDbCommand();
 comm.CommandText = SQL;
 comm.Connection = gConn;
 reValue = comm.ExecuteReader();
 return reValue;
 }
 //执行SQL查询语句返回数据表对象
 public DataTable ExecuteTable(string SQL)
 {
 DataTable table = new DataTable();
 gConn.Open();
 OleDbCommand comm = new OleDbCommand();
 comm.CommandText = SQL;
 comm.Connection = gConn;
 System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter(comm);
 System.Data.OleDb.OleDbCommandBuilder commBuild = new System.Data.OleDb.OleDbCommandBuilder(adapter);
 table.Locale = System.Globalization.CultureInfo.InvariantCulture;
 adapter.Fill(table);
 gConn.Close();
 return table;
 }
 //直接运行输入SQL语句参数
 public void ExecuteNonQuery(string SQL)
 {
 OleDbCommand comm = new OleDbCommand();
 gConn.Open();
 comm.CommandText = SQL;
 comm.Connection = gConn;
 comm.ExecuteNonQuery();
 gConn.Close();
 }

 }
}
窗体调用方法

public LinksManagement()
 {
 DBManage.ConnectionString = Application.StartupPath + @"/ExchangeLinksDB.mdb";
 InitializeComponent();
 }

方法二:

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;

//数据访问层
namespace Link.DataBase
{
 public class CreateUrlManager
 {

 private OleDbConnection cnn;

 private static string strConnectionString;

public CreateUrlManager()
 {
 if (System.Environment.CurrentDirectory == AppDomain.CurrentDomain.BaseDirectory)//Windows应用程序则相等
 {
 strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AppDomain.CurrentDomain.BaseDirectory + "Bin//ExchangeLinksDB.mdb;";
 }
 else//Windows类程序不相等
 {
 strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AppDomain.CurrentDomain.BaseDirectory + "ExchangeLinksDB.mdb;";
 }
 }

}
试试其它关键字
　定义ACCESS数据库　
同语言下
可能有用的
xqf222贡献的其它代码(82)