Dataset: ProductSubcategories
Dataset properties
| Property | Value |
| Data source name | AdventureWorks |
| Referenced data set | |
| Command type | Query |
Parameters
| Name |
| @ProductCategory |
Fields
| Name | Source column | Data type | Caption | Value | Is calculated field |
| ProductSubcategoryID | ProductSubcategoryID | System.Int16 | |||
| ProductCategoryID | ProductCategoryID | System.Int32 | |||
| Name | Name | System.String |
Filters
Query
SELECT ProductSubcategoryID, ProductCategoryID, Name FROM Production.ProductSubcategory WHERE (ProductCategoryID = @ProductCategory) |
See also