• fixed the C# code :

    SqlCommand cmd = new SqlCommand("casp_GetExist", cnt);

    SqlParameter parameter = new SqlParameter();

    cmd.CommandType = CommandType.StoredProcedure;

    //The parameter for the SP must be of SqlDbType.Structured

    parameter.ParameterName = "@BLMJ_LIST";

    parameter.TypeName = "CampaignIdList";

    parameter.SqlDbType = System.Data.SqlDbType.Structured;

    parameter.Value = dataTable;

    cmd.Parameters.Add(parameter);

    SqlDataReader sqlDR = cmd.ExecuteReader();

    but dont get recordset on :sqlDR