I’m sure this must have been covered here, and I’m sure it’s on the net, but having spent days searching my hair is much thinner and greyer than it was before! I have an old VB6 program I wrote which is a front end to an Access Database – I need to update this to .net . I’ve managed most of it but adding new records and keeping updates to records seems to elude me – I’m sure I’ve followed the process but it seems to not want to work. I can see that changes are made when I run the program. Then I stop the program and run it again and the changes aren’t there. Probably my advanced age, but any help would be much appreciated!
I’m using this as code for testing
rowNewRowL = Bookings_DatabaseDataSet.MAGIC94.NewRow
rowNewRowL.Item(“Date”) = “07 March 2017”
rowNewRowL.Item(“Start time”) = Format(Now(), “hh:mm”)
rowNewRowL.Item(“End time”) = Format(Now(), “hh:mm”)
rowNewRowL.Item(“Approx Nos”) = 10
rowNewRowL.Item(“Booker”) = “test”
rowNewRowL.Item(“Fee”) = 100
Bookings_DatabaseDataSet.MAGIC94.Rows.Add(rowNewRowL)
