Cliquez pour évaluer et commenter
MSDN
MSDN Library
SQL Server
SQL Server 2008
Integration Services
Références techniques
DBProviderInfo Class
DBProviderInfo Properties
 Name Property

  Passer à l'affichage pour faible bande passante
Contenu de la communauté
Dans cette section
Statistiques Annotations (0)
D'autres versions sont également disponibles pour :
DBProviderInfo.Name Property

Returns the name of the provider. This field is read-only.

Espace de noms: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
Visual Basic (Declaration)
Public ReadOnly Property Name As String
C#
public string Name { get; }
C++
public:
property String^ Name {
    String^ get ();
}
J#
/** @property */
public String get_Name ()
JScript
public function get Name () : String

Valeur de propriété

A String that contains the provider name.

The following example enumerates the properties of the database providers available on the computer.

C#
namespace dbproviderinfo
{
    class Program
    {
        static void Main(string[] args)
        {
            Application app = new Application();
            DBProviderInfos dbis = app.DBProviderInfos;
            foreach (DBProviderInfo dbi in dbis)
            {
                Console.WriteLine("Description = {0}, Name = {1}, ParseName = {2}", dbi.Description, dbi.Name, dbi.ParseName);
                Console.WriteLine("ProviderSubType ={0}, ProviderType = {1}", dbi.ProviderSubType, dbi.ProviderType);
                Console.WriteLine("SupportsNullColumns = {0}, UseFullTableName = {1}", dbi.SupportsNullColumns, dbi.UseFullTableName);
            }
        }
    }
}
Visual Basic
Namespace dbproviderinfo
    Class Program
        Shared  Sub Main(ByVal args() As String)
            Dim app As Application =  New Application() 
            Dim dbis As DBProviderInfos =  app.DBProviderInfos 
            Dim dbi As DBProviderInfo
            For Each dbi In dbis
                Console.WriteLine("Description = {0}, Name = {1}, ParseName = {2}", dbi.Description, dbi.Name, dbi.ParseName)
                Console.WriteLine("ProviderSubType ={0}, ProviderType = {1}", dbi.ProviderSubType, dbi.ProviderType)
                Console.WriteLine("SupportsNullColumns = {0}, UseFullTableName = {1}", dbi.SupportsNullColumns, dbi.UseFullTableName)
            Next
        End Sub
    End Class
End Namespace

Sample output:

Description = MediaCatalogDB OLE DB Provider, Name = MediaCatalogDB OLE DB Provider, ParseName = {09E767A6-4481-4791-86A5-A739E5290E4C}

ProviderSubType =None, ProviderType = OleDb

SupportsNullColumns = True, UseFullTableName = True

Description = Microsoft OLE DB Provider for SQL Server, Name = SQLOLEDB, ParseName = {0C7FF16C-38E3-11d0-97AB-00C04FC2AD98}

ProviderSubType =SqlServer, ProviderType = OleDb

SupportsNullColumns = True, UseFullTableName = True

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez la Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Target Platforms

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server.
Contenu de la communauté   Qu'est-ce que le Contenu de la communauté ?
Ajouter du contenu RSS  Annotations
Processing
© 2009 Microsoft Corporation. Tous droits réservés. Conditions d'utilisation  |  Marques  |  Confidentialité
Page view tracker