asp.net - ExecuteNonQuery returns -1 even though the execution was successful -
I'm running an ASP.NET 2.0 web application. Suddenly, this morning, the beginning of execution began to return -1 even though the commands in the SP are running, running (I put the item in DB and updated it), and did not throw any exceptions.
This is when I am associated with my production db. When I am associated with our development db, they return the exact number of rows affected.
In addition, interestingly enough, there is no problem with ExecuteDataSet - this pretty backs the dataset
so it does not seem like a connection problem Again, what else can this be?
You can also see if this is the line
SET NOCOUNT ON This will always cause ExecuteNonQuery-1 to execute.
Comments
Post a Comment