hi
i use 3 datatable in my form named DT1 , DT2 and DT3 than each datatable has one column named "Value1" , "Value2" and "Value3"
i want to use values of columns from DT2 and DT3 to use in expression of DT1 columns.
please look at the examples :
i want a thing like this :
so if i can do this , in each row of dt2 or dt3 , if i change the value of the cells , then the value of the cells of dt1 that their column name is "Value1" will change.
i mean :
how can i do this?
i use 3 datatable in my form named DT1 , DT2 and DT3 than each datatable has one column named "Value1" , "Value2" and "Value3"
i want to use values of columns from DT2 and DT3 to use in expression of DT1 columns.
please look at the examples :
i want a thing like this :
VB.NET:
DT1.Columns("Value1").Expression=( DT2.Columns("Value2") + DT3.Columns("Value3"))
i mean :
VB.NET:
for example :
[FONT=Consolas][SIZE=2][FONT=Consolas][SIZE=2]dt2.Rows(0).Item("Value2")=125
[FONT=Consolas][SIZE=2]dt3.Rows(0).Item("Value3")=25
[/SIZE][/FONT]
then :
[FONT=Consolas][SIZE=2]dt1.Rows(0).Item("Value1")=150[/SIZE][/FONT]
[/SIZE][/FONT][/SIZE][/FONT]