Try below code on click of Load button
string query = "SELECT * FROM Person";
SqlDataAdapter da = new SqlDataAdapter(query, connection);
SqlCommandBuilder cb = new SqlCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
BindingSource bs = new BindingSource();
bs.DataSource = dt;
dataGridView1.DataSource = bs;