Store database values in array

[nady]

Dear Techies,

I have a code which retrieves values from database

cmdSelect = New OleDbCommand("select fields,finesFields from trafficReport where checked LIKE 1", conn)
        cmdSelectDr = cmdSelect.ExecuteReader

        While cmdSelectDr.Read
            MsgBox("Select " + cmdSelectDr(0) + cmdSelectDr(1) + " from fines")
            'strtest = cmdSelectDr(0)

            'Store all values in array here
        End While

i want to store all the values in a array for further processing.

Any help would be highly appreciated

thanks
Nadir

[iam_clint]

You could do something like this ->

dim ds as new dataset
dim dbadap as new sqldataadapter
cmdSelect = New OleDbCommand("select fields,finesFields from trafficReport where checked LIKE 1", conn)
dbadap.fill(ds, "trafficReport")

So your table is stored locally in a dataset and be used again else where... I don't see any reason to really store this data into an array?

[nady]

Hi,
thanks for the reply.
the reason why i need to store in array is i need for further processing.


Many thanks
Nadir Firfire

[iam_clint]

Well when you set it in a dataset all the values are still there just stored on the server rather than the sql db..

so after you fill the ds like i showed above later on you can do

for each rs as datarow in ds.tables(0).rows
   msgbox(rs("traffic_id"))
next

or something similiar along those lines. you can also update the dataset simply by

for each rs as datarow in ds.tables(0).rows
 if conditions then
   rs("traffic_id")=1
end if
next