error when Update an OleDbDataAdapter

[Guest]

Getting following error when I Update an OleDbDataAdapter: “Argument 'Prompt' cannot be converted to type 'Stringâ€.
I used the Wizard to generate the DataConenction and DataAdapter

Code is:
OleDbDataAdapter1.Fill(ds, "PatientSummaryTBL")


Dim tbl As DataTable = ds.Tables("PatientSummaryTBL")
Dim row As DataRow = tbl.Rows(0)

row("AgeCategory") = "Infant"

Try
OleDbDataAdapter1.Update(ds, "PatientSummaryTBL")
Catch e As Exception
MsgBox(e)
End Try

Much Appreciate

 

[One Handed Man \( OHM#\)]

Try


Adapter.Update( DataSetName.Tables("TableName")

Regards - OHM

Getting following error when I Update an OleDbDataAdapter: "Argument

'Prompt' cannot be converted to type 'String".

 

[Guest]

Thanks for the sugestion.
Unfortunately it did not work.

 

[One Handed Man \( OHM - Terry Burns \)]

I can only assume that the AgeCategory field is not a string and that is
what is causing the error.

HTH - OHM ( Terry Burns )