how to add connection string in web.config of local database

Krutika Karekar

Hii...I am using visual studio 2019. In that I am getting connection string in web.config..So plz tell me how to get that connection string of local database(sql server) in my web.config..so I can test connection..Plz help me

7 Replies

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

Satya Karki5y ago
Accepted answer
try this blog
https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/introduction/creating-a-connection-string
sample:
  <add
    name="sqlServer"
    providerName="System.Data.SqlClient"
    connectionString="Data Source=localhost;Initial Catalog=MyDatabase;Integrated Security=True;Connection Timeout=60" />
Vinitha T4y ago
At webconfig file,

<add
name="sqlServer"
providerName="System.Data.SqlClient"
connectionString="Data Source=.;Initial Catalog=MyDatabase;Integrated Security=True" />
Krutika Karekar5y ago
Hii..thank you for the help..I used this code along with the full path of database file..it works..thanks once again
Rijwan Ansari5y ago
You can simple add in webconfig file.
  <add
    name="sqlServer"
    providerName="System.Data.SqlClient"
    connectionString="Data Source=localhost;Initial Catalog=MyDatabase;Integrated Security=True;" />

https://blog.elmah.io/the-ultimate-guide-to-connection-strings-in-web-config/
Sachin Singh5y ago
open your project in visual studio
on the menu bar go to view ---> Server Explorer
on server explorer--->Right click on data connection--->Add connection
then select your server name or specify it manually if not present in dropdown and then select database name and click ok.
now on server explorer you will notice the database is added , right click on it and select properties there you will find connection string. copy it and replace it with the web.config connection string.
Vikas Panwar5y ago
https://www.c-sharpcorner.com/code/3379/connection-strings-in-web-config-file-using-asp-net.aspx
Rajanikant Hawaldar5y ago
https://www.c-sharpcorner.com/uploadfile/suthish_nair/how-to-generate-or-find-connection-string-from-visual-studio/
https://www.c-sharpcorner.com/UploadFile/d40a40/get-sql-server-database-connection-string-easily-from-visual/