Ciao a tutti, vengo subito al sodo.
E' possibile eseguire queste query ?


Dim myConnection As OleDbConnection
Dim SqlSelect As oleDbcommand
Dim strSelect As string
Dim SqlSelect2 As oleDbcommand
Dim strSelect2 As string
Dim puntatore As oleDbDataReader

myConnection = New OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../mdb-database/db.mdb"))

strSelect = "INSERT INTO mapoint (id, x, y) VALUES ('" & request.QueryString("id_immobile") & "','" & e.x & "','" & e.y & "') "

strSelect2 = "INSERT INTO immobili (pos) VALUES (" & True & ") WHERE id='" & request.QueryString("id_immobile")

myConnection.open()

SqlSelect2 = New oleDbcommand (strSelect2 , myConnection)
SqlSelect2.ExecuteNonQuery()

SqlSelect = New oleDbcommand (strSelect , myConnection)
SqlSelect.ExecuteNonQuery()


Se volessi eseguire un query di insert multipla, come devo procedere ?


Grazie.