Convert AdoRecordSet to DataTable

This forum is the place to discuss issues related to ReportPro, Xs2Ado, Vo2Ado, bBrowser and other 3rd party products
User avatar
Kees Bouw
Posts: 124
Joined: Wed Nov 06, 2019 11:35 am
Location: Netherlands

Re: Convert AdoRecordSet to DataTable

Post by Kees Bouw »

Robert,

That is very good news, an Xs2Ado update. I am working on a project where Xs2Ado is used a lot and while it may be better to use Ado.Net in X#, the priority at the moment is to transform the VO-forms to Winforms and add features. So Xs2Ado will not be abandoned for quite some time, if at all. If possible please update the documentation / help file as well. Lots of things are not explained and there are very few examples given. Something I encountered this afternoon for example is this. In the explanation for AdoServer:RecordSet it says "Please be careful when using this AdoRecordSet object. If you have to move the record pointer, move it back to where it was after you are finished, or else the Server object may get 'confused'." A small piece of code would help here because I don't know how to move back the record pointer in the RecordSet. There is no RecNo or Goto. Or should the record pointer be moved back in the AdoServer object? Does AdoRecordSet:GetRows() move the record pointer in the AdoRecordSet?

Kees.
robert wrote: Thu Dec 05, 2024 4:49 pm Kees,

Simply call GetRows() with 3 NIL variables should work

Code: Select all

oRs:GetRows(NIL,NIL,NIL) 
I am working on an update for Xs2Ado. I will make the parameters optional again.

Robert
User avatar
robert
Posts: 4558
Joined: Fri Aug 21, 2015 10:57 am
Location: Netherlands

Re: Convert AdoRecordSet to DataTable

Post by robert »

Kees,

There will be no real updates to the documentation, I am afraid.
Just like any other company, my company needs to justify spending time on this work.
There simply is no business case for spending a lot of time on this.
And since the major part of Vo2Ado and Xs2Ado is a thin layer on the ADO classes, which are documented extensively online by Microsoft and others, there is already plenty of information available.

For example:
to save and restore a position in a recordset, there is the Bookmark property.
https://learn.microsoft.com/en-us/sql/a ... rver-ver16

Robert
XSharp Development Team
The Netherlands
robert@xsharp.eu
User avatar
Kees Bouw
Posts: 124
Joined: Wed Nov 06, 2019 11:35 am
Location: Netherlands

Re: Convert AdoRecordSet to DataTable

Post by Kees Bouw »

robert wrote: Sun Dec 08, 2024 9:22 am Kees,

There will be no real updates to the documentation, I am afraid.
Just like any other company, my company needs to justify spending time on this work.
There simply is no business case for spending a lot of time on this.
And since the major part of Vo2Ado and Xs2Ado is a thin layer on the ADO classes, which are documented extensively online by Microsoft and others, there is already plenty of information available.

For example:
to save and restore a position in a recordset, there is the Bookmark property.
https://learn.microsoft.com/en-us/sql/a ... rver-ver16

Robert
Robert,

Maybe you can at least change the title in the helpfile (Xs2ADO.chm). It still is Vn2Ado, see the picture:

Image

Kees.
Post Reply