Get count value from a select query : OleDbCommand « Database ADO.net « C# / C Sharp

1. C# / C Sharp
2. Database ADO.net
3. OleDbCommand

Get count value from a select query

using System;
using System.Data;
using System.Data.OleDb;

public class DatabaseInfo {    
 public static void Main () { 
   String connect = "Provider=Microsoft.JET.OLEDB.4.0;data source=.\\Employee.mdb";
   OleDbConnection con = new OleDbConnection(connect);
   con.Open();  
   Console.WriteLine("Made the connection to the database");

   OleDbCommand command = con.CreateCommand();
   command.CommandText = "SELECT COUNT(*) FROM Employee";
   Console.WriteLine("Number of Employee rows: {0}",(int)command.ExecuteScalar());
   con.Close();
 }
}
 
           
       

Related examples in the same category

1.	Execute aggregate function: sum
2.	Get column average
3.	Get max column value
4.	Between certain dates
5.	Delete database records through OleDbCommand and verify the results
6.	Create table and populate data
7.	Pass parameter to OleDbCommand
8.	How to execute a TableDirect command