[RESOLVED] dataset/tableadapter update and @Parameters

Hi,

Access database + VB Express 2005

1) I do not get any errors, however table in database is not updated.
I did test and if in UPDATE statement is set to
"UPDATE RaceHeader SET RaceHTML='test value' WHERE RaceID=@RaceID"
it works perfectly and update is done :-)
But if I want to assign @RaceHTML (which is a web page source code) then update is not working...despite this parameter has a correct value( look at point 2)

2) Parameters fot UPDATE query are ok, MSGBOX confrms this at the end.

Code:

---


RaceHTML = WebBrowser1.Document.Body.InnerHtml
            RaceHTML = Replace(RaceHTML, Chr(13) & Chr(10), "END_OF_LINE")

                      cmd4RaceHeader = New OleDb.OleDbCommand( _
                  "UPDATE RaceHeader SET RaceHTML=@RaceHTML WHERE RaceID=@RaceID", conn)
            cmd4RaceHeader.Parameters.AddWithValue("@RaceID", RaceID)
            cmd4RaceHeader.Parameters.AddWithValue("@RaceHTML", RaceHTML)


          cmd4RaceHeader.ExecuteNonQuery()
         

            MsgBox(cmd4RaceHeader.Parameters("@RaceHTML").Value, MsgBoxStyle.OkCancel)

---

Please, help it's second day and I have eyes red from reading not from working....

Peter

When using the OleDBCommand, parameters must be added to the collection in the same order as they appear in the query.

cmd4RaceHeader.Parameters.AddWithValue("@RaceHTML", RaceHTML)
cmd4RaceHeader.Parameters.AddWithValue("@RaceID", RaceID)

Thanks a million :-) Sorted