ExecuteNonQuery doesn’t return results

by

What kind of query do you perform? Using ExecuteNonQuery is intended for UPDATE, INSERT and DELETE queries. As per the documentation:

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.

More Related Contents:

  1. What is the razor in asp .net mvc [closed]
  2. Run async method regularly with specified interval
  3. How do I create a custom membership provider for ASP.NET MVC 2?
  4. Format of the initialization string does not conform to specification starting at index 0
  5. ASP.NET Core: Exclude or include files on publish
  6. How to call a VBScript file in a C# application?
  7. Convert System.Drawing.Color to RGB and Hex Value
  8. How to export a JQgrid data to Excel using c#?
  9. Absolute path back to web-relative path
  10. Should I store my images in the database or folders? [duplicate]
  11. Accessing Office Word object model through asp.net results in “failed due to the following error: 80070005 Access is denied.”
  12. Render HTML as an Image
  13. Can I turn off impersonation just in a couple instances
  14. How to implement “Access-Control-Allow-Origin” header in asp.net
  15. How can I export a GridView.DataSource to a datatable or dataset?
  16. how to convert NameValueCollection to JSON string?
  17. What is the best way to determine a session variable is null or empty in C#?
  18. What SqlDbType maps to varBinary(max)?
  19. ASP.NET Is there a better way to find controls that are within other controls?
  20. How to make the .net HttpClient use http 2.0?
  21. ASP.NET 5 add WCF service reference
  22. Check if Cookie Exists
  23. unable to evaluate expression whilst debugging
  24. Getting the IP address of server in ASP.NET?
  25. When `PostAuthenticateRequest` gets execute?
  26. Could not load file or assembly ‘Microsoft.ReportViewer.Common, Version=11.0.0.0
  27. Google Weather API 403 Error [duplicate]
  28. ASP.NET Core Web API Authentication
  29. What is the difference between ResolveUrl and ResolveClientUrl?
  30. Name does not exist in the current context

Leave a Comment