Try
objConn.Open()
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
If objConn.State = ConnectionState.Open Then
Try
objDataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey
objDataAdapter.Fill(objDS, "Customers"
objConn.Close()
Dim objTable As DataTable
objTable = objDS.Tables("Customers"
Dim drRows As DataRowCollection
Dim objCurrentRow As DataRow
drRows = objTable.Rows
DisplayTable2(objTable)
MessageBox.Show("about to update, press return to start!"
Dim drRow As Data.DataRow
'drRow = objTable.NewRow
drRow = drRows.Find("Hiang"
drRow.BeginEdit()
drRow("CompanyName" = "I Love Hiang"
drRow.EndEdit()