I think it is not submitting the changes to the database. When you switch account selection you re-run all the SQL queries for population and so therefore the dataset would revert to its old data if the database was not updated.
Can you update a row and then check in the database whether it changes before you move off the row. See if what I expect it to be is right.
Hmm if you add a debug point to line 22, and then look at cashOrdersDS.Tables["cashOrders"].Rows in watch and navigate to the data in list form (takes a bit of exploring, generally found in non public members, see if the changes make it into the dataset.
Hmm.. I could be reading this wrong but it looks like it collects info and squirts it into cashOrders table but with only 3 Rows??? the only grid I have with 3 rows in the listview above which holds the Account Name,Ref,Town?
I've attached a Screenshot for you to have a look at.
Hmm there are definately pros to starting again in the fact it will remove all the coding niggles ive corrected if they were missed, ie a stray table or something.
and I dont mind helping with new issues.
Cons I suppose would just be the time invested and how long it would take to re-write.
The reason is most likely a simple one but they are always absolute f##kers to track down, I've spent a good half a day tracking down an error before which was caused by a comma in the wrong place -.-'
Ok, Lets shelve that problem for a moment and come back to it..
The other issue I have is the fact that when I'm clicking through the differnt account and viewing order lines. Then I decide I wish to create a new 'Customers' I click 'New Cash Account' Fill out the details and then click 'Save'.