CODEWITHSUNDEEP
c#sqlarraysstored-proceduresparameters
MA9H
MA9H

Reputation: 1909

How to pass a 3D array to a SQL Server stored procedure

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)

Upvotes: 1

Views: 326

Answers (1)

Stefano Altieri
Stefano Altieri

Reputation: 4628

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.

Upvotes: 1

Related Questions