updating multiple rows in a dataset

[SimDuck]

Hi, I have am having a problem updating multiple rows of a dataset.

 

I am using Visula Basic.net; OleDB connection to an Access database.

 

The table has four columns: Code, Priv_lvl, Prim_Key(autoincrement primary key), Account

 

I run a search to fill at dataset & it retrieves two or more rows from the table.

 

I modify the datarows with the needed data

I set the parameters and commands

I then run the update command.

 

What happens is that all of the rows get updated with the last rows data.

 

I am wondering if I have to allocate the correct data to the parameters or not? If I have to, how do I create an array of the same named parameter?

 

The code would be difficult to post here as I have it spread accross two modules.

 

Can some one give me some advice or point me to a tutorial or complete sample of how to update multiple rows.

 

Thank you