Update Statement Has A Problem Because Of Data Type.

I have Repeater which has checkbox to delete selected items. 

 Dim strID As String = ""

Dim newStrID As String = ""Dim anItem As RepeaterItem

For Each anItem In Repeater1.ItemsDim chkBoxDelete As CheckBox = anItem.FindControl("Delete")

If chkBoxDelete.Checked Then

strID += (CType(anItem.FindControl("ID"), Label)).Text + ", "

End If

Next

If Len(strID) > 1 Then

newStrID = Left(strID, Len(strID) - 2)

Else

newStrID = ""

End If

 

It's working great, but if I implement it with Update statement, it doesn't work when it has more than one items (it's working fine with one item).

If I just print the statement, it's

UPDATE dbo.mytable SET active='N' WHERE id IN (1, 2, 3, 4)

 

Dim sqlStr As String

sqlStr = "UPDATE dbo.mytable SET active='N' WHERE id IN (" + newStrID + ")"

Dim cmdUpdate As New SqlCommand(sqlStr, conn)

 

I think it's because of data type, since id is Integer and newStrID is string.  What should I do to make it work?

 

Thank you.