Stored Procedure - Record Set

[Surr_79]

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

[Surr_79]

Pls Any one Help me for this problem ....


I welcome ur Comments on my posting

[Cakkie]

AFAIK that isn't possible. SQL Server does know a datatype table, which can be used to pass in memory tables from 1 proc to another, but there's no way you can pass them from VB to SQL Server in 1 piece. I guess you will have to stick to your looping solution.

[Surr_79]

Thx Cakkie

That relieved lot of my pain


Suresh