Share via


Updating Country Codes and Region Codes

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

Commerce Server does not provide a user interface for updating country codes and region codes. To update country codes and region codes, you must either create your own user interface or update the values directly in the SQL Server database.

If you write a program to display a user interface for business users to update country codes and region codes, your program should follow these steps:

  1. Get the RegionCodeDataSet object that contains the country codes and region codes by calling the GetRegionCodes method of the OrderManagementContext object.

  2. Display the country codes and region codes that the RegionCodeDataSet object contains.

  3. Get changes to the country codes and region codes from the user.

  4. Update the RegionCodes table in the TransactionConfig database by using the changes that the user provided.

The RegionCodes Table

The RegionCodes table in the TransactionConfig database contains the country codes and region codes that the site uses. The following table describes the columns in the RegionCodes table.

Column

Type

Description

Type

int

The integer 1 if this row represents a country code, or the integer 2 if this row represents a state code.

Code

nvchar(64)

The country code, if the value of the Type column is 1. The state code, if the value of the Type column is 2.

Group

nvchar(64)

'NULL' if the value of the Type column is 1. The country code of the country or region that contains the state, if the value of the Type column is 2.

Name

nvchar(64)

The full name of the country, if the value of the Type column is 1. The full name of the state, if the value of the Type column is 2.

Description

nvchar(256)

A description of the country, if the value of the Type column is 1. A description of the state, if the value of the Type column is 2.

ModifiedBy

nvchar(128)

This column is not used.

If this column contains data, the data does not actually represent the name of the user who modified the row.

LastModified

datetime

This column is not used.

If this column contains data, the data does not actually represent the last time that the row was modified.

Created

datetime

This column is not used.

If this column contains data, the data does not actually represent the time that the row was created.

See Also

Reference

RegionCodeDataSet

Other Resources

Working with Orders Data Management Objects