Stored Procedure - Record Set
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
Re: Stored Procedure - Record Set
Pls Any one Help me for this problem ....
I welcome ur Comments on my posting
Re: Stored Procedure - Record Set
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.
Re: Stored Procedure - Record Set
Thx Cakkie
That relieved lot of my pain
Suresh