OleDbConnectionStringBuilder.DataSource Propriedade
Definição
Obtém ou define o nome da fonte de dados à qual se conectar.Gets or sets the name of the data source to connect to.
public:
property System::String ^ DataSource { System::String ^ get(); void set(System::String ^ value); };
public string DataSource { get; set; }
member this.DataSource : string with get, set
Public Property DataSource As String
Valor da propriedade
O valor da propriedade DataSource ou String.Empty se nenhum tiver sido aplicado.The value of the DataSource property, or String.Empty if none has been supplied.
Exemplos
O exemplo de aplicativo de console a seguir cria uma nova instância e, OleDbConnectionStringBuilder em seguida, define as DataSource Provider Propriedades e.The following example console application creates a new OleDbConnectionStringBuilder instance, and then sets the DataSource and Provider properties. Por fim, o exemplo cria uma nova OleDbConnection instância e usa esse objeto para se conectar ao armazenamento de dados indicado.Finally, the example creates a new OleDbConnection instance, and uses that object to connect to the indicated data store.
using System.Data.OleDb;
class Program
{
static void Main()
{
OleDbConnectionStringBuilder builder =
new OleDbConnectionStringBuilder();
builder.DataSource = @"C:\Sample.mdb";
builder.Provider = "Microsoft.Jet.Oledb.4.0";
Console.WriteLine(builder.ConnectionString);
// This sample assumes that you have a database named
// C:\Sample.mdb available.
using (OleDbConnection connection = new
OleDbConnection(builder.ConnectionString))
{
try
{
connection.Open();
// Do something with the database here.
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
Console.WriteLine("Press Enter to finish.");
Console.ReadLine();
}
}
Imports System.Data.OleDb
Module Module1
Sub Main()
Dim builder As New OleDbConnectionStringBuilder()
builder.DataSource = "C:\Sample.mdb"
builder.Provider = "Microsoft.Jet.Oledb.4.0"
Console.WriteLine(builder.ConnectionString)
' This sample assumes that you have a database named
' C:\Sample.mdb available.
Using connection As New OleDbConnection(builder.ConnectionString)
Try
connection.Open()
' Do something with the database here.
Catch ex As Exception
Console.WriteLine(ex.Message)
End Try
End Using
Console.WriteLine("Press Enter to finish.")
Console.ReadLine()
End Sub
End Module
Comentários
Se o valor passado for nulo quando você tentar definir a propriedade, a DataSource propriedade será redefinida.If the value passed in is null when you try to set the property, the DataSource property is reset. Se o valor não tiver sido definido e o desenvolvedor tentar recuperar a propriedade, o valor de retorno será String.Empty .If the value has not been set and the developer tries to retrieve the property, the return value is String.Empty. Essa propriedade corresponde à chave "fonte de dados" na cadeia de conexão.This property corresponds to the "Data Source" key within the connection string.