Use data in an IVCursor to populate DataGridView in VB,NET

[Ruslan Zasukhin]

On 1/7/11 4:32 AM, "Dennis Wallentin" <xldennis at gmail.com> wrote:

Hi Dennis, 
 
> As I'm still on the learning stage I have the following test code to retrieve
> data from a VDB:
> 
> Dim ivcCursor As IVCursor
>         ivcCursor = mDataBase.SqlSelect(inQuery:="SELECT * FROM Person", _
>                                      
> inCursorLocation:=EVCursorLocation.kClientSide, _
>                                       inLockType:=EVLockType.kReadOnly, _
>                                      
> inDirection:=EVCursorDirection.kForwardOnly)
> 
> 
> In what way should I use the IVCursor to populate a DataGridView control with
> the retrieved data?I did notice that I can iterate but that's not the route I
> want to take as I want to do it faster.

If you going to use this cursor with Data Grid, then I think better make not
ForwardOnly, but Random. Bevause you may want scroll forward and back.


About populate ... Not sure what you ask about.
Have you check our examples?  VNET/VB ?

Yes you must GO TO Nth record
Then read values from fields.

This is fast enough, than more for client side cursor


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]