[RESOLVED] dataset/tableadapter update and @Parameters

[Zolw]

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.

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