Get affected rows on ExecuteNonQuery

by

ExecuteNonQuery – returns the number of rows affected.

SqlCommand comm;
// other codes
int numberOfRecords = comm.ExecuteNonQuery();

More Related Contents:

  1. Error: You have an error in your SQL syntax – but SQL statement works
  2. How do parameterized queries help against SQL injection?
  3. What is the syntax for an inner join in LINQ to SQL?
  4. LINQ to Entities does not recognize the method ‘System.String ToString()’ method, and this method cannot be translated into a store expression
  5. Read SQL Table into C# DataTable
  6. Is it possible to use a MySql User Defined Variable in a .NET MySqlCommand?
  7. ASP.NET use SqlConnection connect MySQL
  8. LINQ to SQL multiple tables left outer join
  9. Convert DateTime for MySQL using C#
  10. Code to validate SQL Scripts
  11. Does using parameterized SqlCommand make my program immune to SQL injection?
  12. Executing query with parameters
  13. C# Version Of SQL LIKE
  14. Use linq to generate direct update without select
  15. SqlConnection.Close() inside using statement
  16. Retrieve an object from entityframework without ONE field
  17. Join and Include in Entity Framework
  18. MySql Last Insert ID, Connector .net
  19. Why is a SQL float different from a C# float
  20. Sql Bulk Copy/Insert in C#
  21. Index (zero based) must be greater than or equal to zero
  22. Check if a SQL table exists
  23. Issues Doing a String Comparison in LINQ
  24. Passing datatable to a stored procedure
  25. How to pass a table as parameter to MySqlCommand?
  26. Use SQL Server time datatype in C#.NET application?
  27. Could not load file or assembly ‘MySql.Data, Version=6.2.2.0
  28. Generating sql code programmatically
  29. Do we have transactions in MS-Access?
  30. Is SqlConnection.Close() need inside a Using statement?

Leave a Comment