How is it possible to pass an array of strings to an SQL Server stored procedure, and return another array of strings from the stored procedure back into c# code?
My problem is :- In my project, I am using Microsoft Interop Word to edit ms word files. Using this Interop, I parsed all the word in the MS word document into a string array. Now, I have to pass this string into a stored procedure. Once this is reached at the stored procedure, I have to compare these strings with a table in the database, and if there is a match found, I have to pass back the "found" word to the c# code.
I tried the foreach statement to pass the array of strings to the stored procedure, but I don't know why I am not getting anything in return.