♠ Posted by Unknown in access database connection,connection string,database connection,db conncetion,oledb
In This
Article we explain about Data Base Connection with MS Access Data Base 2007
Use Of Data Base connection:
Data base connection is use for retrieve, insert, update, delete
data from database by any system or software.
Following step for establish connection
with Ms Access Data Base 2007
Step 1- Put following code in
web.config file of asp.Net website
<connectionStrings>
<add name="myconnectionstring" providerName="System.Data.OleDb" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=E:\DB\Database1.accdb"/>
</connectionStrings>
Step 2- Import Following two package in your code Behind (.aspx.cs) file where you want to do
connection
using System.Data.OleDb;
using System.Configuration;
Step 3- We Do connection on load of page so put
following code Page_load Event code Behind (.aspx.cs) file where you want to do
connection.
OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["myconnectionstring"].ConnectionString);
...
