Why is grid.Rows.Count always 0?

Question

I have DataSet which is not null. It have 16 rows,

but my grid have no rows. I have bindingSource, here is some code:

bindingSource.DataSource = ds.Tables[0]; //ds is DataSet
grid.DataSource = bindingSource;

double sum1 = 0;
for (int i = 0; i < grid.Rows.Count; ++i)
{
    sum1 += Convert.ToDouble(grid.Rows[i].Cells[13].Value);
}

When I start debugging, when it comes to i < grid.Rows.Count it just jump out of for loop. Any idea why is that happening?

Possible duplicate of [DataGridView.Rows.Count is 0](http://stackoverflow.com/questions/23130156/datagridview-rows-count-is-0) — Claudius, Mar 25 '16 at 11:47
What is bindingSource? Why not simply `grid.DataSource = ds.Tables[0];`? Also check if it needs `grid.DataBind();` to actually reflect to gridview — Sangram Nandkhile, Mar 25 '16 at 11:58

score 4 · Accepted Answer · edited Mar 25 '16 at 13:51

4

you need to directly assign the data table to DataGridView DataSource..

grid.DataSource = ds.Tables[0];

double sum1 = 0;
for (int i = 0; i < grid.Rows.Count; ++i)
{
    sum1 += Convert.ToDouble(grid.Rows[i].Cells[13].Value);
}

It Works....

edited Mar 25 '16 at 13:51

Logerfo

469
5
17

answered Mar 25 '16 at 11:48

Er Ketan Vavadiya

283
3
14

Yeah... You are all right. There is no need for binding source. – nemostyle Mar 25 '16 at 12:10

Why is grid.Rows.Count always 0?

1 Answers1