ExecuteSQLQueryDataTable(String,DbParameter[],Boolean,Int32,Int32) Method

SourceCode.SmartObjects.Client Namespace > SmartObjectClientServer Class > ExecuteSQLQueryDataTable Method : ExecuteSQLQueryDataTable(String,DbParameter[],Boolean,Int32,Int32) Method

Syntax

Visual Basic (Declaration)

Public Overloads Function ExecuteSQLQueryDataTable( _
   ByVal sqlString As String, _
   ByVal dbParameters() As DbParameter, _
   ByVal autoAlias As Boolean, _
   ByVal startRecord As Integer, _
   ByVal maxRecords As Integer _
) As DataTable

Visual Basic (Usage)

Dim instance As SmartObjectClientServer
Dim sqlString As String
Dim dbParameters() As DbParameter
Dim autoAlias As Boolean
Dim startRecord As Integer
Dim maxRecords As Integer
Dim value As DataTable
 
value = instance.ExecuteSQLQueryDataTable(sqlString, dbParameters, autoAlias, startRecord, maxRecords)

C#

public DataTable ExecuteSQLQueryDataTable( 
   string sqlString,
   DbParameter[] dbParameters,
   bool autoAlias,
   int startRecord,
   int maxRecords
)

C++/CLI

public:
DataTable^ ExecuteSQLQueryDataTable( 
   String^ sqlString,
   array<DbParameter^>^ dbParameters,
   bool autoAlias,
   int startRecord,
   int maxRecords
) 

Parameters

sqlString

dbParameters

autoAlias

startRecord

maxRecords

Requirements

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