Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

Please help, I got the code below from a book but it doesnt seem to work:

 try 
   oledbDataAdapter1.update("GH")
   Catch ex as exception
      msbox(ex.tostring)
   end try

I'm using ms access 2003, here is my connection string:

       Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data     Source=F:\ACCESS DATABASE\search.mdb")
    Dim cmd As OleDbCommand = New OleDbCommand("Select * from GH where IDNUMBER= '" & TextBox1.Text & "' ", cn)
share|improve this question

1 Answer

up vote 0 down vote accepted

First, I am not sure what you are trying to update. The update method requires a dataset or datatable. Here is a link to the MSDN website with more information about the update method - oledbdataadapter.update method.

Here is an example of what I believe you are trying to do.

dim oledbDataAdapter1 as new oledbDataAdapter("Select * from GH where IDNUMBER= '" & TextBox1.Text & "' ","Provider=Microsoft.Jet.OLEDB.4.0;Data     Source=F:\ACCESS DATABASE\search.mdb")

dim modifieddataset as dataset
oledbDataAdapter1.fill(modifieddataset)

'Make changes to dataset
...

try
     oledbDataAdapter1.update(modifieddataset)  
catch ex as exception
     msbox(ex.tostring)
end try

Finally, you should avoid allowing user input to be put directly into you SQL string. It allows SQL Injection. Here is an article that will better explain the issue - SQL Injection. HTH

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.