Hey there,
(using a windows applicaiton) What I have is a database with engineers on it in a table tited 'Engineer', what I want to do is be able to add a new engineer to the database. Via text boxes and a submit button instead of a data grid.

I have the data connections n such and have fiddled around a bit and tried this code.

VB Code:
  1. Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
  2.  
  3. Dim Name As String
  4.  
  5. Dim qual As String
  6.  
  7. Dim mob As String
  8.  
  9. Dim phone As String
  10.  
  11. Dim NOK As String
  12.  
  13. Dim specId As String
  14.  
  15. Dim newEngineer As DataRow
  16.  
  17. Name = txtName.Text
  18.  
  19. qual = txtQual.Text
  20.  
  21. mob = txtMobile.Text
  22.  
  23. phone = txtPhone.Text
  24.  
  25. NOK = txtNOK.Text
  26.  
  27. specId = txtSpecID.Text
  28.  
  29. newEngineer = Update1.Engineer.NewRow
  30.  
  31. newEngineer("Eng-name") = Name
  32.  
  33. newEngineer("Eng-Qual") = qual
  34.  
  35. newEngineer("Eng-Mobile") = mob
  36.  
  37. newEngineer("Eng-Phone") = phone
  38.  
  39. newEngineer("ENG-NOK") = NOK
  40.  
  41. newEngineer("Spec-ID") = CInt(specId)
  42.  
  43. Update1.Engineer.Rows.Add(newEngineer)
  44.  
  45. OleDbDataAdapter1.Update(Update1)


but to no prevail, anyone know what im doing wrong? If you need more information please ask