AdoDataConnectionRetrieveData(String, Object) Method

Executes the SQL statement using Connection, and returns the first DataTable of result set, if the result set contains at least one table.

Namespace: GSF.Data
Assembly: GSF.Core (in GSF.Core.dll) Version: 2.4.248-beta+a497a19de709fd99e2448886199a2c8824265ddf

Syntax

public DataTable RetrieveData(
	string sqlFormat,
	params Object[] parameters
)

Public Function RetrieveData ( 
	sqlFormat As String,
	ParamArray parameters As Object()
) As DataTable

public:
DataTable^ RetrieveData(
	String^ sqlFormat, 
	... array<Object^>^ parameters
)

member RetrieveData : 
        sqlFormat : string * 
        parameters : Object[] -> DataTable

function RetrieveData(sqlFormat, ... parameters);

sqlFormat String: Format string for the SQL statement to be executed.
parameters Object: The parameter values to be used to fill in IDbDataParameter parameters.

DataTable
A DataTable object.