How to pass value

[adugenet]

Is it possible to store this value in the paramter collection and pass to my query like below. for some reason it is not working for me ...please let me know how can i fix this. thanks
strState = ('AL','AR','AZ','CA','CO','CT','DC')


strState = "(" & strState & ")"
SqlDataSource1.SelectCommand &= "AND R.ASTATE IN :vState"
SqlDataSource1.SelectParameters.Add(":vState", strState)

 

[adamroof]

can u try this to see if same results?

strState = "'AL','AR','AZ','CA','CO','CT','DC'"
SqlDataSource1.SelectCommand &= "AND R.ASTATE IN vState)"

might be a limitation of a parameter using a SqlDataSource...you might have to use dynamic sql in a stored procedure for better results...maybe.