Clumsy birds have essay: The code that connects to SQL Server database in ADO

The code to connect to the SQL Server database added in the main function is as follows:

The following code is used for SQL Server authentication methods

First you need to reference the namespace

Using System. System.Data.SqlClient;

static void Main (string[] args)
{
String constring = "server=local;database=teaching;uid=sa;pwd=123456";
using (SqlConnection conn = new SqlConnection (constring))
{
Conn. Open ();
}
}

Where server=local represents the name of the SQL Server database servers, local or. Both represent the on-premises database.

Where database=teaching represents the name of the database to connect to.

Where Uid=sa and pwd=123456 indicate that the user name logged into the database library is SA and the password is 123456.

Clumsy birds have essay: The code that connects to SQL Server database in ADO