Calcul in datagridview c#

Question

HI SC TEAM

I'M BEGINNER IN C#

I HAVE THIS GIRDE I WANT THIS :

if C1 = 0 :

C2 AND C3 VALEUR OF EACH ROW MUST BE IN C5 AND IF C2 IS NULL C3 MUST HAVE A VALUE AND IF C3 IS NULL C2 MUST HAVE VALUE

IF C1 = 1

C2 AND C3 VALEUR OF EACH ROW MUST BE IN C4 AND IF C2 IS NULL C3 MUST HAVE A VALUE AND IF C3 IS NULL C2 MUST HAVE VALUE

Amit Gupta · 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;

Amit Gupta · Answer

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

dzconception · Answer

nice ... solved thank you

dzconception · Answer

ho to use formula in c# with datagridview ? i have this video : https://www.youtube.com/watch?v=Z0YCFjNxbXM