ActiveReports3 Request technical support
SQL Property
See Also  Example


Specifies a valid SQL statement used to retrieve records from the data source.

Syntax

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

Example

C#Copy Code
private void detail_Format(object sender, System.EventArgs eArgs)
{    
   rptSub rpt = new rptSubBM();    
   DataDynamics.ActiveReports.DataSources.OleDBDataSource subDS = new DataDynamics.        
       ActiveReports.DataSources.OleDBDataSource();    
   subDS.ConnectionString = this.ds.ConnectionString;    
   subDS.SQL = "Select * from products where categoryID = " + m_categoryID;    
   rpt.DataSource = subDS;    
   ctlSubReport.Report = rpt;
}
Visual BasicCopy 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 DataDynamics.ActiveReports.DataSources.OleDBDataSource()
    subDS.ConnectionString = Me.ds.ConnectionString
    subDS.SQL = "Select * from products where categoryID = " + m_categoryID rpt.DataSource = subDS
    Me.ctlSubreport.Report = rpt
End Sub

Remarks

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.

See Also