SQL IN keyword not working in Stored Procedure

See more:

SQL-Server-2005

C#

SQL-Server

I am using Stored Procedure for my project. IN keyword used within procedure, values are passing through parameter. I am not getting output. Only raise error.

SQL Codes:

Create Proc TestPro @Parameter Varchar(100)
as
Declare @QueryStr Varchar(1000)
set @QueryStr='Select Col1,Col2,Col3,Col4 from Table where Col1 in('+ @Parameter+ ')'
Exec (@QueryStr)

C# Code:

string strPrValue="'ABC/01','ABC/02','ABC/03'";
SqlConnection sconPM = new SqlConnection(Constring);
SqlCommand sCmd = new SqlCommand("TestPro", sconPM);
SqlDataAdapter DA = new SqlDataAdapter(sCmd);
DataSet ds = new DataSet();
sCmd.Parameters.Add("@Parameter", SqlDbType.VarChar).Value = strPrValue;
sCmd.CommandType = CommandType.StoredProcedure;
DA.Fill(ds);

if i pass only one value(ABC/01) in parameter its working fine , if many value in parameter raise error like "incorrect syntax near ABC/"