how to display more than one record on datagridview

Question

i have a sql database whenever i load table with more than one record it does not display it only display if table has only record how an i solve please using c#

Manoj Bhoir · Answer

You should use a DataAdapter and use it to populate a DataTable . Create a method for grabbing the data like this : public DataTable GetDataTable() { DataTable dt = new DataTable(); using (SqlConnection con = new SqlConnection (@YourConnectionString)) { using (SqlCommand cmd = new SqlCommand (query con)) { var adaptor = new SqlDataAdapter (); adaptor.SelectCommand = cmd; con.Open(); adaptor.Fill(dt); return dt; } } } Then You can reference it with your DataGrid : DatagridView1.DataSource = GetDataTable();

Manoj Bhoir · Answer

Welcome.

Carlos kambui · Answer

thank s missing this var adaptor = new SqlDataAdapter (); adaptor.SelectCommand = cmd;

Carlos kambui · Answer

no effects it still display the first row of database

Dipankar Biswas · Answer

hi.. http://stackoverflow.com/questions/14340567/c-datagridview-shows-only-one-row