ActiveReports3 Request technical support
ConnectionString Property
See Also  Example


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

Syntax

Visual Basic (Declaration) 
Public Property ConnectionString As String
Visual Basic (Usage)Copy Code
Dim instance As SqlDBDataSource
Dim value As String
 
instance.ConnectionString = value
 
value = instance.ConnectionString
C# 
public string ConnectionString {get; set;}

Example

C#Copy Code
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 BasicCopy Code
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