ExecuteNonQuery not working but the ExecuteReader is working

Question

First don't mark it as duplicate, because this

is not the solution i am looking, the syntax is correct, the connection also correct because the SqlDataReader is working, and i open the connection and called it in SqlCommand. Here is my code

            if (sql_con.State == ConnectionState.Closed)
            {
                sql_con.Open();
            }
            StringBuilder query = new StringBuilder();

            query.Append(String.Format("update tbl_userdata set stage=@stage where username=@name"));

            SqlCommand sql_command2 = new SqlCommand(query.ToString(), sql_con);
            sql_command2.Parameters.AddWithValue("@stage", stage);
            sql_command2.Parameters.AddWithValue("@name", lblName.Text.ToLower());
            sql_command2.ExecuteNonQuery();

And after debugging my query is update tbl_userdata set stage=@stage where username=@name

i don't know what's wrong here, i remove the where clause to see if thats the cause of the problem, but still error. I don't know what's wrong here

here is my connection

SqlConnection sql_con = new SqlConnection(Properties.Settings.Default.dbCon);

Sorry i forgot to put my error, the error is the stage is not updating, this is my table

tbl_userdata
+--------+-------+-------+
|Username|stage  | coins |
+--------+-------+-------+


Username = nvarchar(5), stage = smallint, coins = smallmoney

What is the error exactly? What are your column types and what is your parameter values? Is your update query works on your sql server? Did you debug your code? What is your query looks like when you add parameter values to your query? — Soner Gönül
– Soner Gönül, Commented Jan 9, 2015 at 9:42
Have you used SQL profiler? Does command really sent to server? — Andrey Korneyev
– Andrey Korneyev, Commented Jan 9, 2015 at 9:48
Instead of assuming some strange behaviour for ExecuteNonQuery (there isn't any) check your values and possible exceptions. The only difference between the two functions is that one returns the first available result value while the second does nothing after execution has finished. — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Jan 9, 2015 at 9:50
Another possibility is that a transaction is opened in another part of the code but never commited — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Jan 9, 2015 at 9:55
Try to run the sanme query in sql server to with the parameter you are giving to verify the update query. Secondly try to get the sp call from sql profiler to verify the query. I don't think execute non query is a problem. — alternatefaraz
– alternatefaraz, Commented Jan 9, 2015 at 12:14

user4583471 · Accepted Answer · 2015-02-20 04:07:35Z

1

You dont need to do as string builder and append in query just use string if values are good with where clause, my answer can be stupid but it is worth of try if you don't find any solution.

answered Feb 20, 2015 at 4:07

user4583471

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

Collectives™ on Stack Overflow

ExecuteNonQuery not working but the ExecuteReader is working

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related