Store database values in array

nady

Dear Techies,

I have a code which retrieves values from database

Expand|Select|Wrap|Line Numbers

 
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 ->

Expand|Select|Wrap|Line Numbers

 
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

Expand|Select|Wrap|Line Numbers

 
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

Expand|Select|Wrap|Line Numbers

 
for each rs as datarow in ds.tables(0).rows

 if conditions then

   rs("traffic_id")=1

end if

next

Store database values in array

re: Store database values in array

re: Store database values in array

re: Store database values in array

Similar Visual Basic .NET bytes

/bytes/development

/bytes/it

/bytes/about