Other fields not interested in
What I want to do is say I have the following data
I want to update it to (filtered update to do only right(lineitemID,2) = 01
I could do this in my sleep with DAO and Access, but I don't know where to start with ADO.Net, tried for a few hours without any luck with datatables and stuff. I know I could just loop with a while datareader,read with update commands in side, but was looking for the "right" way to do it.
Also, id like to try lock the table while doing it to stop other users trying to update at the same time.