How to add a record (where tableadapter is setup in designer)

Hi guys,

I used the designer to create dataset and datatableadapter for my InventoryIn and InventoryInDetails.

Now, I'm stacked to adding a record on the InventoryIn table.

I did not use the typical drag and dropping of InventoryInTableAdapter, but instead textboxes, datetimepicker is unbound.

So I have a button for new and saving.

I can't make the adding of record to work.. please help, what should be my code?

here's my code in the new button

this.inventoryInBindingSource.AddNew();

How about in my save button?

Is it?

this.inventoryInBindingSource.EndEdit();

this.inventoryInTableAdapter.Insert(int.Parse(this.supplierIDTxtBox.Text), this.supplierInvoiceTextBox.Text, this.supplierDateSuppliedDateTimePicker.Value, this.supplierReferenceNumberTextBox.Text, this.supplierNotesTextBox.Text);

I have this fields on my InventoryIn Table

supplierID, supplierInvoice, dateSupplied, referenceNumber, and notes

Thanks guys.

[1417 byte] By [BeastForever] at [2007-12-24]