Connection String to SQL Server database for ASP.NET C#

Question

I'm facing some problems with creating a connection string to my SQL Server database. I'm running Visual Studio 13. I want to connect to the database from a ASP.NET C# application. How should my connection string be formed?

There are many only resources that will answer this question. A quick Google will give you many, many options. Do some research on the problem and I'm sure you will find the answer. — Davin Tryon
– Davin Tryon, Commented Jan 31, 2015 at 22:33
possible duplicate of How to create a connection string in asp.net c# — Nazmul Hossain
– Nazmul Hossain, Commented Jan 31, 2015 at 22:50

parek · Accepted Answer · 2015-01-31 22:41:39Z

1

If you have the database showing in the Server Exporer in Visual Studio you can copy the ConnectionString from it's properties.

However, Connection Strings aren't complicated, of course depending on your database settings, but the basic template looks like this:

Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;
Password=myPassword;

There's a lot of references about Connection Strings out there, have a look.

answered Jan 31, 2015 at 22:41

parek

7821 gold badge14 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ako · Accepted Answer · 2015-01-31 22:37:54Z

0

open ServerExplorer in ViEW menue and Right Click On Your DataBase go to Property then there is a ConnectionString I Think that is what you want ...

answered Jan 31, 2015 at 22:37

ako

1797 bronze badges

Comments

mickl · Accepted Answer · 2018-03-01 05:59:00Z

0

The basic connectionString looks like-

If you are setting in Code behind file then do this -

string conStr = @"Data Source=ServerName;Initial Catalog=Database;User Id=User;Password=Password";

If want to set in Config file then follow this -

<appSettings>
   <add key="KeyName" value="Data Source=ServerName;Initial Catalog=Database;User Id=User;Password=Password"/>
</appSettings>

Hope it helps..

edited Mar 1, 2018 at 5:59

mickl

50.1k9 gold badges71 silver badges99 bronze badges

answered Mar 1, 2018 at 5:40

Mohan Kamargiri

12 bronze badges

1 Comment

Mohan Kamargiri Over a year ago

Thanks for editting and formatting it...I'll take care from next time..@mickl

Collectives™ on Stack Overflow

Connection String to SQL Server database for ASP.NET C#

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related