ADO.NET

[biot]

hi
why this code fails:

Private Sub SaveData()
Dim SelectSTR As String = "Select * From Customers"
Dim Adapter As New OleDb.OleDbDataAdapter(SelectSTR, ConnSTR)
Dim dsCustomer As New DataSet()
Dim DT As DataTable = dsCustomer.Tables("Customer")
Dim ROW As DataRow
ROW("A_ID") = txtID.Text
DT.Rows.Add(ROW)
Adapter.Update(dsCustomer)
End Sub

[Craig Gemmill]

The only thing I can see is that you did not declare 'ConnStr' in:

Dim Adapter As New OleDb.OleDbDataAdapter(SelectSTR, ConnSTR)

Good Luck

[biot]

it was declared in a module using the "Public" statement