Im tring to move move through a DB and parse one of the columns and place the result into two columns. the data is last name "," First name. I need to put the name into two fields. Im not sure I'm doing this correctly. It seems there is a million ways to do update the DB. Every thing is working but I am having trouble saving the parse back to the database. I have a datagride bound to the dataset so that I can see if what I am doing is working. Here is my code.
Dim tbl As dsEmployee.T_EMPLOYEEDataTable
Dim row As dsEmployee.T_EMPLOYEERow
tbl = DsEmployee1.T_EMPLOYEE
For Each row In tbl
Dim myArray() As String = _
Split(row.Item(4), ",", 3, CompareMethod.Text)
row(2) = myArray.GetValue(0)
row(3) = myArray.GetValue(1)
am I not correct on thinking that the daEmployee.update(tbl) should update the database?