how do i update multiple rows? right now i can only update one row.
it works like this now:
user keys in customerIdNo and pwd1. a match in database will display pwd1 in textbox. textbox is databind to password field in access database. user can change the displayed pwd1 to pwd2 or to other pwd. when update button is pressed it updates the password field and changes pwd1 to what the user has changed.
BUT only a row is updated. i've a few rows where the password field values are pwd1. i want all pwd1 to be changed to the pwd that the user has changed to.
i use dataadapter and dataset. in dataadapter i wrote select* from table1 where customerIdNo=? and password=?