The ObjectDataSource.SelectCountMethod Property just gives the name of the method to get the SelectCount.. I want the actual select count. :) Here's some more information: I am getting the e.ReturnValue from the ObjectDataSource Selected event. The ObjectDataSource is hitting a Data Access Layer that returns a List of Products: public static List GetProducts(int maximumRows, int startRowIndex, string sortExpression, int categoryId) ... I'm only getting the records I need from the database by page with this DAL method. I'm then using a ObjectDataSource SelectCountMethod to get the total number of products in that category (ALL pages): public int TotalNumberOfProducts(int categoryId, string sortExpression) ... The thing I really want is to get the value of the TotalNumberOfProducts in that category without hitting the database again. I should be able to get that from the ObjectDataSources Selected event or is there somewhere else where I should be trying to get this value? Any suggestions would be very helpful! Thanks. Dirk Watkins

You can use: INSERT INTO #MyTempTable (col1, col2, col3, ..., coln) EXEC MyStoredProc where the temporary table's column list matches the columns returned in the stored procedures resultset (and their data types).

Hi, how about WildCard SSL.[^] I think it is suite to your need.