Hi Everyone,
I have recently learnt how to get my SQL database uploaded onto my internet server host with a great tutorial in FAQ
I am FTPing my Visual Web Developer Website up onto my internet host server and I want the website to be connected to the database so that I can use GridView and DataView etc.
I would now like to make my CONNECTION srting in my web.config file
by default the connection Visual Web Developer makes is:
------------------------------------------------------------------------------------------------------------------
<
add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
------------------------------------------------------------------------------------------------------------------
How do I determine the exact DataDirectory that my host server stores the SQL database at? I think there is an automatic way of determining this?
Also: now that I have uploaded my database from Visual Web Developer do I have to change any other part of the connection string?
can someone give me an example of a functioning string for this.
thanks for your help. 