private void button2_Click(object sender, EventArgs e)

{

string select = "SELECT * FROM dbo.teacher";

SqlConnection c = new SqlConnection();

c.ConnectionString = "Data Source=.;Initial Catalog=School;Integrated Security=True";

SqlDataAdapter dataAdapter = new SqlDataAdapter(select, c.ConnectionString);

DataSet ds = new DataSet();

dataAdapter.Fill(ds);

dataGridView1.ReadOnly = true;

dataGridView1.DataSource = ds.Tables[0];

}