using System.Data;                      // State variables
    using System.Data.ADO;                  // Database
    using System.Globalization;             // Date

//Attributes
    public const string DB_CONN_STRING = 
        "Driver={Microsoft Access Driver (*.mdb)}; "+
        "DBQ=D:\\CS\\TestDbReadWrite\\SimpleTest.mdb";

ADOConnection conn = new ADOConnection(DB_CONN_STRING);
conn.Open();

ADODataReader dr;
ADOCommand cmd = new ADOCommand( "SELECT * FROM Person", conn );
cmd.Execute( out dr);

while( dr.Read() )
{
System.Console.WriteLine( dr["FirstName"] );
}

try
    {
        .... the database operations ...
    }
    catch( Exception ex )
    {
        System.Console.WriteLine( "READING:" );
        System.Console.WriteLine( "  ERROR:" + ex.Message );
        System.Console.WriteLine( "  SQL  :" + sSqlCmd );
        System.Console.WriteLine( "  Conn.:" + DB_CONN_STRING );
    }
    finally
    {
        // Close the connection
        if( conn.State == DBObjectState.Open )
            conn.Close();

}

int nOrdinalAge = dr.GetOrdinal( "Age" );
    int nAge = dr.GetInt32( nOrdinalAge );
    DateTime tUpdated = (DateTime)dr["Updated"];

int nOrdinalAge = dr.GetOrdinal( "Age" );
    if( dr.IsNull( nOrdinalAge ) )
    {
        System.Console.WriteLine( " Age  : Not given!" );
    }
    else
    {
        int nAge = dr.GetInt32( nOrdinalAge );
        System.Console.WriteLine( " Age  : " + nAge );

// SQL command
    String sSQLCommand = "INSERT INTO Person (Age, FirstName, 
    Description, Updated)  " +
                         "VALUES( 55, 'Bob', 'Is a Penguin',
			 '2001/12/25 20:30:15' );";
    // Create the command object
    ADOCommand cmdAdder = new ADOCommand(
        sSQLCommand,
        DB_CONN_STRING);
    cmdAdder.ActiveConnection.Open();
    // Execute the SQL command
    int nNoAdded = cmdAdder.ExecuteNonQuery();
    System.Console.WriteLine( "\nRow(s) Added = " + nNoAdded + "\n" );

String sSQLCommand = "UPDATE Person SET Age = 27 WHERE FirstName = 'Peter'";

String sSQLCommand = "DELETE FROM Person WHERE FirstName = 'Bobo'";