I would like to fire some queries that will do either an INSERT or an UPDATE in an Access 2003 DB (not password protected). I am using some code that I found on the net (CreateOleDbCommand). I runs without any errors, but noting is changed in the DB. Here is that part of the code I wrote:
...
'SQL is constructed based on what the user selected
Call CreateOleDbCommand(sSQL, EmailSending.My.Settings.dbEmailConnectionString)
'I found this sub on the net
Private Sub CreateOleDbCommand(ByVal queryString As String, ByVal connectionString As String)
Using connection As New OleDb.OleDbConnection(connectionString)
connection.Open()
Dim command As New OleDb.OleDbCommand(queryString, connection)
command.CommandType = CommandType.Text
command.ExecuteNonQuery()
End Using
end Sub
Is anyone has a clue?
thanks!
Mal'chik![[bigglasses] [bigglasses] [bigglasses]](/data/assets/smilies/bigglasses.gif)
...
'SQL is constructed based on what the user selected
Call CreateOleDbCommand(sSQL, EmailSending.My.Settings.dbEmailConnectionString)
'I found this sub on the net
Private Sub CreateOleDbCommand(ByVal queryString As String, ByVal connectionString As String)
Using connection As New OleDb.OleDbConnection(connectionString)
connection.Open()
Dim command As New OleDb.OleDbCommand(queryString, connection)
command.CommandType = CommandType.Text
command.ExecuteNonQuery()
End Using
end Sub
Is anyone has a clue?
thanks!
Mal'chik
![[bigglasses] [bigglasses] [bigglasses]](/data/assets/smilies/bigglasses.gif)