Answers for "how to use variables in sql vb.net"

how to declare variables in vb.net and store variable data in sql server

Using connection As New SqlConnection("Data Source=(local)SQLEXPRESS;Integrated Security=True;Initial Catalog=tempdb;")
            connection.Open()

            Dim command As New SqlCommand(
                "UPDATE tblSAMP SET fieldSAMP1 = @fieldSAMP1, @fieldSAMP2 = fieldSAMP2 WHERE fieldSAMP3 = @fieldSAMP3",
                connection)
            ' assign input parameters
            command.Parameters.AddWithValue("@fieldSAMP1", 999)
            command.Parameters.AddWithValue("@fieldSAMP3", 9090909)

            ' output parameter was @decSamp
            Dim fieldSAMP2Parameter = command.Parameters.Add(
                New SqlParameter("@fieldSAMP2", SqlDbType.Int) With {.Direction = ParameterDirection.Output})

            ' if the query modified one row at least
            If command.ExecuteNonQuery() > 0 Then
                ' get the output parameter(s)
                Dim decSamp As Integer = CInt(fieldSAMP2Parameter.Value)
            End If
        End Using