Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

ExecuteTable method

UL Ext.: Retrieves in a ULTable a database table for direct manipulation. The ULCommand.CommandText is interpreted as the name of the table and ULCommand.IndexName can be used to specify a table sorting order.

Visual Basic

Overloads Public Function ExecuteTable() As ULTable

C#

public ULTable ExecuteTable();

The table as a ULTable object.

The ULCommand.CommandType must be set to System.Data.CommandType.TableDirect.

If the ULCommand.IndexName is a null reference (Nothing in Visual Basic), the primary key is used to open the table. Otherwise, the table is opened using the ULCommand.IndexName value as the name of the index by which to sort.

• ULException class - A SQL error occurred.

•  InvalidOperationException - The command is in an invalid state. Either the ULCommand.Connection is missing or closed, the ULCommand.Transaction value does not match the current transaction state of the connection, or the ULCommand.CommandText is invalid.

• ULCommand class
• ULCommand members
• ExecuteTable method
• Connection property
• Transaction property
• CommandText property
• IndexName property
•  CommandBehavior
•  CommandBehavior.Default
•  CommandBehavior.CloseConnection
•  CommandBehavior.SchemaOnly
• CommandType property
•  CommandType.TableDirect
• ULTable class