连接access数据库的方式,一种直接通过config配置文件,一种直接通过程序中读取连接字符串信息。
第一种方式直接通过代码实现,如下:
首先建立ConnectDB类
namespace 命名空间
{
class ConnectDB(类名)
{
public OleDbConnection OledConn()
{
//创建连接的字符串
String reportPath = Application.StartupPath.Substring(0, Application.StartupPath.Substring(0,
Application.StartupPath.LastIndexOf("//")).LastIndexOf("//"));
reportPath += @"/Database/自己需要操作的数据库.mdb";
string ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + reportPath;
OleDbConnection connection = new OleDbConnection(ConStr);
return connection;
}
}
}
2.调用此数据库连接。如下:
public OleDbDataReader GetDBInfo()
{
ConnectDB getCon = new ConnectDB();
oledCon = getCon.OledConn();
oledCon.Open();
string strAdd = "sql 语句";
oledcmd = new OleDbCommand(strAdd, oledCon);
oleRed = oledcmd.ExecuteReader();
return oleRed;
}
第二种方法是通过congfig文件实现:具体如下:
1.声明dbconnect.config文件,具体内容如下:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
</configSections>
<connectionStrings>
<add name="MyCommunity.Properties.Settings.DBCommunityConnectionString"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|/Data/自己需要操作的数据库.mdb;Persist Security Info=True"
providerName="System.Data.OleDb" />
</connectionStrings>
</configuration>
2.在命名空间的.Properties文件下的Settings.settings中声明如下
public string DBCommunityConnectionString {
get {
return ((string)(this["DBCommunityConnectionString"]));
}
调用如下:
String MyConnectionString = global::命名空间.Properties.Settings.Default.DBCommunityConnectionString;
string MySQL = "sql语句";
OleDbConnection MyConnection = new OleDbConnection(MyConnectionString);
MyConnection.Open();
OleDbCommand MyCommand = new OleDbCommand(MySQL, MyConnection);
OleDbParameter MyNameParameter = new OleDbParameter();
MyCommand.Parameters.Add(MyNameParameter);
}