Insert value into unbound column in bound datagridview

Question

0.00/5 (No votes)

See more:

I have a DataGridView that is bound but it also has several unbound columns. I'm calculating the values in some of these unbound cells through values on the form including other cells that are bound.

I can successfully set the value of a cell, however, under no circumstances is the value being reflected on the UI. I've checked the value on the proper cells as I exit the method and they are correct. I've tried refreshing and updating, but still nothing appears on the front end.

Can anyone tell me why the UI is not showing the values?
This is using Winforms and not WPF if it matters.

I'm doing this in the usual way,

dgv.Rows[i].Cells[j].Value = val;

TIA

Posted 6-Jun-11 22:32pm

Mustafa Ismail Mustafa

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2011-06-07T00:48:00

Solution 1

Dude, I'm not sure that you are using any datagridview events. These links will help you.

Calculation in DataGridView cells[^]

Calculation in DataGridView column[^]

Implementing an Excel-like formula engine[^]

EDIT
-------------------------
Using Calculated DataColumns in ADO.NET[^]

Calculate the running total in a datagridview[^](In Form load)

Loan Calculator Example using DataGridView[^]

Posted 7-Jun-11 0:48am

thatraja

Updated 7-Jun-11 2:00am

v2

Comments

Mustafa Ismail Mustafa 7-Jun-11 7:48am

Well, there are initial calculations that I need to perform and these ought to happen at Form_Load(). I'll try to do that at the DatabindingComplete() event and come back with an answer

thatraja 7-Jun-11 8:00am

For initial calculations, you can do calculations in Datatable/dataview & then you can bind that to Datagridview.
Check my updated answer.

Mustafa Ismail Mustafa 7-Jun-11 7:53am

It worked! The question is why?! Why should it matter that I used an event to set the value whilst I cannot do it explicitly?