Store Procedure with ArrayList as Parameter

Question

Dear All,

I've problem to passing parameter to store procedure, the problem is parameter that i want passing is an ArratList.

i want store procedure insert to database with array that i passing.

It's that possible and how i can do that ?

Thank you for your help.

Best regards,

Surbakti

Answer 1

ARRAYLIST concept is not available in SQL Server.

You may look at Table Value Parameter(TVP) to acheive the same.

It would be great if you can go through the below link too:

http://www.sommarskog.se/arrays-in-sql-2008.html

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 2

Hi,

Try to use a table valued paramters

This link will help you : http://vinay.inkeysolutions.com/2011/03/table-valued-parameters-in-sql-server.html

Best regards,

Answer 3

I think you may need to convert ArrayList to a DataTable and pass this DataTable to the Stored Procedure using SQLDbType.Structured

C# Convert List, DataTable

Convert ArrayList to DataTable in C#

MSDN topic on passing TVP

---

Krishnakumar S