if i put my ms-access database in app-data folder then what the connection string

Posted by Umeshdwivedi under ASP.NET on 6/23/2011 | Points: 10 | Views : 2003 | Status : [Member] | Replies : 2
hallo every body
if i keep the my ms-access database in app_data folder
then what the connection string.
any body tell me

Latest Technology Trainer
And Part time software consultant



Responses

Posted by: Ndebata on: 6/23/2011 [Member] Starter | Points: 25

Up
0
Down
It will be something like this
string constring="provider=Microsoft.Jet.OLEDB.4.0;data source=" + Server.MapPath(@"App_Data/MyDatabase.mdb");


Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Susanthampy on: 6/24/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
<connectionStrings>


<add name="AddressBookConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\AddressBook.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

</connectionStrings>


Regards,
Susan

Umeshdwivedi, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response