VB Migration Partner

KNOWLEDGE BASE - Database and data-binding

Previous | Index | Next 

[PRB] Disappearing records in client-side ADODB.Recordset with batch optimistic lock

Consider the following VB6 code:

        Dim rs As New ADODB.Recordset()
        rs.Fields.Append("field1", ADODB.DataTypeEnum.adVarChar, 2, _
        rs.Fields.Append("field2", ADODB.DataTypeEnum.adVarChar, 2, _
        rs.Open(, , ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockBatchOptimistic)
        rs.AddNew(Array6("field1", "field2"), Array6("a1", "b1"))
        rs.AddNew(Array6("field1", "field2"), Array6("a2", "b2"))
        rs.AddNew(Array6("field1", "field2"), Array6("a3", "b3"))
        DataGrid1.DataSource = rs

After the migration to VB.NET the above code runs fine, except that whenever you click on a row in the DataGrid control, a record is deleted.

The workaround is quite simple, though: you just need to confirm the insertion of the new rows by means of an UpdateBatch method, before the recordset is assigned to the DataGrid.DataSource property. The easiest way to do so is by means of an InsertStatement pragma:

        '## InsertStatement rs.UpdateBatch()
        DataGrid1.DataSource = rs
Previous | Index | Next 

Follow Francesco Balena on VB6 migration’s group on


Read Microsoft Corp’s official case study of a VB6 conversion using VB Migration Partner.

Code Architects and its partners offers remote and onsite migration services.

More details

Subscribe to our free newsletter for useful VB6 migration tips and techniques.


To learn more about your VB6 applications, run VB6 Analyzer on your source code and send us the generated text file. You will receive a detailed report about your VB6 applications and how VB Migration Partner can help you to quickly and effectively migrate it to .NET.

Get free advice

A fully-working, time-limited Trial Edition of VB Migration Partner allows you to test it against your actual code

Get the Trial

The price of VB Migration Partner depends on the size of the VB6 application, the type of license, and other factors

Request a quote

Migrating a VB6 application in 10 easy steps

Comparing VB Migration Partner with Upgrade Wizard

Migration tools: Feature Comparison Table

All whitepapers