SQL Insert Command

[tehon3299]

Hey -

 

I was just wondering how I would use the SQL Insert Command on an ASPX page. I know it's: INSERT INTO tableName VALUES ______. How do I use the value from a textbox on the page as the insert value?

 

Thanks

[Robby]

Using an SqlCommand and the .ExecuteNonQuery() method, then ...

 

"INSERT INTO tableName (field1) VALUES ('" & textBox1.text & "')"

[tehon3299]

OK...Thanks for the help. Now, where do I use the ExecuteNonQuery() Command? Where does that have to go?

 

Thanks

[Robby]

You can call the function from a button click...

   Protected Friend Function SetTableValue(ByVal sSql As String) As Integer
'pass the INSERT INTO statement as the argument (as sSql)
       Dim cmd As SqlCommand
       Dim con As New SqlConnection("Your connection String")
       Dim recordsAffected As Integer
       Try
           If con.State = ConnectionState.Closed Then con.Open()
           cmd = New SqlCommand(sSql, con)
           recordsAffected = cmd.ExecuteNonQuery()
       Catch 
           recordsAffected = -1
       Finally
           If con.State = ConnectionState.Open Then con.Close()
           If Not cmd Is Nothing Then cmd.Dispose()
       End Try
       Return recordsAffected
   End Function

[tehon3299]

Here's my code. I have it in a button click. Can you see what is wrong? It inserts a blank field in SQL but NOT a NULL. I allow NULLS for the field but I just get a blank field.

[Robby]

Can you Zip a text file instead, thanks.

[tehon3299]

Here ya go:

trans.zip