converting query result into an array

[henr...@gmail.com]

I have a query result of 1 column and 20 rows of integers. How Can I
store this result in an array.?
or is there any other method I can use that would allow me to retreive
any single item in the query result anytime in my code
(am working with sql database , asp.net and C#)

[Raghuraman_ace]

Hi

just populate the datatable with the query results u want .Then use

datarow a[] ;
a=datatable.select("dummy
condition",sortcol,datarowviewstate.currentrows).The outcome of this
method will be the datarow array .

Hope this helps.

A drop in the oecean of sixfaces.
Raghuraman Tricomp technilogies, India