ConnectionString Property (SqlDBDataSource)

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

Syntax

Visual Basic
C#

'Declaration
 
Public Property ConnectionString As System.String

public System.string ConnectionString {get; set;}

Example

Private void rpt_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 rpt_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

Reference

SqlDBDataSource Class
SqlDBDataSource Members