'SqlConnection' does not contain a constructor that takes 4 arguments

Question

This is the code:

public void SqlDbConnect()
{
    SqlConnection conn = new SqlConnection("Data Source={0};User ID={1};Password={2};", server, user, password);
    conn.Open();
}

I try to make connection via server name, user and pass.

Answer 1

You need to format the string and then pass that string to the constructor (This is a C# 6 specific feature):

SqlConnection conn = new SqlConnection($"Data Source={server};User ID={user};Password={password};");

Or in older C# versions you can use string.Format:

SqlConnection conn = new SqlConnection(string.Format("Data Source={0};User ID={1};Password={2};", server, user, password));