Use the ACCESS database to configure the connection string

ExampleofASP. Net2.0AccessDatabaseConnectionStringconnectionStringsaddnameaccessConnStrconnectionStringProviderMicrosoft. Jet. OLEDB.4.0; DataSource | DataDirectory | ajTravelDB. mdbproviderNameSystem. Data. OleDbconnec

Example of ASP. net 2.0 Access Database Connection String connectionStrings add name = "accessConnStr" connectionString = "Provider = Microsoft. jet. OLEDB.4.0; DataSource = | DataDirectory | ajTravelDB. mdb "providerName =" System. data. oleDb "// connec

Example of ASP. Net 2.0 Access Database Connection String

NameAttribute of connectionstrings add element contains the nameAccessConStrFor the connection string.

ConnectionStringAttribute contains the connection string format supported by Oledb drivers.| DataDirectory |Is used in the above of connection string to connect the MS Access Database placed inside the App_Data directory. By Default| DataDirectory |Maps the path of database file placed inside the default App_Data directory. After| DataDirectory |Add up the name of MS Access Database filename as shown in above example.

ProviderNameAttribute contains the name of the Namespace of ASP. Net 2.0 that will provide the methods and functions for Data Access while coding.