Database connection string

Programming, development, testing

→

ADO.NET (working with the database on C#)

→

Database connection string | ADO.NET, C#

Looked at 4945 times

Database connection string | ADO.NET, C#

last updated: 22 July 2025

To make a connection string, do the following:
In Visual Studio click Tools → Connect to Database... in the menu

In the "Add Connection" window, select

Server name:

Select the computer where the server is located for the database.
The server for the database is the program SQl Server

1) can be selected from the list [v]

2) You can write local, which means we will use SQL Server on your computer (locally).

Select or enter a database name:

Choose a database name

1) can be selected from the list [v]

Click Test Connection to see if there is a connection to the database (i.e. if we have specified server name and database name correctly)

Press the "Advanced..." button

Let's copy the text:

C# In the C# code, we will use it to connect to the database

string connectionString = @"Data Source=localhost;Initial Catalog=MyDatabase1;Integrated Security=True;Trust Server Certificate=True";

← Previous topic
Read the image from the database and save it to a file | ADO.NET, C#

Your feedback ... Comments ...

Объявления

Working with data in ADO.NET

Stored procedures in ADO.NET

• Stored procedures in ADO.NET | C#

Transactions in ADO.NET

Reading the picture from the database ADO.NET

Additional topics, questions

• Database connection string | ADO.NET, C#