Last post Jul 05, 2005 10:10 PM by ecktwo
Jul 05, 2005 11:32 AM|BoarK|LINK
Jul 05, 2005 03:11 PM|PScarlett|LINK
You can try to return multiple result set from one stored procedure. So, for example you can return paging information in the first result set and the actual data in the next result set.
You just neet to process this "special" type of store procedure in the lowest level of the provider. Take a look at an article on my site called "XMLdb V3.0.2 Northwind Paging Example ". (www.tz3p9v.ca)
It describes the this method using XML but can handled via code in the same manner.
Hope that helps.... Paul -- in Oshawa.
Jul 05, 2005 03:30 PM|ecktwo|LINK
You need to pass the parameter as output type and in a sql parameter array and by ref.
Jul 05, 2005 03:52 PM|BoarK|LINK
Jul 05, 2005 10:10 PM|ecktwo|LINK
Example: You need to implement a helper function with the following signature (Microsoft.ApplicationBlocks.Data does not implement a byRef version):
Public Function mySQLHelperExecuteReader(ByVal strConnect As String, ByVal strSP As String, ByRef arParms As SqlClient.SqlParameter()) As IDataReader
Your query results is accessed through the IDataReader and your "RecordCount" is coming trough the SQL Parameter array which is being passed as by reference [in vb.net speak, sorry can't speak c# :(]