class1.cs

《c#技术内幕代码》

namespace CH7_17
{
    using System;
	using System.Data.ADO;

    /// <summary>
    ///    Summary description for Class1.
    /// </summary>
    public class Class1
    {
		private ADOConnection fConnection;
		private const string fConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=CH7_17.MDB";

        public Class1()
        {
			fConnection = new ADOConnection(fConnString);
			fConnection.Open();
        }
		public void CloseDown()
		{
			fConnection.Close();
		}
		public void AddEntry()
		{
			try
			{
				string cmd = "INSERT INTO CONTACTS (Name, Address, City, State, ZipCode, Age) ";
				cmd += " VALUES ('Herman Munster', '1313 Mockingbird Lane', 'Golden', 'CO', '80401', 39);";
				ADOCommand adocmd = new ADOCommand( cmd, fConnection );
				int nAdded = adocmd.ExecuteNonQuery();
				Console.WriteLine("# Added: {0}", nAdded );

			}
			catch ( Exception e )
			{
				Console.WriteLine("Exception in Add: {0}", e );
			}
		}
		public void ListEntries()
		{
			Console.WriteLine("Listing...\n");
			try
			{
				ADODataReader rdr;
				ADOCommand cmd = new ADOCommand("Select * from Contacts", fConnection );
				cmd.Execute( out rdr );

				while( rdr.Read() )
				{
					Console.WriteLine( "\nName: {0}", rdr["Name"] );
					Console.WriteLine("Address: {0}", rdr["Address"] );
				}
				rdr.Close();
			}
			catch ( Exception e )
			{
				Console.WriteLine("Exception in List: {0}", e );
			}
		}

        public static int Main(string[] args)
        {
			Class1 app = new Class1();
			app.AddEntry();
			app.ListEntries();
			app.CloseDown();
            return 0;
        }
    }
}