ActiveReports3 Request technical support
SqlDBDataSource Class
See Also  Members   Example 


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

Syntax

Visual Basic (Declaration) 
Public Class SqlDBDataSource 
Visual Basic (Usage)Copy Code
Dim instance As SqlDBDataSource
C# 
public class SqlDBDataSource 

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

Inheritance Hierarchy

System.Object
   DataDynamics.ActiveReports.DataSources.SqlDBDataSource

See Also