public void binddropdown()
        {
            CustomProfile        profile       = CustomProfile.GetProfile();
            iProductMasterClient productClient = new iProductMasterClient();

            ddlProductType.DataSource = productClient.GetProductTypeList(profile.DBConnection._constr);
            ddlProductType.DataBind();

            ListItem lst1 = new ListItem();

            lst1.Text  = "-Select-";
            lst1.Value = "0";
            ddlProductType.Items.Insert(0, lst1);

            ddlUOM.SelectedIndex = -1;
            ddlUOM.DataSource    = productClient.GetProductUOMList(profile.DBConnection._constr);
            ddlUOM.DataBind();
            ListItem lst3 = new ListItem();

            lst3.Text  = "-Select-";
            lst3.Value = "0";
            ddlUOM.Items.Insert(0, lst3);
            productClient.Close();

            BrilliantWMS.ProductCategoryService.iProductCategoryMasterClient productcategoryClient = new BrilliantWMS.ProductCategoryService.iProductCategoryMasterClient();

            ddlCategory.SelectedIndex = -1;
            ddlCategory.DataSource    = productcategoryClient.GetProductCategoryList(profile.DBConnection._constr);
            ddlCategory.DataBind();
            productcategoryClient.Close();
            ListItem lst2 = new ListItem();

            lst2.Text  = "-Select-";
            lst2.Value = "0";
            ddlCategory.Items.Insert(0, lst2);
        }