ActiveReports 14 .NET Edition
GrapeCity.ActiveReports Assembly / GrapeCity.ActiveReports.Data Namespace / OleDBDataSource Class / ConnectionString Property
Example

In This Topic
    ConnectionString Property (OleDBDataSource)
    In This Topic
    Specifies the string used to open a connection to the data source using the OleDb data provider.
    Syntax
    'Declaration
     
    Public Property ConnectionString As String
    public string ConnectionString {get; set;}
    Example
    private void detail1_Format(object sender, System.EventArgs eArgs)
    {    
        rptSubBM rpt = new rptSubBM();    
        GrapeCity.ActiveReports.Data.OleDBDataSource subDS = new GrapeCity.ActiveReports.Data.OleDBDataSource();    
        subDS.ConnectionString = ((GrapeCity.ActiveReports.Data.OleDBDataSource)(this.DataSource)).ConnectionString;    
        subDS.SQL = "Select * from products where categoryID = " + m_categoryID;    
        rpt.DataSource = subDS;    
        ctlSubReport.Report = rpt;
    }
    Private Sub Detail1_Format(ByVal sender As Object, ByVal e As System.EventArgs) Handles Detail1.Format
        Dim rpt As New rptSubBM()
        Dim subDS As New GrapeCity.ActiveReports.Data.OleDBDataSource()    
        subDS.ConnectionString = CType(Me.DataSource, GrapeCity.ActiveReports.Data.OleDBDataSource).ConnectionString    
        subDS.SQL = "Select * from products where categoryID = " + m_categoryID    rpt.DataSource = subDS    
        Me.ctlSubreport.Report = rpt 
    End Sub
    See Also