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

Question

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

Satya Karki · 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" />

Krutika Karekar · Answer

Hii..thank you for the help..I used this code along with the full path of database file..it works..thanks once again

Rijwan Ansari · Answer

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 Singh · Answer

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.

Rajanikant Hawaldar · Answer

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/

Vinitha T · Answer

At webconfig file, add name = "sqlServer" providerName= "System.Data.SqlClient" connectionString= "Data Source=.;Initial Catalog=MyDatabase;Integrated Security=True" />

Vikas Panwar · Answer

https://www.c-sharpcorner.com/code/3379/connection-strings-in-web-config-file-using-asp-net.aspx