ADD + DELETE error

[makaveli19]

hi i tried to add and delete a record but i always get an error in my Dataadapter it's something like error in system....dll.
here is the code i typed
if anyone could help thanks in advance

the sqlcommand is
sqlcommand.commandtext="Select * from Hardware"

intteller = 0
        If intteller <> -1 Then
 
 
            Dim nieuweRij As DataRow
            Dim mijntabel As New DataTable
            mijntabel = beheerdersDataset.Tables(0)
 
            nieuweRij = beheerdersDataset.Tables(0).NewRow()
 
            nieuweRij.Item("Nr") = txtnr.Text
            nieuweRij.Item("Voornaam") = txtvoornaam.Text
            nieuweRij.Item("Achternaam") = txtachternaam.Text
            nieuweRij.Item("E-mail") = txtemail.Text
            nieuweRij.Item("GSM") = txtgsm.Text
 
            beheerdersDataset.Tables(0).Rows.Add(nieuweRij)
            '   ' here is get my error in the next line
            mijnAdapter.Update(beheerdersDataset)
 
            MsgBox("New Record added to the Database")
 
        End If
 
'delete
  
        hardwareDataset.Tables(0).Rows(intteller).Delete()
        aantalrec = aantalrec - 1
 
        intteller = 0
        Navigatierecords()
       ' here is get my error in the next line
        mijnAdapter.Update(hardwareDataset)

[gigemboy]

Where are your update commands? If you did not specify any, then you need to set a commandbuilder to autogenerate the insert/update/delete commands when you call Update on your dataadapter... you can do it with a simple line of code...

'put this line of code (modifying it for your object names) after you create your adapter
Dim MyCmdBuilder As New System.Data.OleDb.OleDbCommandBuilder(MyAdapter)

Of course, if you arent using an oledb dataadapter, be sure to change it to the type of adapter you are using...

[makaveli19]

should i write mycmdbuilder.update(mydataset)

[gigemboy]

no you just call your update just like you were doing before... unless you already tried that (which I think you have done)... so if theres still an error, we need the exact error message... put a try/catch block around the update command, and display the error message...

[makaveli19]

i tried it your way but i get the error

http://www.homeandlearn.co.uk/NET/im...ctionError.jpg

this is the error i get

[gigemboy]

have you put try/catch blocks to try to catch the exact error message? Look below for how to do it. Are you using an oledbdataadapter? or a different data adapter? If you are using a SQL data adapter, you have to change it to "System.Data.SqlClient.SqlCommandBuilder"

Try
    'some code you wish to catch exceptions on...
Catch ex as System.Exception
    Msgbox ex.message
End Try