Как подключиться к БД?

SqlConnection conn = new SqlConnection();
conn.ConnectionString =
"Data Source=ServerName;" +
"Initial Catalog=DataBaseName;" +
"User id=UserName;" +
"Password=Secret;";
conn.Open();

            conn.ConnectionString =
            "Data Source=localhost;" +
            "Initial Catalog=progbase;" +
            "User id=base;" +
            "Password=123456qweasd;";

MySqlConnection conn = new MySqlConnection("Server=localhost;Database=progbase;Uid=progbase;Pwd=123456;");
                            conn.Open();
                metroTextBox1.Text += "НЫААА";            
            string query = "SELECT * FROM proglogin ORDER BY id";
            MySqlCommand command = new MySqlCommand(query, conn);
 
            MySqlDataReader reader = command.ExecuteReader();
 
            List<string[]> data = new List<string[]>();
 
            while (reader.Read())
            {
                data.Add(new string[4]);
                data[data.Count - 1][0] = reader[0].ToString();
                data[data.Count - 1][1] = reader[1].ToString();
                data[data.Count - 1][2] = reader[2].ToString();
                data[data.Count - 1][3] = reader[3].ToString();
            }
            reader.Close();
            conn.Close();
            foreach (string[] s in data)
                dataGridView1.Rows.Add(s);

string query = "SELECT * FROM proglogin ORDER BY id";
MySqlCommand command = new MySqlCommand(query, conn);
MySqlDataReader reader = command.ExecuteReader();
var dataTable = new DataTable();
dataTable.Load(reader);
dataGridView1.DataSource=dataTable