How to send Variable number of parameters from vb.2005 to sql-server

I have a problem regarding forwarding ‘n number of parameters’ from Visual Studio 2005 using VB to SQL-Server 2005 stored procedure.I have to save N number of rows in my stored procedure as a transaction. If all rows are not saved successfully, I have to roll-back else update some other table after that. I am unable to handle – How to send variable number of parameters from Visual Stduio to Sql – Server ? My requirement is use the SQL-Stored Procedure. Please Help …..