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(); } }