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:
Get the RegionCodeDataSet object that contains the country codes and region codes by calling the GetRegionCodes method of the OrderManagementContext object.
Display the country codes and region codes that the RegionCodeDataSet object contains.
Get changes to the country codes and region codes from the user.
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. |