Having Difficulty Inserting Into The Database Table

I created a web form where the user fills in some data and when he submits the form, I do an insert into he database table. The problem is, how can I get the data from the form into the insert statement?. here is the code:


Dim Message As String


Dim connStr As String


Dim myConnection As SqlConnection


Dim mySqlCommand As SqlCommand


connStr = "server=SIMIVSdotNET;Trusted_Connection=yes;database=AeroSea"


myConnection = New SqlConnection(connStr)


mySqlCommand = New SqlCommand("INSERT INTO TravelRequestEntry (CustomerID,Name) Values (1,name.text)", myConnection)





If I execute the above code, then nothing gets updated. When I change the insert staement into the following,


mySqlCommand = New SqlCommand("INSERT INTO TravelRequestEntry (CustomerID,Name) Values (1,'myname')", myConnection) then,


value 1 for customerID field and myname in the namefield is added.


I know I am doing something stupid, but can't figure it out.


I am confused. please help me.