ExecuteNonQuery for SELECT sql statement returning no rows

by

The ExecuteNonQuery Method returns the number of row(s) affected by either an INSERT, an UPDATE or a DELETE. This method is to be used to perform DML (data manipulation language) statements as stated previously.

The ExecuteReader Method will return the result set of a SELECT. This method is to be used when you’re querying for a bunch of results, such as rows from a table, view, whatever.

The ExecuteScalar Method will return a single value in the first row, first column from a SELECT statement. This method is to be used when you expect only one value from the query to be returned.

In short, that is normal that you have no results from a SELECT statement while using the ExecuteNonQuery method. Use ExecuteReader instead. Using the ExecuteReader method, will will get to know how many rows were returned through the instance of the SqlDataReader object returned.

int rows = 0;

if (reader.HasRows)
    while (reader.Read())
        rows++;

return rows; // Returns the number of rows read from the reader.

More Related Contents:

  1. C# Sql Textbox Select
  2. How to execute a stored procedure within C# program
  3. How to get the connection String from a database
  4. Must declare scalar variable @Id?
  5. Save byte[] into a SQL Server database from C#
  6. Getting return value from stored procedure in C#
  7. I get a “An attempt was made to load a program with an incorrect format” error on a SQL Server replication project
  8. SQL error: Incorrect syntax near the keyword ‘User’
  9. SqlDataSourceEnumerator.Instance.GetDataSources() does not locate local SQL server 2008 instance
  10. SQLException : String or binary data would be truncated
  11. SSIS Task for inconsistent column count import?
  12. Entity-framework code is slow when using Include() many times
  13. Creating a SQL Server table from a C# datatable
  14. SQL: Update a row and returning a column value with 1 query
  15. Is there an Entity Framework 7 Database-First POCO Generator?
  16. Invalid column name sql error
  17. Retrieve image from database in asp.net
  18. Entity Framework | Sequence contains more than one matching element
  19. When is it better to store flags as a bitmask rather than using an associative table?
  20. How to pass a null variable to a SQL Stored Procedure from C#.net code
  21. Keyword Not Supported: Metadata
  22. Why is EF generating SQL queries with unnecessary null-checks?
  23. Know when to retry or fail when calling SQL Server from C#?
  24. What’s the best way to bulk database inserts from c#?
  25. How to insert data into SQL Server
  26. SQL Server Database Change Listener C#
  27. How to get efficient Sql Server deadlock handling in C# with ADO?
  28. Cyrillic encoding in C#
  29. Generating sql code programmatically
  30. Accessing System Databases/Tables using LINQ to SQL?

Leave a Comment