Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

MES Stateless API

TABLE OF CONTENTS

GetDSbySQL Method

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL

The GetDSbySQL() method retrieves a new DataSet based on the SQL statement passed as a parameter. The SQL statement must be a single SELECT statement.

Syntax

'Declaration
 
Public Shared Function GetDSbySQL( _
   ByVal sessionId As Integer, _
   ByVal sql As String _
) As DataSet
'Usage
 
Dim sessionId As Integer
Dim sql As String
Dim value As DataSet
 
value = Session.GetDSbySQL(sessionId, sql)
public static DataSet GetDSbySQL( 
   int sessionId,
   string sql
)

Parameters

sessionId
Optional. Holds the session ID and thus the user who is making this method call.
sql
Required. Holds the SQL SELECT statement to execute.

Return Value

Returns a DataSet based on the supplied SQL statement.

Remarks

Prior to MES 2017, any SQL statement could be passed as a parameter to this method. With MES 2017 and later, any call not using a single SELECT statement will result in the error "Invalid SQL statement caught by Middleware."

To call a custom stored procedure, use the ExecSp() or GetDsBySp() method in the Core.DirectAccess class.

See Also

Reference

Session Class
Session Members

In This Topic
TitleResults for “How to create a CRG?”Also Available in