How to pass a 2D array to a Stored procedure?

Question

I'm trying to pass a 2D array from by C#.NET program to a stored procedure in SQL Server 2005. I dont know how to accomplish this. I'm gathering my data in a DataGridView.
Can anyone help me with this?

Answer 1

SQL Server doesn't support arrays as such.

Depending on how much data you have, you can do something like this: How to Pass and Handle a Delimited String similar to handling an Array() of Values.

You can also read Erland Sommarskog's article on the subject of Arrays and Lists in SQL Server 2005 which outlines various different approaches to tackling the problem.