Executes the SQL query in the sql parameter against the database. Use this method when the sql query returns a result set (e.g., SELECT or some stored procs). Otherwise, use ExecuteNonQuery(CommandType, String).

Namespace: Asi.iBO
Assembly: Asi.iBO (in Asi.iBO.dll) Version: 15.1.3.0

Syntax

C#
public DataSet ExecuteQuery(
	CommandType commandType,
	string sql
)
Visual Basic
Public Function ExecuteQuery ( _
	commandType As CommandType, _
	sql As String _
) As DataSet
Visual C++
public:
DataSet^ ExecuteQuery(
	CommandType commandType, 
	String^ sql
)

Parameters

commandType
Type: System.Data..::..CommandType
The type of cammand contained in the sql parameter.
sql
Type: System..::..String
The SQL command to execute

Return Value

A Dataset containing the results of the SQL

See Also