Ruslan,<br><br>Thanks for the valuable input which is appreciated. No, I didn't find among the examples what I'm asking about. <br><br>However, as usual ODBC comes to rescure but I still want to use .NET features to do it. The below code shows what I like to achieve:<br>
<br> Dim con As String = "Driver={Valentina ODBC Driver};IsDatabaseLocal=yes;Database=FirstDB.vdb"<br> Dim sql As String = "SELECT * FROM Person"<br> Dim connection As New OdbcConnection(con)<br>
Dim dataadapter As New OdbcDataAdapter(sql, connection)<br> Dim ds As New DataSet()<br> dataadapter.Fill(ds, "Person_Table")<br><br> 'Populate the DataGridView with data.<br> Me.dgwVDB.DataSource = ds<br>
Me.dgwVDB.DataMember = "Person_Table"<br><br>How can I do it with Valentina's .NET Features?<br><br>Thanks in advance,<br>Dennis<br><br><div class="gmail_quote">2011/1/8 Ruslan Zasukhin <span dir="ltr"><<a href="mailto:ruslan_zasukhin@valentina-db.com">ruslan_zasukhin@valentina-db.com</a>></span><br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">On 1/7/11 4:32 AM, "Dennis Wallentin" <<a href="mailto:xldennis@gmail.com">xldennis@gmail.com</a>> wrote:<br>
<br>
Hi Dennis,<br>
<div><div></div><div class="h5"><br>
> As I'm still on the learning stage I have the following test code to retrieve<br>
> data from a VDB:<br>
><br>
> Dim ivcCursor As IVCursor<br>
> ivcCursor = mDataBase.SqlSelect(inQuery:="SELECT * FROM Person", _<br>
> <br>
> inCursorLocation:=EVCursorLocation.kClientSide, _<br>
> inLockType:=EVLockType.kReadOnly, _<br>
> <br>
> inDirection:=EVCursorDirection.kForwardOnly)<br>
><br>
><br>
> In what way should I use the IVCursor to populate a DataGridView control with<br>
> the retrieved data?I did notice that I can iterate but that's not the route I<br>
> want to take as I want to do it faster.<br>
<br>
</div></div>If you going to use this cursor with Data Grid, then I think better make not<br>
ForwardOnly, but Random. Bevause you may want scroll forward and back.<br>
<br>
<br>
About populate ... Not sure what you ask about.<br>
Have you check our examples? VNET/VB ?<br>
<br>
Yes you must GO TO Nth record<br>
Then read values from fields.<br>
<br>
This is fast enough, than more for client side cursor<br>
<br>
<br>
--<br>
Best regards,<br>
<br>
Ruslan Zasukhin<br>
VP Engineering and New Technology<br>
Paradigma Software, Inc<br>
<br>
Valentina - Joining Worlds of Information<br>
<a href="http://www.paradigmasoft.com" target="_blank">http://www.paradigmasoft.com</a><br>
<br>
[I feel the need: the need for speed]<br>
<br>
<br>
_______________________________________________<br>
Valentina mailing list<br>
<a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>With kind regards,<br>Dennis W<br>-------------------------------------------------<br>XL-Dennis about .NET & MS Excel<br><a href="http://xldennis.wordpress.com/">http://xldennis.wordpress.com/</a><br>
<br>XL-Dennis Consulting<br><a href="http://www.excelkb.com/index.htm">http://www.excelkb.com/index.htm</a><br>