roee oselka
Reputation: 21
My ExecuteNonQuery returns -1 even though 4 rows are affected
When I run the query against the database, I get (4 row(s) affected).
When I run it through C#, I get -1 as the return value.
This is my code:
cmd.CommandText = "SELECT name FROM stock";
int x = cmd.ExecuteNonQuery();
Why do I get -1?
Upvotes: 0
Views: 47
Answers (0)
Related Questions
- ExecuteNonQuery() always returning -1
- ExecuteNonQuery() Returns unexpected number of rows affected C#
- ExecuteNonQuery always returns -1 even when the SQL statement is correct
- SQL Server 2008: Executenonquery not returning number of rows affected
- C# & SQL Server : ExecuteNonQuery returning -1, when UPDATE works?
- ExecuteNonQuery returns -1 even though the execution was successful
- ExecuteNonQuery() returns -1
- Executenonquery have -1 when i execute a statement
- C# - SELECT Query number of rows affected is always -1
- c# ExecuteNonQuery always returns Zero