no data avilable in the datgridview

Question

hi i have a prblobem
i wrote this code in

form_load

  foreach (DataGridViewRow R1 in dataGridView1.Rows)
            {
                foreach (DataRow Row in T.Rows)
                {

                    if (Convert.ToInt32(R1.Cells[0].Value) == Convert.ToInt32(Row[0]))
                        R1.Cells[3].Value = Convert.ToInt64(Row[1]);

                }

            }

but no data apper in the datagridview
when i wrote it in button click

the data appers
how can i solve it in the form load??
thx

Answer 1

Do you set the DataSource and execute DataBind for the DataGridView before executing the query above?

Answer 2

yes i do it

Answer 3

Try to use DataGridView.DataBindingComplete event.

Check this link for instructions: http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.databindingcomplete.aspx

Answer 4

Yep, DataBindingComplete event would do the trick for you.  If you handle that event (and put a breakpoint), you'll see that it's fired a few times (about 2 or 3 times) when you bind your DataGridView for the first time, and the first time around you'll see that there are no rows in the DataGridView. Subsiquent bindings only fire once. As to the explanation of this behavior, well, ... :-)

---

"'Impossible' doesn't mean something cannot be done. It simply means no solution is known to the individual(s) in question." - Mbongo M. Mpongwana

Answer 5

Is there any data or rows in your DGV before you run this loop to update cell value.

Else, put a break point and check how many rows you have in DGV and debug each step to find the cause.

And if it still doesn't work, post your code!

---

Amit Govil | Email

"Weeks of coding can save you hours of planning"

Answer 6

Hi Aboudeh,

Any update to this issue?

There many reason can cause this issue. For example, the row count in the DataGridView is zero.

It is hard to detect the issue without the code. I suggest you debug the code line by line.

If the issue is still not solved, could you please post your code here?

Best Regards,

---

Bob Wu [MSFT]
MSDN Community Support | Feedback to us