Events Capturing in Untyped Dataset

[Guest]

Hi,
Hope somebody can help me with this.

I have a Dataset and BindingManagerBase declared :-
********************************************
Private dsData As DataSet
Private bmData As BindingManagerBase
********************************************

The dsData is fill by an oledbadapter upon the form load:-
******************************************
strSQL = "SELECT * FROM tblWarehouse"
dbAdapter.SelectCommand = New OleDbCommand(strSQL ,cn)
dsData = New DataSet
dbAdapter.Fill(dsData, "tblWarehouse")
******************************************

Subsequently, I have my form's controls bound to the dataset:-
*******************************************************
txtWhseID.DataBindings.Add("Text", dsData, "tblWarehouse.strWarehouseID")
cboWhseType.DataBindings.Add("Text", dsData, "tblWarehouse.strType")
bmData = Me.BindingContext(dsData, "tblWarehouse")
*******************************************************

Currently, I can navigate the dataset by manipulate the bmData:-
************************************************
bmData.Position = 0 '(Go to First Record)
bmData.Position -= 1 '(Go to Previous Record)
************************************************

Now, I would like to add in the record indicator into my Form:- Record 3 of 10

The easiest way, is to capture the event when the dataset move from one
record to another or when a record in the dataset is deleted or added.
Example :
Private Sub dsData_Move()
' Calculate the current record position and update result to form display
end sub


Anyone help ?

 

[olrt]

Please see the following article :

http://msdn.microsoft.com/library/d...ndingmanagerbaseclasspositionchangedtopic.asp

It demonstrates how one can interception the BindingManagerBase's
PositionChanged
event.