Populate DataTable column from another DataTable Column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My DataGrid is bound to a datatable named “dtClient†with following columns
Date, BalanceCF, Income, Expenses, Withdrawls and BalanceCF. BalanceCF is an expression column. The column Withdrawals does not hold any values initial.

I want to populate Withdrawal column using values from another datatable named “dt Withdrawal†which contains Date and Amount columns. How can I match the dates in “dtWithdrawals†with dates in “dtClient†and populate corresponding values.

Thanx
 
Dear Lot,
Create a DataView. Use Filter option and do your manipulations in DataView
Finally Bind it to the DataGrid.
 
Back
Top