VB.NET : DataTable.Select() not getting correct result when assigned a BindingSource.Datasource

See more:

VB

DataTable

Binding

Hi Everyone ..

I have a form with 3 datagridview. Each of these grids has separate bindingsource as datasource and this bindingsource has been assigned datatable as datasource on Form_Load:

bsDimensions.DataSource = dtDimension
dgvDimension.DataSource = bsDimensions.DataSource

bsEntityValue.DataSource = dtEntity
dgvEntityValue.DataSource = bsEntityValue

bsCurrency.DataSource = dtCurrencies
dgvCurrency.DataSource = bsCurrency

When user clicks on a row of dgvDimension it filters bindingSource of other 2 grids:

bsEntityValue.Filter = "DimensionCode = '" & dgvDimension.Rows(e.RowIndex).Cells(ColDimensionCode.Index).Value & "'"
If dgvEntityValue.CurrentRow IsNot Nothing Then
    bsCurrency.Filter = "CurrencyDimensionCode = '" & dgvDimension.Rows(e.RowIndex).Cells(ColDimensionCode.Index).Value.ToString.Trim & "' And CurrencyEntityValue = '" & dgvEntityValue.CurrentRow.Cells(ColEntityValue.Index).Value.ToString.Trim & "'"
End If

Please note that every grid has a checkbox column (RowSelected) to select required rows. Afterwards when user clicks Save button then following steps perform:

dgvDimension.Update()
dgvEntityValue.Update()
dgvCurrency.Update()
dgvDimension.CommitEdit(DataGridViewDataErrorContexts.Commit)
dgvEntityValue.CommitEdit(DataGridViewDataErrorContexts.Commit)
dgvCurrency.CommitEdit(DataGridViewDataErrorContexts.Commit)
dgvDimension.EndEdit()
dgvEntityValue.EndEdit()
dgvCurrency.EndEdit()
dgvDimension.Refresh()
dgvEntityValue.Refresh()
dgvCurrency.Refresh()

Dim dtEntities As Data.DataTable = bsEntityValue.DataSource
Dim dtCurrencies As Data.DataTable = bsCurrency.DataSource

Dim ResultEntities As Data.DataRow()
Dim ResultCurrency As Data.DataRow()

ResultEntities = dtEntities.Select("RowSelected=1")

Now here is the issue:
if user clicks just one row in "dgvDimension" and makes some changes in "dgvEntityValue" and clicks save, then this "dtEntities.Select" only filters rows which are related to this particular row of "dgvDimension". Same way if user clicks lets say 3 rows in "dgvDimension" and makes some changes, then this "dtEntities.Select" filters rows related to these 3 rows.

Please advice as what could be the issue? why isn't it filtering all checked rows in dtEntities. Please note that dtEntities contains all rows of all dimensions so it should select all rows which are checked.

Thanks and Regards

Zee Shan