Saving Data into Database

[alexandar]

Hi! How do I save data into my database? I keep having problem at the ExecuteNonQuery. The following is my codes:

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim cnSQL As SqlConnection
Dim cmSQL As SqlCommand
Dim strSQL As String
Dim intRowsAffected As Integer
Dim DateTemp As String


DateTemp = Me.txtStartTime.Text



cnSQL = New SqlConnection("Initial Catalog=matrixVB;" & _
"Data Source=x550_1;Integrated Security=SSPI;")

strSQL = "INSERT INTO OT ( OT_StartDate ) SELECT """ & DateTemp & """"

cmSQL = New SqlCommand(strSQL, cnSQL)
cnSQL.Open()

cmSQL.ExecuteNonQuery()

Is there anything with the codes? Thanks.

[jayson_13]

try cmSQL.Connection.open()
instead of cnSQL.Open()