Calcul in datagridview c#

Amit Gupta9y ago

Accepted answer

var DataTable dt=new DatTable();

dt.Columns.Add("C1");

dt.Columns.Add("C2");

dt.Columns.Add("C3");

dt.Columns.Add("C4");

dt.Columns.Add("C5").Expression = "IFF ( [C1]=0, [C2], 'No value' ";

gridView.DataSource = dt;

+1

dzconception9y ago

nice ... solved

thank you

0

dzconception9y ago

ho to use formula in c# with datagridview ?

i have this video : https://www.youtube.com/watch?v=Z0YCFjNxbXM

0

Amit Gupta9y ago

If you want your resulting column as readonly, I recommend to use formula in your datatable column that you used to bind the gridview else if your gridview rows are editable then you can use cellendedit event and implement your formula based on your requirement.

Follow the below link to implement event

http://stackoverflow.com/questions/11028405/datagridview-cell-edit-end-event

Hope it helps

+1