protected void FillAvailableProducts() { ddlAvailableProducts.Items.Clear(); BPProducts bp = new BPProducts(); if (ddlRelatedProductsCategories.SelectedIndex == 0) { DSProducts = bp.SelectNonRelatedProductsByProductID(ProductID); }else{ DSProducts = bp.SelectNonRelatedProductsByProductIDAndProductCategoryID(ProductID,Convert.ToInt32(ddlRelatedProductsCategories.SelectedValue)); } DSProducts.tbl_Products.DefaultView.Sort = "ProductName"; ddlAvailableProducts.DataTextField = "ProductName"; ddlAvailableProducts.DataValueField = "RelatedProductID"; ddlAvailableProducts.DataBind(); }