Multiple category for a product.

ashwinirajp · November 9th, 2009, 12:59 AM

how can i assign multiple category for a products when adding products as an admin .

Imar · November 9th, 2009, 12:52 PM

Hi there,

You need to create a junction table like ProductCategories that keeps track of the IDs of the products and of the categories. Then in the Edit page for a product you can get the categories, bind them to a CheckBoxList, and preselect the ones that were previously selected. On save, you need to clear all records from the junction, and then insert the ones that are selected in the CheckBoxList.

This is just a general overview, but i hope you get the idea.

Cheers,

Imar

ashwinirajp · November 13th, 2009, 12:24 AM

thanks for idea,
but i am not getting my checkbox list preselect

Code:

 while (dr.Read())
        {
            ListItem currentcheckbox = (ListItem)CheckBoxList1.Items.FindByValue(dr["catId"].ToString());
            if (currentcheckbox != null)
            {
                currentcheckbox.Selected = true;

            }

while there is value in dr but list item is always null

Imar · November 13th, 2009, 04:08 AM

Does the CheckBoxList already contain items at this stage? Maybe you need to call DataBind() on it first?

Imar

ashwinirajp · November 13th, 2009, 08:24 AM

thanks,
actually i was binding checkboxlist with datasource,which was not working
but bind by code working thanks