How to show a table in dataGridView on the click of button

In this blog I will tell you how to show a table on the click of button

First of all you have to create  a table in a database for this you  have to do following things:

1 goto Project then click on Add Components. In Add New Item you have to click Service-based Database .

2. In Server Explorer  you have to add a new table with data by clicking Tables under Data Connection.

3. when you add the table and data in a table you have to write these  code in a button click.

 private void button1_Click(object sender, EventArgs e)       

        {

            SqlConnection sc = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True");

            sc.Open();

            SqlDataAdapter sd = new SqlDataAdapter("select * from customers", sc);

            DataSet ds = new DataSet();

            sd.Fill(ds, "customers");

            dataGridView1.DataSource = ds.Tables[0];

            

              sc.Close();

        }

            

    In this code my table is customers.