Conectarse a sql y llenar GridView en C#?

[ErnestoTorres04]

Usa este codigo

SqlConnection con = new SqlConnection("Data Source = servidor; Initial Catalog = BD; User=user; Password=Contraseña; Integrated Security = true");
con.Open();
SqlCommand cmd = new SqlCommand("Consulta SQL", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();
da.Fill(dt);
dgvDatos.DataSource = dt;
con.Close();