using System; using System.Data; using System.Data.OleDb; public class ExtractInfo { 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 Sales database"); OleDbCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT * FROM Employee"; OleDbDataReader reader = cmd.ExecuteReader(); Console.WriteLine(); Console.WriteLine("ID FirstName LastName Salary"); while (reader.Read()) Console.WriteLine("{0} {1} {2} {3}",reader.GetInt32(0),reader.GetString(1),reader.GetString(2), reader.GetDecimal(3)); reader.Close(); con.Close(); } }