Home All Groups Group Topic Archive Search About

database records into an array

Author
10 Jan 2006 8:35 PM
rodchar
hey all,

what's the best way to get database records into an array?

thanks,
rodchar

Author
11 Jan 2006 2:43 AM
pvdg42
"rodchar" <rodc***@discussions.microsoft.com> wrote in message
news:A0C26684-2A95-4493-812C-9932D845AB69@microsoft.com...
> hey all,
>
> what's the best way to get database records into an array?
>
> thanks,
> rodchar

When you say "database records" are you referring to rows in a DataTable as
retrieved using a SQL query? Typically, such rows consist of multiple fields
with disparate data types. Arrays, by default, store multiple instances of a
single data type. Are you trying to create an array of DataRow objects?
If you could be a bit more specific about what you intend to store in your
array, I'm sure better answers will appear.

--
Peter [MVP Visual Developer]
Jack of all trades, master of none.
Author
13 Jan 2006 9:18 PM
rodchar
please disregard this. i'm confusing myself.

Show quoteHide quote
"pvdg42" wrote:

>
> "rodchar" <rodc***@discussions.microsoft.com> wrote in message
> news:A0C26684-2A95-4493-812C-9932D845AB69@microsoft.com...
> > hey all,
> >
> > what's the best way to get database records into an array?
> >
> > thanks,
> > rodchar
>
> When you say "database records" are you referring to rows in a DataTable as
> retrieved using a SQL query? Typically, such rows consist of multiple fields
> with disparate data types. Arrays, by default, store multiple instances of a
> single data type. Are you trying to create an array of DataRow objects?
> If you could be a bit more specific about what you intend to store in your
> array, I'm sure better answers will appear.
>
> --
> Peter [MVP Visual Developer]
> Jack of all trades, master of none.
>
>
>