this code is work (can update my database)
VB Code:
  1. Dim dt = DataSet11.Tables("Customer")
  2.         dt.Rows(myMgr.Position)("CustomerPersonalID") = [COLOR=Red]1234567890[/COLOR]
  3.  
  4.         OleDbDataAdapter1.Update(DataSet11, "Customer")
  5.         DataSet11.AcceptChanges()

but this code can't update my database
VB Code:
  1. Dim dt = DataSet11.Tables("Customer")
  2.         dt.Rows(myMgr.Position)("CustomerPersonalID") = [COLOR=Red]txtCustomerPersonalID.Text[/COLOR]
  3.  
  4.         OleDbDataAdapter1.Update(DataSet11, "Customer")
  5.         DataSet11.AcceptChanges()

was i do wrong ?
thanks!