Date: 08/02/06 (C Sharp)    Keywords: sql

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?

Source: http://community.livejournal.com/csharp/71812.html