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;
John Smith
30-Sep-2010Uttam Misra
29-Sep-2010dataGridView1.DataSource = adaa;
with