Csharp/C Sharp/Database ADO.net/Row Count
use ExecuteScalar() to run a SELECT statement that returns a single value
<source lang="csharp"> using System; using System.Data; using System.Data.SqlClient; class ExecuteScalar {
public static void Main() { SqlConnection mySqlConnection = new SqlConnection("server=localhost;database=Northwind;uid=sa;pwd=sa"); SqlCommand mySqlCommand = mySqlConnection.CreateCommand(); mySqlCommand.rumandText = "SELECT COUNT(*) FROM Products"; mySqlConnection.Open(); int returnValue = (int)mySqlCommand.ExecuteScalar(); Console.WriteLine("mySqlCommand.ExecuteScalar() = " + returnValue); mySqlConnection.Close(); }
}
</source>