Click here to Skip to main content
15,886,676 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi,

i need to pass the arrays values to storeprocedure
am storing the binary values in byte array ecah value in each byte array
i have created a table dynamically based on the max_cols values of similiar datatype(binary)
based on the max values tables is created i need to pass arrays
at runtime how to loop and pass parameters

like
C#
if 5 cols then
sp_name(arrlist[0],arrlist[1].....)




guide me how i can do that, any other process to achive this 

Thanks inadvance
Posted
Updated 29-Dec-11 22:58pm
v10

1 solution

One possibility is to use table valued parameters, see: How to pass multiple records to a Stored Procedure[^] :rolleyes:
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900