DataGridView.Rows.Count is 0

Question

I'm trying to read the content of an excel file (I must process the data not show it) but the number of rows is 0. I did show the data in the UI and the rows didn't have a number.

string src = "the path;";
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + src +
                                       "Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"");

OleDbDataAdapter da = new OleDbDataAdapter("select * from [RENNES4_wk13$]", con);

DataSet ds = new DataSet();
da.Fill(ds);
DataGridView dgv = new DataGridView();
dgv.DataSource = ds.Tables[0];
int rows = dgv.Rows.Count;
int cells = dgv.Rows[0].Cells.Count;//ArgumentOutOfRange why?

How do I fix it?

For a start it doesn't look like you're ever opening you're connection? — Ian, Apr 17 '14 at 10:06
it wasn't in the tutorial, just started work on this today. Can you show me? — Mihai Bratulescu, Apr 17 '14 at 10:09
You dont need to open connection. http://stackoverflow.com/questions/15828/reading-excel-files-from-c-sharp — Usama Khalil, Apr 17 '14 at 10:21

Usama Khalil · Accepted Answer · 2014-04-18T03:47:25.360

Try this out

        string src = @"C:\SampleData\us-500.xls";
        OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + src +
                                          ";Extended Properties=Excel 8.0;");

        //con.Open();
        OleDbDataAdapter da = new OleDbDataAdapter("select * from [MySheet$]", con);
        DataSet ds = new DataSet();
        da.Fill(ds);

        BindingSource bindingSource = new BindingSource();
        bindingSource.DataSource = ds.Tables[0];

        var dataGridView1 = new DataGridView();

        // Add data grid view as child control on form, flow Layout Panel is placed on windows form 
        flowLayoutPanel1.Controls.Add(dataGridView1);

        dataGridView1.DataSource = bindingSource;
        int rows = dataGridView1.Rows.Count;
        int cells = dataGridView1.Rows[0].Cells.Count;

hold on, it works for dataGridView1 even without the binding stuff but for new DataGridView it doesn't? how come? — Mihai Bratulescu, Apr 17 '14 at 10:51
you have to add the new DataGridView() to as a child control of any other control in window form — Usama Khalil, Apr 18 '14 at 02:57

score 1 · Answer 2 · edited May 23 '17 at 11:52

1

try this:

BindingSource bindingSource = new BindingSource();
bindingSource.DataSource = resultDt;

in your case:

bindingSource.DataSource = ds.Tables[0];

and:

dgResult.DataSource = bindingSource;
flowLayoutPanel.Controls.Add(dgResult); 

var c = dgResult.Rows.Count;

The binding source is what's responsible for syncing your data with the control. You want to use it, rather than trying to assign the table directly to the control.

Reference:

Datagridview rowcount showing 0 even when there is a valid datasource

edited May 23 '17 at 11:52

Community

1
1

answered Apr 17 '14 at 10:10

Ehsan Sajjad

61,834
16
105
160

.DataBind() is not defined what am I missing? – Mihai Bratulescu Apr 17 '14 at 10:14
ohh it is DataGridView not girdview – Ehsan Sajjad Apr 17 '14 at 10:17
try this: int rows = dgv.RowCount – Ehsan Sajjad Apr 17 '14 at 10:25

DataGridView.Rows.Count is 0

2 Answers2

Linked