ConnectionString Property

Specifies the string used to open a connection to the data source using the SqlDb data provider.

[Visual Basic]
Public Property ConnectionString As String

[C#]
public string ConnectionString {get; set;}

Example

[C#]

Private void rptDataDynamics_ReportStart(object sender, System.EventArgs eArgs) 
{ 
    this.ds.ConnectionString = @"Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AdventureWorks2000;Data Source=TESTING"; 
    this.ds.CommandTimeout = 30; 
    System.IO.StringReader sr = New System.IO.StringReader(New System.IO.StreamReader("..\\..\\sqlString.txt").ReadToEnd()); 
    this.ds.SQL = sr.ReadToEnd(); 
    sr.Close(); 
}

[Visual Basic]

Private Sub rptDD_ReportStart(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.ReportStart

    Me.ds.CommandTimeout = 30

    Me.ds.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AdventureWorks2000;Data Source=TESTING"

    Dim sr As New System.IO.StringReader(New System.IO.StreamReader("..\\..\\sqlString.txt").ReadToEnd())

    Me.ds.SQL = sr.ReadToEnd

End Sub

See Also

Language

ConnectionString Property

Example

See Also