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