I have a 3D string array in C# and I need to send it to a SQL server stored procedure as a parameter so that the procedure performs a select query using WHERE condition from each array row (3 conditions)
Asked
Active
Viewed 301 times
1
-
1Did you tried _anything_? – Soner Gönül Apr 15 '13 at 14:32
-
not really, I've been reading on it online, but I just don't really get it :( – MA9H Apr 15 '13 at 14:34
1 Answers
1
You can add a table parameter to the stored procedure and pass the input data as a DataTable.
This article can be a starting pont for sql 2008.
Stefano Altieri
- 4,550
- 1
- 24
- 41
-
thanks a lot, but I have one more question.. the procedure is working just fine in sql server, but I can't catch the returned table in c#, any ideas?? – MA9H Apr 16 '13 at 16:17
-
never mind, I've just figured it out!! :) "http://stackoverflow.com/questions/12386188/return-value-from-stored-procedure-to-c-sharp" – MA9H Apr 16 '13 at 17:49