This topic has not yet been rated - Rate this topic

OleDbEnumerator.GetElements Method

.NET Framework 4.5

Retrieves a DataTable that contains information about all visible OLE DB providers.

Namespace: System.Data.OleDb
Assembly: System.Data (in System.Data.dll)

public DataTable GetElements()

Return Value

Type: System.Data.DataTable
Returns a DataTable that contains information about the visible OLE DB providers.

Exceptions

Exception	Condition
InvalidCastException	The provider does not support ISourcesRowset.
OleDbException	Exception has occurred in the underlying provider.

Remarks

The table that is returned by this method contains the following columns, all of which contain strings:

Column Ordinal	Column	Description
0	SOURCES_NAME	The invariant name of the native OLEDB data source or enumerator.
1	SOURCES_PARSENAME	A human-readable name that can be converted to a moniker by using the native COM interface IParseDisplayName. Corresponds to the SOURCES_PARSENAME column returned by the native OLE DB sources rowset.
2	SOURCES_DESCRIPTION	Description of the native OLE DB data source. Corresponds to the SOURCES_DESCRIPTION column returned by the native OLE DB sources rowset.
3	SOURCES_TYPE	One of the following enumeration members: Binder (0), DataSource_MDP (1), DataSource_TDP (2), Enumerator (3). These correspond to the values returned in the SOURCES_TYPE column of the native OLE DB sources rowset.
4	SOURCES_ISPARENT	Applicable to enumerators only. If true, indicates that the entry applies to the same enumerator on which GetSourcesRowset was called, implying that it is also included in the sub-enumeration. Corresponds to the SOURCES_ISPARENT column of the native OLE DB sources rowset
5	SOURCES_CLSID	A human-readable name, that can be converted to a moniker using the native COM interface IParseDisplayName. Corresponds to the SOURCES_CLSID column returned by the native OLE DB sources rowset.

Examples

The following console application retrieves information about all the visible OLE DB providers and displays the information in the console window.

using System;
using System.Data;
using System.Data.OleDb;

class Program
{
 static void Main()
 {
   OleDbEnumerator enumerator = new OleDbEnumerator();
   DataTable table = enumerator.GetElements();

   DisplayData(table);

   Console.WriteLine("Press any key to continue.");
   Console.ReadKey();
 }

 static void DisplayData(DataTable table)
 {
   foreach (DataRow row in table.Rows)
   {
     foreach (DataColumn col in table.Columns)
     {
       Console.WriteLine("{0} = {1}", col.ColumnName, row[col]);
     }
     Console.WriteLine("==================================");
   }
 }
}

Version Information

.NET Framework

Supported in: 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Platforms

Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Reference

OleDbEnumerator Class

System.Data.OleDb Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)