Datatable add new row

See more:

VB

DataTable

DataRow

Hi
I have a form with one label and few textboxes. These controls have data bindings with DataTable "myTable".
After "Add New" button click, the all controls with data are empty. I need to preserve the value of the label. Is that possible ?

Here are more details:

SelectCommand:

SELECT t1.FieldX, t2.FieldA, t2.FieldB
FROM table1 t1
JOIN table2 t2 on t2.FieldY = t1.FieldX

Data binding:

LABEL.DataBindings.Add("Text", myTable, "FieldX")
TEXTBOX1.DataBindings.Add("Text", myTable, "FieldA")
TEXTBOX2.DataBindings.Add("Text", myTable, "FieldB")

Part of code at "Add New" button click event :

// insert data to database table table2 
...
BindingContext(myTable).EndCurrentEdit()
BindingContext(myTable).AddNew()
// after that all values are empty
// need to preserve label value
...