ALTER FUNCTION  [dbo].[SplitList]
(
    @list AS XML
)
RETURNS TABLE
AS
RETURN
(
    SELECT tempTable.item.value('.', 'VARCHAR(MAX)') AS ProductID
    FROM @list.nodes('list/item') tempTable(item)
);

ALTER PROC [dbo].[uspUtbProduct_Options_Update_Ext]

@List      XML,
@ProductID INT,
@UpdateFalse0InsertTrue1 BIT

AS

SET NOCOUNT ON;

DECLARE @ProductOptionIDs INT, @Cnt INT, @ProductOptionID INT;
  DECLARE @TableVar table 
         (ID int identity(1,1) PRIMARY KEY,
            ProductID INT NOT NULL
         )
INSERT INTO @TableVar(ProductID)
            SELECT ProductID FROM [SplitList](@List);

SELECT @Cnt = LEN(ProductID) FROM [SplitList](@List)

WHILE(@Cnt > 0)
BEGIN

SELECT @ProductOptionID = ProductID FROM @TableVar WHERE ID = (@Cnt);

IF(@UpdateFalse0InsertTrue1 = 0)
BEGIN


UPDATE   Production.utbProductUtbProductOption
SET     ProductOptionID = @ProductOptionID
WHERE   Production.utbProductUtbProductOption.ProductID = @ProductID
END

IF(@UpdateFalse0InsertTrue1 = 1)
BEGIN
INSERT INTO [Production].[utbProductUtbProductOption]
           ([ProductID]
           ,[ProductOptionID])
     VALUES
           (@ProductID
           ,@ProductOptionID)
END

SET @Cnt = @Cnt-1
END

SET NOCOUNT OFF;

    protected void btnAddOpts_Click(object sender, EventArgs e)
    {
        HiddenField hdn = null;
        CheckBox ckBx = null;
        ArrayList prodIDs = null;
        ProductsDataContext pc = null;
        try
        {
            prodIDs = new ArrayList();
            for (short i = 0; i < this.lvProdOpts.Items.Count; i++)
            {
                ckBx = this.lvProdOpts.Items[i].FindControl("ckBx") as CheckBox;
                if (ckBx.Checked)
                {
                    hdn = this.lvProdOpts.Items[i].FindControl("hdn") as HiddenField;
                    prodIDs.Add(int.Parse(hdn.Value));
                }
            }
            if (prodIDs.Count > 0)
            {
                pc = new ProductsDataContext();
                int res = pc.uspUtbProduct_Options_Update_Ext
                       (GetXml(prodIDs), int.Parse(this.ViewState["ProductID"].ToString()), true);

                this.LoadListViewProductOptions();
            }

            // 
            //   
            //   
            // 
        }  //7
        catch (Exception)
        { }
        hdn = null;
        ckBx = null;
        prodIDs = null;
        pc = null;
    }

 public static XElement GetXml(ArrayList list)
    {
        XElement x = new XElement("list");

        foreach (int prodID in list)
        {
            x.Add(new XElement("item", prodID));
        }

        return x;

    }