SQL Server 2005 - Passing 2 Dim. Array to SP

[Anusha 1980]

Hi, I am working on SQL Server 2005. Here I need to pass an array (2 dimensional, E.g: Emp No, Emp Name ) having multiple records from my ASP.NET application to a Stored Procedure. Would you please let me know if there is a way to do it? Many Thanks, Regards. Anusha.

[Lost User]

Anusha.1980 wrote:

Would you please let me know if there is a way to do it?

One way would be by using XML[^] :)

I are Troll :suss:

[Niladri_Biswas]

Even you can try with Bulk Insert Have a look http://blogs.msdn.com/nikhilsi/archive/2008/06/11/bulk-insert-into-sql-from-c-app.aspx[^] :)

Niladri Biswas