Violation of PRIMARY KEY constraint 'PK_OrderForms'. Cannot insert duplicate key in object 'dbo.OrderForms'

This may happens because a multiple users logging in and checking out under the same userid/password at the same time so same basket this may cause a corrupted basket,

any way find the solution here !

http://social.msdn.microsoft.com/Forums/en-US/commserver2007/thread/898b5886-cb62-44d6-b64b-de719faf5b84/

How to Perform a Search by Using the SQL WHERE Clause in commerce server 2007

it is really nice but i am still facing problem with it :(

public static CatalogItemsDataSet SearchCatalog(CatalogContext context, string catalogName){ // Search the catalog. // Create the search options. CatalogSearchOptions searchOptions = new CatalogSearchOptions(); searchOptions.PropertiesToReturn = "CategoryName, DefinitionName, i_classtype, ProductId, VariantId, DisplayName"; searchOptions.SetPaging(1, 20); searchOptions.SortProperty = "CategoryName"; CatalogSearch catalogSearch = context.GetCatalogSearch(); // Specify the catalogs to search. // This is a comma-separated list of catalogs to search, // for example, "Catalog1,catalog2". catalogSearch.CatalogNames = catalogName; // Specify the categories to search. All categories that match the // expression are searched. This example searches all categories // that have "technical" as part of their descriptions. catalogSearch.CateoriesClause = @"Description like '%technical%'"; // Return all items with price less than $10.00. catalogSearch.SqlWhereClause = "cy_list_price<10"; // Also use the free-text search. catalogSearch.UseAdvancedFreeTextSearch = true; // Return all rows that contain the phrase "sql books". catalogSearch.AdvancedFreeTextSearchPhrase = "\"sql books\""; catalogSearch.SearchOptions = searchOptions; // Perform the search. int totalRecords = 0; CatalogItemsDataSet catalogItems = catalogSearch.Search(out totalRecords); Console.WriteLine(totalRecords); // Access each of the returned items. foreach (CatalogItemsDataSet.CatalogItem catalogItem in catalogItems.CatalogItems) { Console.WriteLine(catalogItem.CategoryName); Console.WriteLine(catalogItem.DisplayName); } return catalogItems;}
http://blogs.msdn.com/nikhiln/default.aspx
http://blogs.msdn.com/rdonovan/
http://blogs.msdn.com/vinayakt/archive/2004/05/08/128366.aspx
http://msdn2.microsoft.com/en-us/library/aa546103.aspx
http://blogs.msdn.com/vinayakt/archive/2004/05/13/130972.aspx

Paging in commerce server 2007, C# code

CatalogSearchOptions searchOptions = new CatalogSearchOptions();
searchOptions.SetPaging(PageNumber, PageSize);
YourCatalog.GetProducts(searchOptions);//returns a dataset :)

and nice article talks about that below.

http://www.eggheadcafe.com/forumarchives/commerceservercatalog/Nov2005/post24391792.asp