How To Pass Array Parameter From Asp.net To One Parameter In Sql statemint?

See more:

ASP.NET

SQL

server

How To Pass Array Parameter From Asp.net To One Parameter In Sql statement???
---------------------------------------------------------------------------

now i wanna to pass array parameter to @id
like the next ex:

Dim arr As New ArrayList
       For Each row As GridViewRow In GridView1.Rows
           arr.Add(row.Cells(0).Text)
       Next
       Session("show_product") = arr
       Response.Redirect("show.aspx")

then i go to ("show.aspx")

and but gridview1 and bind it with sqldataource1 with selectedvalue like that

select * from table where id in (@id)

but the parameter unable to get ArrayList

in the end i just wanna know what is the data type how is can carry values like
1,2,3,4,5 etc
and this type apple to relapse @id to 1,2,3,4,5
to Sql statement like

select * from table where id in (1,2,3,4,5)