Visual Basic (Declaration) | |
---|---|
Public Property SQL As System.String |
C# | |
---|---|
public System.string SQL {get; set;} |
ActiveReports creates a DataReader and uses it to load the data into the report.
The SQL string may contain parameter placeholder syntax to fill the report's parameters collection and prompt the user to enter their values before executing the report.
C# | Copy Code |
---|---|
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; } |
Visual Basic | Copy Code |
---|---|
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 |
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2