Loading

starting database in Visual Studio and connection string

Dan

Hello there

I'm learning c# and enjoy it, but still have a looong way to go;o)

I have a .bak file that I have recovered in MS SQL SERVER Man. studio and now want to connect to it within VS 2010 (I have installed SP1)
How do I do that?
And secondly, do I need to set up a connection string, and how is that done?

Would appeciate any direction, since I stuck:o(

Kind Regards
D

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak14y ago
Hi Dan,

For web application

Web.config

Call it in webpage as

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ToString());

Please refer the below link

http://www.c-sharpcorner.com/uploadfile/abhikumarvatsa/connection-string-placement-in-Asp-Net/

http://www.codeproject.com/Articles/6538/Configuration-Settings-File-for-providing-applicat

Thanks