Updating msacces database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ZyON
    New Member
    • May 2009
    • 1

    #1

    Updating msacces database

    I wrote this code in asp.net(vb):
    Code:
    dim dbconn as New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & server.mappath("../kri1.mdb"))
    Dim DBCmd As New OleDbCommand
    Dim DBAdap As New OleDbDataAdapter
    DBCmd = New oledbCommand("INSERT INTO tabela (@id, @nesto, @ime)", DBConn)
    DBCmd.Parameters.Add("@ID", OleDbType.smallint).value= 6
    DBCmd.Parameters.Add("@nesto", OleDbType.varchar ).Value = "2"
    DBCmd.Parameters.Add("@ime", OleDbType.varchar ).Value = "3"
    DBCmd.Connection.Open()
    DBCmd.ExecuteNonQuery()
    and nothing happened in my database and there's no compilation error, pls help
    thx anyway
    Last edited by PRR; May 15 '09, 09:19 AM. Reason: Added [code] [/code] tags... Please post code in [code] [/code] tags.
  • Frinavale
    Recognized Expert Expert
    • Oct 2006
    • 9749

    #2
    Your SQL statement is incorrect.
    You should have an insert statement like:

    Code:
    Dim sqlStatement As String = _
    "INSERT INTO tabela (id, nesto, ime) " _
    "VALUES (@id, @nesto, @ime)"

    Comment

    Working...