fejl ved tilføjelse til db
Hey! Når jeg køre nedenstående kode, får jeg denne fejl: "Object must implement lConvertible" hvorfor...?strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Documents and Settings\Ejer\Dokumenter\Cafe\økonomi\db1.mdb"
objConnection = New OleDbConnection(strConnection)
objConnection.Open()
objCommand = New OleDbCommand
objCommand.Connection = objConnection
For i = 1 To 10
objCommand.CommandText = "INSERT INTO salg(produkt) VALUES (@id)"
objCommand.Parameters.Add("@id", OleDbType.VarNumeric).Value = LBLId(i)
objCommand.ExecuteNonQuery()
Next
objConnection.Close()
