i am having one requirement in which lacks of records will be inserted into a table from a button click event in
an aspx page.the logic goes like this. it contains 4 for loops checking for array of records whether selected
( from a chkboxlist). for every selection it checks for the other array and if yes it inserts. likewise it goes for all the
checkbox array and henck this many records. what i did was , i wrote insert statement for each row
and so its taking **** a lot of time to get insert. everything is inserted in a single table.
How to increase the performance. is it possible to avoid this usinf sp. if yes is it possible to
pass an array as a parameter to the sp.pls help me.
thanks in advance
Vinoth