datagrid show if only table has one record

Question

my datagrid show if only table has one record how can i solve it

Carlos kambui · Answer

no effects sir

Dipankar Biswas · Answer

hi try it.. private void all_data() { if (connectiondb.State == ConnectionState.Closed) { connectiondb.Open(); } string all_data_query = Select * from tbl_result; OleDbCommand com = new OleDbCommand(all_data_query connectiondb); com.CommandType = CommandType.Text; OleDbDataAdapter da = new OleDbDataAdapter(com); DataTable dt = new DataTable(); da.Fill(dt); this.dataGridView1.DataSource = dt; connectiondb.Close(); } only Change.. oledb to sql