<div>
Take a look at the GetRows method of the ADO recordset object.
</div>


Take a look at the GetRows method of the ADO recordset object.

<div>
you might consider creating a udt rather than a two dimensional array, e.g.<br />
<br />
Private Type coords<br />
&nbsp; &nbsp;x As Variant<br />
&nbsp; &nbsp;y As Variant<br />
End Type
</div>


you might consider creating a udt rather than a two dimensional array, e.g.

Private Type coords
   x As Variant
   y As Variant
End Type

<div>
emoreau--<br />
GetRows works -- I was looking for something from DataGrid but as long as I can get the data into the arrays, I'm OK.<br />
<br />
BOB <br />
<br />
<br />
<br />
AzraSound--<br />
Is there any advantage to using a udt as you suggested when using the data in an XY plot using MSChart Control. How would I use it?<br />
<br />
BOB
</div>


emoreau--
GetRows works -- I was looking for something from DataGrid but as long as I can get the data into the arrays, I'm OK.

BOB



AzraSound--
Is there any advantage to using a udt as you suggested when using the data in an XY plot using MSChart Control. How would I use it?

BOB

<div>
no not really other than the fact you dont have to work with two dimensional arrays. &nbsp;If that isnt a bother to you then there really is no need to go with the udt's.
</div>


no not really other than the fact you dont have to work with two dimensional arrays.  If that isnt a bother to you then there really is no need to go with the udt's.

<div>
<div class="content wysiwyg-content">
I use an ACCESS database recordset to store columns of numbers that I would like to plot on an x-y chart in a VB program. I can pull the data easily into my VB program using DataGrid and display it on the screen.<br />
What I'd like to do with the data is select two columns and put that data into a two dimensional array so I can plot the data on an x-y chart. It seems like there should be an easy way to do this but I'm getting nowhere. Any solutions??<br />
BOB<br />

</div>
</div>


I use an ACCESS database recordset to store columns of numbers that I would like to plot on an x-y chart in a VB program. I can pull the data easily into my VB program using DataGrid and display it on the screen.
What I'd like to do with the data is select two columns and put that data into a two dimensional array so I can plot the data on an x-y chart. It seems like there should be an easy way to do this but I'm getting nowhere. Any solutions??
BOB


DataGrid data to an array

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.