access datasource

Hi,

I want to assign a path to the access datasourcefrom my web.config file.

 I have done this but don't know what is wrong plz help

AccessDataSource2.DataFile=New
Data.OleDb.OleDbConnection(System.Configuration.ConfigurationManager.AppSettings
("connectionstring"))

plz reply asap....

Thanks all....

Use this intead.

ConfigurationSettings.AppSettings("connectionstring")

or

ConfigurationManager.ConnectionStrings("connectionstring").ConnectionS
tring

Hi,

do i do it like

accessdatasource1.datafile=New
Data.OleDb.OleDbConnection(System.Configuration.ConfigurationManager.ConnectionS
trings("connectionstring").ConnectionString)

 

regards

I didn't realize that you are assigning it to DataFile. The DataFile property
accepts a path to the datafile. So in this case, you might have to do something
like this: 

<appSettings>
    <add key="connectionstring"
value="~\folder\database.mdb" />
</appSettings>

 And then,

AccessDataSource2.DataFile =
ConfigurationSettings.AppSettings("connectionstring")

sorry that didnt work as well

i did  AccessDataSource2.DataFile =
ConfigurationSettings.AppSettings("connectionstring") 

 

regards