Need help changing a value in SQL when searching by a text field
<p>I'm writing a program in VB.net to determine the status of a user and using SQL as my db. I have a statement where </p>

<pre><code>    "SELECT COUNT(*) FROM Users WHERE NameOne = '" &amp; nameOneBox.Text &amp; "'" 
    &amp; "AND [LastName] = '" &amp; lastNameBox.Text &amp; "'"
</code></pre>

<p>finds what I'm looking for exactly but when I do something like this:</p>

<pre><code>    @NameOne nvarchar(50), @CurrentStatus bit
    AS
    BEGIN
        UPDATE Users
        SET
            CurrentStatus = @CurrentStatus
        WHERE
            NameOne = @NameOne
    END
</code></pre>

<p>the value CurrentStatus never changes in the database. </p>