how to set the connection string to App_Data folder database for hosting

Hi Mohammed Rafi,
Kindly used the below connection string to access the database inside the AppData folder.


<connectionStrings>
<add name="ApplicationServices"
connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
providerName="System.Data.SqlClient" />
</connectionStrings>

With regards,
J.Prabu.
[Email:prbspark@gmail.com]

mohammedr88-18313, if this helps please login to Mark As Answer. | Alert Moderator

hi Prabu,

thank u , but im asking while hosting

mohammedr88-18313, if this helps please login to Mark As Answer. | Alert Moderator

while hosting to ftp site

mohammedr88-18313, if this helps please login to Mark As Answer. | Alert Moderator

Hi Mohammed Rafi,
I cant able to understand your questions, In web.config file, we can set the connection string to access the database. Kindly ask clearly to get help from others. What code your using currently in your application.

With regards,
J.Prabu.
[Email:prbspark@gmail.com]

mohammedr88-18313, if this helps please login to Mark As Answer. | Alert Moderator

Hi
1) Im using a database which is in App_Data folder for this the connection string is ,

<connectionStrings>

<add name="MyConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=.\SQLEXPRESS;database=C:\WebApplication2\WebApplication2\App_Data\LocalDatabase.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

</connectionStrings>


2) on hosting tat application to ftp server the App_Data folder location changes for this how to specify the connection string ?

mohammedr88-18313, if this helps please login to Mark As Answer. | Alert Moderator