Here binding data with datagridview control in C#
SqlConnection con = new SqlConnection("server=****\\sqlexpress; uid=sa; password=sa; database=****");
con.Open();
SqlDataAdapter ada = new SqlDataAdapter("select * from tableName", con);
DataTable dt = new DataTable();
ada.Fill(dt);
dataGridView1.DataSource = adaa;
dataGridView1.DataSource = adaa;
with