FIX: RowColChange Event of DataGrid Does Not Fire with ADODC

View products that this article applies to.

This article was previously published under Q195840

SYMPTOMS

As the user uses the ADODC MoveNext button to scroll down the visible records in the DataGrid, the RowColChange event of the DataBound Grid fires without any problem. But as soon as the record pointer needs to move to a row that is not fully visible, the RowColChange event does not fire. In summary, the RowColChange event for the DataBound Grid do not fire unless the row is completely visible in the DataBound Grid at the instant before the ADODC MoveNext button is clicked.

Back to the top

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

This bug was corrected in Visual Studio 6.0 Service Pack 3. For more information about Visual Studio service packs, please see the following articles in the Microsoft Knowledge Base:

194022 INFO: Visual Studio 6.0 Service Packs, What, Where, Why (http://support.microsoft.com/kb/194022/EN-US/ )

194295 HOWTO: Tell That Visual Studio 6.0 Service Packs Are Installed (http://support.microsoft.com/kb/194295/EN-US/ )

Back to the top

MORE INFORMATION

Steps to Reproduce Behavior

Create a Standard EXE project in Visual Basic. Form1 is created by default.
Go to Project/Components and choose the Microsoft ADO DataControl 6.0 (OLEDB), and the Microsoft DataGrid Control 6.0 OLEDB.
Add a DataGrid and an ADODC to the form.
Go to the ADODC properties and click on the ConnectString property and then on the ellipse.
Choose DSN that points to pubs in the ODBC DSN Name category and then click Apply.
Click on the Authentication tab and then put in any password needed.
Click on the Authentication tab and chose adcmdtable. Choose authors and click apply.
Click on the DataGrid and choose the ADODC1 on the DataSource Property.
Go to the RowColChange Event of the DataGrid and paste this code:
Debug.Print "RowColChange Event Fired"
Run the application.
Start clicking on the ADODC1 MoveNext button and watch the RowColChange Event fire by looking at the Immediate Window. Note that the event won't fire once you get to a row that wasn't visible right before you clicked the MoveNext button.

Back to the top