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"); String cmd = "SELECT * FROM Employee"; OleDbDataAdapter adapter = new OleDbDataAdapter(); adapter.SelectCommand = new OleDbCommand(cmd, con); DataSet ds = new DataSet(); adapter.Fill(ds, "Employee"); DataTable item = ds.Tables[0]; Console.WriteLine("Table name: {0}", item.TableName); Console.WriteLine("Its columns are:"); foreach (DataColumn col in item.Columns) Console.WriteLine("{0} {1}", col.ColumnName, col.DataType); con.Close(); } }