c# - How to Passing array parameters to stored procedure in? -

i have these tables :

have array cat1,cat2,cat3,cat4 want passed sql server stored procedure.
check them exist in paperkeywors's table or not . if yes, insert pkeyid of theme , pid (for example pid=1) papertag , if no return them.
know must using tvp , , wrote these code in sql :

create type paperkeywordstype table         ( pkeyword nvarchar(200) ,pkeyid int  ) 

and :

create procedure [dbo].[insertpapertag]   (@dt paperkeywordstype readonly ,  @pid int) begin   set nocount on;    insert dbo.papertags(pid,pkeyid)    select @pid,paperkeywords.pkeyid @dt tvp    inner join paperkeywords on paperkeywords.pkeyword = tvp.pkeyword end 

it's not work me. why?

from c# need create datatable values , pass stored procedure. see so post. can pass values delimited string stored procedure , use function in tsql convert values table. see post few examples.