Capturing count from an SQL query

by

Use SqlCommand.ExecuteScalar() and cast it to an int:

cmd.CommandText = "SELECT COUNT(*) FROM table_name";
Int32 count = (Int32) cmd.ExecuteScalar();

More Related Contents:

  1. SQL Server Char/VarChar DateTime Error [closed]
  2. Delete from two tables? [closed]
  3. How to get last inserted id?
  4. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  5. Insert entire DataTable into database at once instead of row by row?
  6. Getting return value from stored procedure in C#
  7. SQL error: Incorrect syntax near the keyword ‘User’
  8. What represents a double in sql server?
  9. Passing List to SQL Stored Procedure
  10. SQL WHERE clause matching values with trailing spaces
  11. Query extremely slow in code but fast in SSMS
  12. How to retrieve data from a SQL Server database in C#?
  13. SqlBulkCopy from a List
  14. Any way to SQLBulkCopy “insert or update if exists”?
  15. SQLException : String or binary data would be truncated
  16. Multi threading C# application with SQL Server database calls
  17. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  18. SqlConnection.Close() inside using statement
  19. Can I use ADFS 2.0 to authenticate certain users against SQL Server?
  20. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  21. The variable name ‘@’ has already been declared. Variable names must be unique within a query batch or stored procedure
  22. Add WHERE clauses to SQL dynamically / programmatically
  23. How to pass string array in SQL parameter to IN clause in SQL
  24. How to pass a null variable to a SQL Stored Procedure from C#.net code
  25. How to insert data into SQL Server
  26. Query validation using C#
  27. Use SQL Server time datatype in C#.NET application?
  28. Database Error: There is no row at position 0
  29. Generating sql code programmatically
  30. How to give ADO.NET Parameters

Leave a Comment