public static void FillDropDownListProductID(DropDownList ddl, SqlInt32 UserID)
        {
            ProductBAL balProduct = new ProductBAL();

            ddl.DataSource     = balProduct.SelectDropDownList(UserID);
            ddl.DataTextField  = "ProductName";
            ddl.DataValueField = "ProductID";
            ddl.DataBind();
            ddl.Items.Insert(0, new ListItem("---Select Product---", "-99"));
        }