.net – New record in Bindingsource

I come up with this solution

First added a GetNextID() method directly to the table model:

SELECT     autoinc_next
FROM         information_schema.columns
WHERE     (table_name = 'Estagio') AND (column_name = 'ID')

and whener I need a new row to be added I do

 EstagioTableAdapter ta = new EstagioTableAdapter ();
 nextID = ta.GetNextID();

 row = (DataRowView)source.AddNew();
 row.Row["ID"] = nextID;
 (...)
 source.EndEdit();

Found the answer to the problem... (helps getting some sleep after working several 13 hours days in a row)

Had I read the documentation a little better I would have known to change the "vbNull" in my data binding line...

Me.Total_Amount.DataBindings.Add("Text", frmBindingSource, "Total", True, DataSourceUpdateMode.Never, vbNull, "c")

To just be vbNullString...

Me.Total_Amount.DataBindings.Add("Text", frmBindingSource, "Total", True, DataSourceUpdateMode.Never, vbNullString, "c")

so it will default to "blank" (i.e. vbNullString) when a DBNull is detected, no need to change my SQL query which works.