How to stored Session Variable in a separate variable

Question

Can anyone perhaps tell me why is my session value returning a -1 when saving to the database based on this btn Click event.

       using (SqlConnection con = new SqlConnection(CS))
    {
        SqlCommand cmdManID = new SqlCommand("SELECT 
        managerID,userEmailAddress,userName FROM [MANAGER] ,[USER] WHERE 
        [MANAGER].managerID = [USER].userID AND [USER].userName= @Uname;",con);
        cmdManID.Parameters.Add(new SqlParameter("@Uname", 
        Session["UName"]));

        con.Open();
    }

        int manID = cmdManID.ExecuteNonQuery();

        //manID;



        con.Close();

marc_s · Accepted Answer · 2018-12-02 20:53:53Z

2

Because -1 is exactly the result you should expect on a SELECT from ExecuteNonQuery:

"For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. When a trigger exists on a table being inserted or updated, the return value includes the number of rows affected by both the insert or update operation and the number of rows affected by the trigger or triggers. For all other types of statements, the return value is -1. If a rollback occurs, the return value is also -1."

https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlcommand.executenonquery?view=netframework-4.7.2

If you only expect a single return value, that is what ExecuteScalar is for: https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlcommand.executescalar?view=netframework-4.7.2

edited Dec 2, 2018 at 20:53

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Oct 15, 2018 at 22:17

Christopher

9,8442 gold badges19 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

paulsm4 Over a year ago

Doh! Good catch ;)

Tevin Over a year ago

@Christopher thank you so much I used the ExecuteScaler and it works perfectly.

Collectives™ on Stack Overflow

How to stored Session Variable in a separate variable

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related