How to configure ASP.NET connection string ?

Posted by Helenasmith under ASP.NET on 5/19/2015 | Points: 10 | Views : 430 | Status : [Member] | Replies : 3
I am new to uploading websites online, I have uploaded my website to ASPHostPortal.com and run perfectly but i don't know how to connect my MS Sql Data base and how to configure my connection string !

Can any one help me or give me a tutorial of how doing this starting from a normal MS sql Database with normal connection string (Local DB and Local connection string) until uploading it online ?

Can you describe me step by step to connect my MS Sql Data base and configure my connection string or give me link to learn it ?




Responses

Posted by: Bandi on: 5/19/2015 [Member] [MVP] Platinum | Points: 25

Up
0
Down
you need to configure that in web.config file..

refer
http://stackoverflow.com/questions/5642474/setting-up-connection-string-in-asp-net-to-sql-server
http://stackoverflow.com/questions/1355472/using-the-web-config-to-set-up-my-sql-database-connection-string

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

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

Posted by: Amatya on: 5/19/2015 [Member] Silver | Points: 25

Up
0
Down
http://www.codeproject.com/Questions/156144/How-to-create-a-connection-string-in-asp-net
The Above 1 can also be useful dear

Feel free to share informations 9731764134
mail Id ' adityagupta200@gmail.com
Thanks

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

Posted by: Cacamarica on: 5/20/2015 [Member] Starter | Points: 25

Up
0
Down
Hi Helena,

You may ask your hosting provider about the correct connection string that you need to use. It will be like this:

<add name="connString" connectionString="Data Source=our_SQL_SERVER_ID;uid=your_DB_username;pwd=your_DB_password;Initial Catalog=your_DB_name"></add>


Hope it helps

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

Login to post response