VB Migration Partner

KNOWLEDGE BASE - Database and data-binding


Previous | Index | Next 

[PRB] Changing properties of the data source associated with a DataGrid control can throw an exception

The migrated VB.NET application can throw a COMException error whose Message property reads “Rowset not available” if you change a property of an object – for example a Data control or an ADO Recordset – that is currently assigned to the DataSource property of a DataGrid control, as in this code:

        Set dataGrid1.DataSource = adodc1
        ' ...
        ' (later in the application)
        adodc1.RecordSource = "Select * From Customers"
        adodc1.Refresh     ' this statement throws in VB.NET

The simplest workaround for this issue is detaching the data source object from the DataGrid and re-attaching it after setting the object’s properties:

        Set dataGrid1.DataSource = adodc1
        ' ...
        ' (later in the application)
        Set dataGrid1.DataSource = Nothing          ' detach the data source
        adodc1.RecordSource = "Select * From Customers"
        adodc1.Refresh     ' this statement throws in VB.NET
        Set dataGrid1.DataSource = adodc1           ' re-attach the data source
Previous | Index | Next 




Follow Francesco Balena on VB6 migration’s group on

LinkedIn





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.

newsletter



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