Gemstone Data Library
Show/Hide TOC

# AdoDataConnectionRetrieveRow(Int32, String, Object) Method

Executes the SQL statement using Connection, and returns the first DataRow in the result set.

## Definition

Namespace: Gemstone.Data
Assembly: Gemstone.Data (in Gemstone.Data.dll) Version: 1.0.143 -- Release Build+e39ee60a4b307fea0c37636ce689adb1b037d737
C#
View Source Request Example

    public DataRow RetrieveRow(
    	int timeout,
    	string sqlFormat,
    	params Object?[] parameters
    )

VB
View Source Request Example

    Public Function RetrieveRow (
    	timeout As Integer,
    	sqlFormat As String,
    	ParamArray parameters As Object()
    ) As DataRow

C++
View Source Request Example

    public:
    DataRow^ RetrieveRow(
    	int timeout,
    	String^ sqlFormat,
    	... array<Object^>^ parameters
    )

JavaScript
View Source Request Example

    function RetrieveRow(timeout, sqlFormat, ... parameters);

#### Parameters

timeout Int32
  The time in seconds to wait for the SQL statement to execute.
sqlFormat String
  Format string for the SQL statement to be executed.
parameters Object
  The parameter values to be used to fill in DbParameter parameters.

#### Return Value

DataRow
The first DataRow in the result set.

## See Also

#### Reference

AdoDataConnection Class
RetrieveRow Overload
Gemstone.Data Namespace