How do I pass string array to stored procedure

See more:

VB

stored-procedure

Hi -

I'm getting the error:

"No mapping exists from object type System.String[] to a known managed provider native type."

I'm trying to pass a string array to my stored procedure but how. I'm looking through a grid grabbing the IDs that are selected then want to pass those to the stored procedure to see if they are valid. If that ID isnt valid then do something and if it is do something else.

Here are the code snippets

        For Each row As DataGridItem In dgAssets.Items
            Dim c As Boolean = DirectCast(row.FindControl("cbSelect"), CheckBox).Checked
            If (c) Then
                ptsId = DirectCast(row.FindControl("txtPTSID"), Label).Text
                ptsIdList.Add(ptsId)
            End If
        Next
        Dim myPtsArr As String() = CType(ptsIdList.ToArray(GetType(String)), String())

        If (resultCheck.CheckFailStatus(myPtsArr) = "F") Then
Do Stuff
End If

Here is the method that calls the procedure

Public Function CheckFailStatus(ptsId() As String) As String
        Dim result As String
        Dim cs As String = ConfigurationManager.ConnectionStrings("PTS_EConnectionStringDEV").ConnectionString
        Using con As New SqlConnection(cs)
            Dim cmd As New SqlCommand("stpr_CheckFailStatus", con)
            cmd.CommandType = CommandType.StoredProcedure
            Dim parm As New SqlParameter("@PTSID", ptsId)
            cmd.Parameters.Add(parm)
            con.Open()
            Dim reader As SqlDataReader = cmd.ExecuteReader()
            While reader.Read()
                result = (reader("RESV_STATUS").ToString())
            End While