Passing values into SQL Server

  • Thread starter Thread starter colleen1980
  • Start date Start date
C

colleen1980

Hi: I create two textboxes and a button and try to pass values from the
textboxes into SQL Server by using Save Button Can any one please tell
me do i write some code on save button or i bind the textbox with the
SQL Server fields as i bind the fields in VB.NET

Thanks,
 
Few controls have automagic binding in a web app. Try something like this:

Dim textbox1Value as TextBox1.Text
Dim textbox2Value as TextBox2.Text

Dim sql as String = "INSERT INTO SomeTable VALUES (@Val1, @Val2)"
Dim conn As New SqlConnection("Your Connection string Here")
Dim cmd as New SqlCommand(sql, conn)

Dim param1 As new SqlParameter("@Val1", SqlDbType.VarChar, 50)
Dim param2 As new SqlParameter("@Val2", SqlDbType.VarChar, 50)

cmd.Parameters.Add(param1)
cmd.Parameters.Add(param2)

Try
conn.Open()
cmd.ExecuteNonQuery()
Catch ex As Exception
'Not sure how you want to handle exceptions
Finally
conn.Dispose()
End Try

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

********************************************
Think outside the box!
********************************************
 
Back
Top