thanx for your help
how can i create search criteria where i will have two options
1.search by partnumber
2.search by partname

iwill have option button and i will opt any one on that basis it has to return the results
how kentico cms can implement this future plz reply in this regard

very kind regards

Hello,

You shouldn't import the data directly into the database, because it would (almost sure) cause system inconsistency.

Instead, you should use the Kentico.CMS.TreeEngine library to import the data


First prepare the document structure of your product (Document templates) within CMSDesk Devlopment section

Then you should use the scheme like this (in is not actual code, just the lead how you should do it, you will need to edit extend it by your needs):


// Load the Excel file

for each product record in the excel file // You will need to process the excel file structure
{
// Create a document record in CMS_Tree and CONTENT_Product tables by using Kentico.CMS.TreeEngine by using following code:

TreeNode newNode = new TreeNode("CMS.Product"); // Or any other className (document template code name) you have defined for your product

newNode.SetValue("SomeColumn", value); // Set all the values you need by calling this method for each column you need to set (you shouldn't set the identity columns)

newNode.Insert(categoryAliasPath, TreePathTypeEnum.AliasPath); // With categoryAliasPath set to the proper category node (probably MenuItem in your case) where you need to import the product
}


Each cycle iteration will insert one product record into your database along with the proper and valid tree structure records. The TreeNode class instance will hold the joined record from CMS_Tree and you document type table and provides you all the consistency you need.

Hope this would help a little, if you need any further help with that, please let us know

Best Regards