C#

// Connection & DataAdapter initialization code should go here
// ...

OleDbCommand insertCommand = connection.CreateCommand();
insertCommand.CommandText = "Insert Into Table(Col1, Col2, Col3) Values (?, ?, ?)";
dataAdapter.InsertCommand = insertCommand;

// ...

// Opens the Application event log.
EventLog eventLog = new EventLog("Application");
// Iterate through the entries in the opened event log.
foreach (EventLogEntry entry in eventLog.Entries)
 Console.WriteLine(entry.Message);

// Declare this at the class member space
[DllImport("advapi32.dll")]
static extern IntPtr OpenEventLog(string lpUNCServerName, string lpSourceName);
[DllImport("advapi32.dll")]
static extern bool BackupEventLog(IntPtr hEventLog, string backupFile);

// Somewhere in your code, call the above two declarations...
// NOTE: Replace "localhost" with the machine name you need to back up.
//       Replace "Application" with the log you are trying to back up.
//       The saved file is an EVT file.
BackupEventLog(OpenEventLog("localhost", "Application"), @"C:\TEMP\EVENTLOG.EVT");

// Get all the property elements of the Color struct
PropertyInfo[] PropertyInfo = typeof(Color).GetProperties();

// Loop through the property info elements...
foreach (PropertyInfo propertyElement in PropertyInfo)
{
 // We're interested in color types...
 if (propertyElement.PropertyType == typeof(Color))
 {
  // propertyElement.Name will indicate the name of the colour, stick this into an array if needed...
  string colourName = propertyElement.Name;
  // Define a new Color type using the static FromName method to get the base colour value.
  Color c = Color.FromName(colourName );
 }
}