Development Notebook

Reading your Outlook Inbox from C# using OleDbDataAdapter

  private void ListInbox()
  {
   string  Mailbox    = "Inbox";
   string  Provider   = "Microsoft.Jet.OLEDB.4.0;Outlook 9.0";
   string  MAPILEVEL   = "Mailbox - Lastname, Firstname";
   string  PROFILE    = "Lastname, Firstname";
   string  TABLETYPE   = "0";
   string  DATABASE   = @"c:\temp";
   DataSet  ds     = new DataSet();
   DataTable dt     = new DataTable();

   string  sql     = string.Format(@"SELECT * FROM {0}", Mailbox);
   string  ConnectionString = string.Format(
    @"Provider={0};MAPILEVEL={1}|;PROFILE={2};TABLETYPE={3};DATABASE={4}",
    Provider, MAPILEVEL, PROFILE, TABLETYPE, DATABASE);
   try
   {
    OleDbDataAdapter da  = new OleDbDataAdapter( sql, ConnectionString );
    da.Fill(ds,"Outlook");
    dt      = ds.Tables["Outlook"];
    dataGrid1.DataSource = dt;
   }
   catch (Exception ex)
   {
    MessageBox.Show("Error: "+ex.Message);
   }
  }

# posted by John : 10:55 AM