Microsoft KB Archive/310206

= How to retrieve messages by using CDOEX and ADO in Visual C# =

Article ID: 310206

Article Last Modified on 11/29/2007

-

APPLIES TO


 * Collaboration Data Objects for Exchange 2000
 * Microsoft Visual C# .NET 2002 Standard Edition
 * Microsoft Exchange Server 2000 Service Pack 1
 * Microsoft ActiveX Data Objects 2.5
 * Microsoft Visual C# 2005

-



This article was previously published under Q310206



Caution ADO and ADO MD have not been fully tested in a Microsoft .NET Framework environment. They may cause intermittent issues, especially in service-based applications or in multithreaded applications. The techniques that are discussed in this article should only be used as a temporary measure during migration to ADO.NET. You should only use these techniques after you have conducted complete testing to make sure that there are no compatibility issues. Any issues that are caused by using ADO or ADO MD in this manner are unsupported. For more information, see the following article in the Microsoft Knowledge Base:

840667 You receive unexpected errors when using ADO and ADO MD in a .NET Framework application





SUMMARY
This article describes how to use Microsoft Collaboration Data Objects (CDO) for Exchange 2000 Library (CdoEx) in Microsoft Visual C# to retrieve messages from a user's Inbox.

Create the sample to retrieve messages
 Start Microsoft Visual Studio .NET or Microsoft Visual Studio 2005. On the File menu, point to New, and then click Project. Click Visual C# Projects under Project Types, and then click Console Application under Templates. By default, Class1.cs is created.

Note In Visual Studio 2005, click Visual C# under Project Types. In Visual Studio .NET, Class1.cs is created by default. In Visual Studio 2005, Program.cs is created by default. Add a reference to the Microsoft CDO for Exchange 2000 Library and the Microsoft ActiveX Data Objects 2.5 Library. To do this, follow these steps:  On the Project menu, click Add Reference. Click the COM tab.</li> Click Microsoft CDO for Exchange 2000 Library, and then click Select.

Note In Visual Studio 2005, you do not have to click Select.</li> Click Microsoft ActiveX Data Objects 2.5 Library, and then click Select.

Note In Visual Studio 2005, you do not have to click Select.</li> Click OK. If you are prompted to generate wrappers for the libraries that you selected, click Yes.</li></ol> </li>  In the Code window, replace the default code with the following code: using System;

namespace Samples {   class Class1 {       static void Main(string[] args) {           try {           ADODB.Connection oCn = new ADODB.Connection; ADODB.Recordset oRs = new ADODB.Recordset;

ADODB.Fields oFields; ADODB.Field oField;

// TODO: string sFdUrl = &quot;http://ExchServer/Exchange/UserAlias/Inbox&quot;; oCn.Provider = &quot;exoledb.datasource&quot;; oCn.Open(sFdUrl, &quot;&quot;, &quot;&quot;, -1);

if(oCn.State == 1) {               Console.WriteLine(&quot;Good Connection&quot;); }           else {               Console.WriteLine(&quot;Bad Connection&quot;); }

string strSql; strSql = &quot;&quot;; strSql = &quot;select &quot;; strSql = strSql + &quot; \&quot;urn:schemas:mailheader:content-class\&quot;&quot;; strSql = strSql + &quot;, \&quot;DAV:href\&quot; &quot;; strSql = strSql + &quot;, \&quot;urn:schemas:mailheader:content-class\&quot; &quot;; strSql = strSql + &quot;, \&quot;DAV:displayname\&quot;&quot;; strSql = strSql + &quot; from scope ('shallow traversal of &quot; + &quot;\&quot;&quot;;           strSql = strSql + sFdUrl + &quot;\&quot;') &quot;; strSql = strSql + &quot; WHERE \&quot;DAV:ishidden\&quot; = false&quot;; strSql = strSql + &quot; AND \&quot;DAV:isfolder\&quot; = false&quot;;

oRs.Open(strSql, oCn,                ADODB.CursorTypeEnum.adOpenUnspecified,                 ADODB.LockTypeEnum.adLockOptimistic, 1);

// As an example, you only retrieve the first message. // You can use a while loop through each message.

// Get the first message. oRs.MoveFirst;

// Get Recordset fields. oFields = oRs.Fields; string sUrl; oField = oFields[&quot;DAV:href&quot;]; sUrl = oField.Value.ToString;

CDO.Message iMsg = new CDO.Message; iMsg.DataSource.Open(sUrl, oRs.ActiveConnection,                ADODB.ConnectModeEnum.adModeReadWrite,                ADODB.RecordCreateOptionsEnum.adFailIfNotExists,                ADODB.RecordOpenOptionsEnum.adOpenSource,                &quot;&quot;, &quot;&quot;);

Console.WriteLine(&quot;{0}&quot;, iMsg.Sender); Console.WriteLine(&quot;{0}&quot;, iMsg.Subject); Console.WriteLine(&quot;{0}&quot;, iMsg.TextBody);

// Get message fields. oFields = iMsg.Fields;

for(int i = 0; i < oFields.Count; i++) {               oField = oFields[i]; Console.WriteLine(&quot;{0} : {1}&quot;, oField.Name, oField.Value); }

oRs.Close; oCn.Close; oCn = null; oRs = null; oFields = null; oField = null; }           catch (Exception e)            { Console.WriteLine(&quot;{0} Exception caught.&quot;, e); }                  }    } } </li> Modify code for the TODO comments.</li> Press F5 to build and to run the application.</li></ol>

<div class="references_section">