Passing An Array Of Strings To A Stored Procedure

Well, I managed to write a Stored procedure that updates some records in the Northwind Database based on the ProductIDs passed to the SP as a list of strings. This is the Alter version of the SP:USE [Northwind]

GO

/****** Object: StoredProcedure [dbo].[gv_sp_UpdatePOs] Script Date: 06/10/2007 12:07:54 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROC [dbo].[gv_sp_UpdatePOs]

(

@IDList varchar(500),

@ReorderLevel int,

@ProductName nvarchar(30)

 

)

AS

BEGIN

SET NOCOUNT ON

 EXEC('Update dbo.Products

SET ReorderLevel = (' + @ReorderLevel + ') ,ProductName = (''' + @ProductName + ''')

WHERE ProductID IN (' + @IDList + ')')

END

 ----------------------

THis works fine inside Sql Server 2005 Query analyser.

 But when I setup an aspx page with an objectDataSource inside the page attached to an xsd file where the Products table is located. When I try to add new query to the tableadapter inside the Products table and point to the stored procedure in the wizard I get this error: " the wizard detected the following problems when configuring TableAdapter query "Products" Details: Generated SELECT statement. Incorrect suntax near ')'.

 

Any help would be appreciated

And can someone convert it to support XML instead of list of strings. thanks.