C# Developers' Journal (original) (raw)
Passing ArrayLists to managed stored procedures. Hi guys,
I create stored procedures in the following way:
[SqlProcedure]
public static void addrow(string blah1, string blah2)
{
// the code
}
and this works fine.
However, now I'm trying to pass an ArrayList instead of a string.
[SqlProcedure]
public static void addrow(ArrayList blah1, ArrayList blah2)
{
// the code
}
and when I deploy the server project, visual studio yells at me saying that it doesn't know such thing as an ArrayList.
But the following line is present:
using System.Collections;
Still it doesn't work.
Is there no way to pass an ArrayList into a managed stored procedure?
Update: This is sorta urgent, so for now I will have to convert ArrayLists into CSVs, and extract values inside the stored procedure, but I really want to do it using ArrayLists throughout.