Article ID: 310207 - Last Review: November 29, 2007 - Revision: 3.3

How to use ADO and the Exchange 2000 OLE DB provider to search for items in a folder by using Visual C#

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
This article was previously published under Q310207
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   (http://support.microsoft.com/kb/840667/ ) You receive unexpected errors when using ADO and ADO MD in a .NET Framework application
Expand all | Collapse all

SUMMARY

This article describes how to use ActiveX Data Objects (ADO) and the Microsoft Exchange 2000 Server OLE DB provider to search for items in a folder by using Microsoft Visual C# .NET or Microsoft Visual C# 2005.

MORE INFORMATION

  1. Start Microsoft Visual Studio .NET or Microsoft Visual Studio 2005.
  2. On the File menu, point to New, and then click Project.
  3. In the Visual C# Projects types list, click Console Application. By default, the Class1.cs file is created.

    Note In Microsoft Visual C# 2005, click Visual C#. By default, the Program.cs file is created.
  4. Add a reference to the Microsoft ActiveX Data Objects 2.5 Library. To do so, follow these steps:
    1. On the Project menu, click Add Reference.
    2. Click the COM tab, locate Microsoft ActiveX Data Objects 2.5 Library, and then click Select.

      Note Microsoft Visual C# 2005, you do not have to click Select.
    3. In the Add References dialog box, click OK.
    4. If you are prompted to generate wrappers for the libraries that you selected, click Yes.
  5. In the code window, replace the code with the following:
    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: Replace with your folder's URL.
			string sFdUrl = "http://ExchServer/Exchange/UserAlias/Inbox";
			
			oCn.Provider = "exoledb.datasource";
			oCn.Open(sFdUrl, "", "", -1);  

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


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


			oRs.Open(strSql, oCn,
				ADODB.CursorTypeEnum.adOpenStatic,
				ADODB.LockTypeEnum.adLockUnspecified, 1);


			if(oRs.State == 1)
			{
				Console.WriteLine("Recordset Opened");
			}
			else
			{
				Console.WriteLine("Recordset Failed Opened");
			}

			oRs.MoveFirst();
			while(!oRs.EOF)
			{
				oFields = oRs.Fields;
                                    oField = oFields["DAV:href"];
				Console.WriteLine(oField.Value);

				oField = oFields["DAV:displayname"];
				Console.WriteLine(oField.Value);

				oRs.MoveNext();  
				                             Console.WriteLine("--------------------------");

			}

			oRs.Close();
			oCn.Close();

			oCn = null;
			oRs = null;
			oFields = null;
			oField = null;
			}
			catch (Exception e)
			{
				Console.WriteLine("{0} Exception caught.", e);
			}			
		}
        }
}
  6. Search for the TODO text string in the code, and then modify the code for your environment.
  7. Press the F5 key to build and to run the program.
APPLIES TO
  • Microsoft ActiveX Data Objects 2.5
  • Microsoft Exchange Server 2000 Service Pack 1
  • Microsoft Visual C# .NET 2003 Standard Edition
  • Microsoft Visual C# .NET 2002 Standard Edition
  • Microsoft Visual C# 2005
Back to the top
Keywords: 
kbhowto kbmsg kbxml kbcode KB310207