using(SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = "Data Source=windance;Initial Catalog=VCD;Integrated Security=True";
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from sysmanager";
DataTable dt = new DataTable();
conn.Open();
dt.Load(cmd.ExecuteReader(CommandBehavior.CloseConnection));
}
dataGridView1.DataSource = dt;