Sql Stored procedure
-
Dear Programmers, I have a small problem with sql stored procedure.Does sql storeprocedure can return more than one recordset (for example say 2 recordsets). If so can you pls explain me how to get those 2 recordsets through VB I have already tried the same with single recordset.
-
Dear Programmers, I have a small problem with sql stored procedure.Does sql storeprocedure can return more than one recordset (for example say 2 recordsets). If so can you pls explain me how to get those 2 recordsets through VB I have already tried the same with single recordset.
A Stored procedure can return more than one record set, e.g.
CREATE PROCEDURE MyProc
AS
SELECT * FROM Products
SELECT * FROM Orders
GOYou don't specify which version of VB so I'll assume you mean VB.NET. You can use the
SqlDataAdapterobject to fill aDataSetwith the results of the stored procedure.
Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
-
A Stored procedure can return more than one record set, e.g.
CREATE PROCEDURE MyProc
AS
SELECT * FROM Products
SELECT * FROM Orders
GOYou don't specify which version of VB so I'll assume you mean VB.NET. You can use the
SqlDataAdapterobject to fill aDataSetwith the results of the stored procedure.
Do you want to know more? WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
-
Thanks for the solution one more thing is that i want to get those recordsets through VB 6.0 Please help me