hmm....ok...seems like your idea kind of works. When I update the row directly through the dataview, the datagrid that is bound to the dv is updated with the new information, but when I call the da.Update command it doesn't commit the changes to the database.
Here's my code:
Call...
Obviously I already have considering that I mentioned my dataset which is filled with a dataadapter and that I read in the press book about modifying datarows.....what eludes me is how to go about modifying a certain datarow with using the row index since that changes....
I have a membership app that read driver's license info and adds/updates members in the access database. I'm using a dataview to filter the dataset and figure out whether or not the person already exists in the database, but I'm unclear how to programatically update their info if they do exist...
in my first post I mentioned that the dataset is mysteriously cleared/empty when I call the updateDataset method from within the ClientListener module.
My problem is that I don't know why that dataset is empty since I fill it in the form_load event and I never clear it prior to the...
but thats the thing...I'm using a database that already contains 20000 members and if I put the line that cause the error in the form_load event right after I fill the database it returns a date/time = Max(LastUpdate).
It only causes the error when I use the very same statement in he...
oh and as far as not using an insert and a fresh select, I thought it would be less taxing on the database in a multi-user environment to just retrieve updated/added records rather than all 20000.
rofl....thanks for the response first of all!! Second, I started writing this application with no prior knowledge of programming except the hello world apps I wrote in QUICK BASIC in an "Intro to Computer Proramming" class. I know that's not ideal...it was something temporary that functioned...
Ok, I fill my dataset in the form_load event, and the datagrid loads up with the data fine. I can search it and update/add members.
When another machine on the network adds a member (haven't even tested an update yet) it sends a message to the machine in question telling it to update. The...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.