Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

CatalogSearchOptions.PropertiesToReturn Property (BCL)

Commerce Server 2002

The PropertiesToReturn property is a string that gets or sets property names that should be returned in a query result set.


[Visual Basic .NET]
Public Property PropertiesToReturn As System.String
public System.String PropertiesToReturn {get; set;} 

Property Value

A String object containing a comma-delimited list of property names.


The default value is null, indicating to return all properties.


Use the following code to return a column named UnitPrice that can be bound to a control. The UnitPrice column contains the price per unit of the product, calculated by dividing the cy_list_price by the number of units. If Units is set to zero, the UnitPrice is the same as the cy_list_price. This sample assumes that you have a user-defined property named Units that stores the number of units that are sold for the given cy_list_price price.

[Visual Basic .NET]
Dim searchOptions As New CatalogSearchOptions()
searchOptions.PropertiesToReturn = "(cy_list_price/isnull(nullif(Units,0),1))UnitPrice, PID" 
DataSet ds = cat.GetProducts(searchOptions)
CatalogSearchOptions searchOptions = new CatalogSearchOptions();
searchOptions.PropertiesToReturn = "(cy_list_price/isnull(nullif(Units,0),1))UnitPrice, PID";  
DataSet ds = cat.GetProducts(searchOptions);


Namespace: Microsoft.CommerceServer.Runtime.Catalog

Platforms: Windows 2000, Windows Server 2003

Assembly: Microsoft.CommerceServer.Runtime.dll

Copyright © 2005 Microsoft Corporation.
All rights reserved.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft