How can a I use SQL INSERT statement using a variable from an InputBox in the VALUES of the SQL INSERT. I am using the following code but is not working. Thank you.

Code:
Dim ctlPedidoNo As Integer = InputBox("Please enter a Connection String", "CONNECTION STRING")

        cmd.CommandText = "INSERT INTO SeguimientoPedidos(PedidoNo) VALUES ('ctlPedidoNo')"