Database "Ran out of Book"

[Rally]

I’m currently using VB.Net for beginners book and at the time this is all I have or else I would not be posting such a stupid Question.
My problem is this! I have made up a Front end for a simple Database that uses text Boxes to display the Data. I have added buttons to my form that let me step thru my database to view the contents. All that works just fine, but the Book stops there.
Now I have added 2 more buttons, a button New and a button Save.
Can I use that same Form to Add to my Recordset ?
And would someone please be so kind to point me in the rite direction, or at least explain to me what I need to do next?
Thanks!

[Lunatic3]

Are you using databinding? If so then New button will do something like this:

cm.AddNew()

Where cm is the CurrencyManager, the manager of databinding in your form. AddNew causes all the textboxes to be cleared and ready for a new data. Remember that if you are binding comboboxes or radiobuttons then you must have a default value set for the fileds they are bound to in the dataset, or it will not work.

After entering your data you may need to ignore the changes and return back, so you have to use RejectChanges method of the Dataset Table you are working with.

To save the data you must call EndCurrentEdit method of currencymanager and after verification of data use Update method of the dataadapter.

If you are not binding then you can add a new row to the dataset, clear textboxes and wait for the user to enter the data and click the save button. On saving you verify the data and enter into the new row of the dataset, after that you can update the database.

[Rally]

Yes I’m using data binding in Text Boxes, but I still don’t understand (sorry)
I’m starting out with

Dim cm As CurrencyManager
cm.AddNew

now do I need to declare all members of the Table??? and if so how?
Thanks a million!

[Lunatic3]

The currency manager should be the manager of databinding you are using, so just declaring it is not enough. If I were you, i declared cm publicly so it can be accessible through the procedures. Then after that, somewhere like in the form load event you have to set the cm. Something like this:

cm = CType(Me.BindingContext(your_dataset_here, "bounded_tablename_here"), CurrencyManager)

After using cm.AddNew, you dont have to 'declare all members of the Table'. Each bound element of form is now ready for input of a new record.