I m using (3rd party control) Grid for which i have assigned the Recordset. Maximum 30 to 35 rows will come. While Inserting into the Database, i m sending data row by Row using the Loop (Used Stored procedure).

For each Row, i reach Server and Insert. I know that, this is not a Effective way.
Can I send the Grid's Recordset as a Parameter to the Stored Procedure to avoid Looping between Server and Client. Or Is there any better Ideas for this Problem ?

Thx ...


Suresh