Name 

Description 

 

RowsAffected 

Indicates the number of rows operated on by the latest query execution. 

 

Text 

Indicates the SQL statement as a single string. 

 

Name 

Description 

 

DataSource 

Links the SQL dataset to another (master) dataset. 

 

GetMetadata 

Specifies whether the SQL dataset fetches metadata information along with the data. 

 

MaxBlobSize 

Indicates the maximum number of bytes fetched for any BLOB field in the dataset. 

 

ParamCheck 

Specifies whether the parameter list for an SQL dataset is regenerated when the SQL command changes. 

 

Params 

Represents the parameters for a query or stored procedure. 

 

SQL 

Specifies the SQL statement to execute on the database server. 

 

SQLConnection 

Specifies the SQL connection component that connects the dataset to a database server.