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

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(); }`

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 Copy Code

Visual Basic	Copy 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`

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

ActiveReports3	Request technical support
SqlDBDataSource Class
See Also Members Example

Syntax

Example

Inheritance Hierarchy

See Also

Reference