CatalogRelationshipsDataSet

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

The CatalogRelationshipsDataSet class contains information about the category and product relationships for a catalog item. You can access the DataRowCollection of the dataset’s data table by using the CatalogRelationships property. You can access each row in the collection by using the properties of the CatalogRelationshipsDataSet..::.CatalogRelationship class.

The following table contains the strongly typed properties in this dataset.

Property	Description
CatalogClassTypes	Gets or sets an integer value that specifies the class type of the catalog item. This property is one of the values of the CatalogClassTypes enumeration. The possible values for this property are as follows: 1 - CategoryClass 2 - ProductVariantClass 4 - ProductClass 8 - ProductFamilyClass
DisplayName	Gets or sets a string that specifies the display name of the related item.
ListPrice	Gets or sets a decimal value that specifies the list price of the related item.
Rank	Gets or sets an integer value that specifies the rank of the related item.
RelationshipDescription	Gets or sets a string that specifies the relationship description in the current active language; maximum length is 256 characters. This property returns an empty string if the relationship does not have a description.
RelationshipName	Gets or sets the name of the relationship as a string; maximum length is 128 characters.
TargetCatalogName	Gets the target catalog name for the relationship as a string; maximum length is 85 characters.
TargetCategoryName	Gets the name of the target category for category relationships as a string; maximum length is 128 characters. This property returns null for product relationships.
TargetProductId	Gets the related product identifier for product relationships as a string; maximum length is 256 characters. This property returns null for category relationships.

Constraints

The CatalogRelationshipsDataSet class defines constraints on the RelationshipDescription, RelationshipName, TargetCatalogName, TargetCategoryName, and TargetProductId columns.

Using the CatalogRelationshipsDataSet Class

The following example demonstrates how to access the properties of the CatalogRelationshipsDataSet class.

public static void UseDataset(CatalogContext context, string catalogName, string categoryName)
{
    // Get an existing product catalog.
    ProductCatalog productCatalog = catalogContext.GetCatalog(catalogName);
    // Get a category in the catalog.
    Category category = productCatalog.GetCategory(categoryName);
    CatalogRelationshipsDataSet categoryRelationships = category.RelatedCategories;
    // Get the attributes for the first row of data.
    CatalogRelationshipsDataSet.CatalogRelationship categoryRelationship = categoryRelationships.CatalogRelationships[0];
    string targetCatalog = categoryRelationship.TargetCatalogName;
    string targetCategory  = categoryRelationship.TargetCategoryName;
    string relationshipName = categoryRelationship.RelationshipName;
    string relationshipDescription = categoryRelationship.RelationshipDescription;
          
    // Iterate through the dataset and access the attributes.
    foreach(CatalogRelationshipsDataSet.CatalogRelationship relationship in category.RelatedCategories.CatalogRelationships)
    {
        targetCatalog = relationship.TargetCatalogName;
        targetCategory  = relationship.TargetCategoryName;
        relationshipName = relationship.RelationshipName;
        relationshipDescription = relationship.RelationshipDescription;
    }
}

The CatalogRelationshipsDataSetSchema Class

The CatalogRelationshipsDataSetSchema class provides constants for all the built-in columns in the dataset and defines all the associated methods. The following table contains the associated methods for this class.

Method	Description
IsReadOnlyColumn	Returns true if the columnName in the dataset cannot be updated, or false if the columnName in the dataset can be updated.
IsBuiltInColumn	Returns true if the columnName is a built-in column in the dataset, or false if the columnName is a user-defined property.

See Also

Other Resources

Typed Datasets in the Catalog System

Typed Datasets in the Inventory System