0

From C# code I need to pass list of arrays to stored procedure. Each array is a triple like (param1, param2, param3). So list will look like :

{(param1, param2, param3), (param1, param2, param3), (param1, param2, param3)... }

In the stored procedure I want to Insert each triple (param1, param2, param3) to table as seperate row.

Please advise how it's possible to implement.

Thanks in advance.

Alexander
  • 141
  • 1
  • 1
  • 8
  • 1
    would you pls take a look at here http://stackoverflow.com/questions/7097079/c-sharp-sql-server-passing-a-list-to-a-stored-procedure?rq=1 – Enigma State Oct 04 '13 at 09:38
  • you could also look at "How to pass an array into a SQL Server stored procedure": http://stackoverflow.com/questions/11102358/how-to-pass-an-array-into-a-sql-server-stored-procedure – Seymour Oct 04 '13 at 10:48
  • Probably you may want to simplify a procedure to take only 3 parameters, and invoke it in a loop in the same transaction? – mikalai Oct 04 '13 at 11:39

0 Answers0