Passing parameters to Command object.. 1

[Frank123]

Hi everyone, I can't seem to find any examples of how to pass parameters to a command object. This is what I have so far :

cmDatabase.CommandText = "INSERT INTO Utilities(System_Site_ID, Utility_ID, Utilities) VALUES (var1, var2, 'Erase')"

I want to pass the variables var1, and var2 into this command but it doesn't seem to work. Somehow I need to set the parameters but can't find an example anywhere on it. Thanks for your help.

 

[JuanitaC]

You probably just need to concatenate your string:

"INSERT INTO Utilities(System_Site_ID, Utility_ID, Utilities) VALUES (" & var1 & ", " & var2 & ", 'Erase')"

 

[Frank123]

Thanks JuanitaC, that did the trick.