See Also

SqlDBDataSource Members  | DataDynamics.ActiveReports.DataSources Namespace  | OleDBDataSource class  | XMLDataSource class

Language

Visual Basic

C#

Show All

See Also Languages ActiveReports Send feedback to Data Dynamics

SqlDBDataSource Class

Represents a report data source based on the SqlDB ADO.NET data provider.

For a list of all members of this type, see SqlDBDataSource members.

Inheritance Hierarchy

System.Object
   DataDynamics.ActiveReports.DataSources.SqlDBDataSource

Syntax

[Visual Basic]
Public Class SqlDBDataSource
[C#]
public class SqlDBDataSource

Example

[C#] 

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 Basic] 

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

SqlDBDataSource Members  | DataDynamics.ActiveReports.DataSources Namespace  | OleDBDataSource class  | XMLDataSource class

 

 


Copyright © 2004-2005 Data Dynamics, Ltd. All rights reserved.