How can I pass an array variable to a SQL Server stored procedure using C# and insert array values into a whole row?
Thanks in advance.
SQL Server table:
ID | Product | Description
-------------------------------
8A3H | Soda | 600ml bottle
C# array:
string[] info = new string[] {"7J9P", "Soda", "2000ml bottle"};
SQL Server stored procedure:
ALTER PROC INSERT
(@INFO_ARRAY ARRAY)
AS
BEGIN
INSERT INTO Products VALUES (@INFO_ARRAY)
END
See Question&Answers more detail:os