Need help with a databound form and Dataset: Urgent!!
Posted on 2006-03-28
This has become frustrating and I know It has to be so easy.
I have Dataset loaded from a single table on an access back end. I'm using a form with 6 text boxes Name, address, etc. all are databound to fields in the dataset.
I used a commandbuilder object and want to update the database. All the examples I've found speak of using a dataset w/ a datagrid. Even the VS help uses a datagrid as the example.
I just want to Insert, Update and Delete data on what is a completely databound form, but i'm having noting but problems.
to delete the currently displayed record i do the following:
iResult = MsgBox("Deleting this Customer will remove all related Addresses and Parts!" & vbCrLf & "Are You Sure?", MsgBoxStyle.YesNo Or MsgBoxStyle.Exclamation, "Delete Customer")
If iResult = MsgBoxResult.Yes Then
this lets me delete the currently displayed record - then nothing else will delete.
what am i doing wrong?
How do you append a new record?
One of the big supposed advantages of the dataset was that i could hold off on the Updates(wether inserts, updates, and/or deletes) until they closed the form or something like that. but i can;t get past how to use this control.
Please,Please,Please...No examples referencing a datagrid :P
500 points because it's very urgent