aspx page not getting all rows from stroed procedure

  • Thread starter Thread starter Woody
  • Start date Start date
W

Woody

Im working on an issue with an aspx page.

the code is below

StoredProcsDataContext storedProc = new StoredProcsDataContext ( );
var results = storedProc.ssp_GetAllAccountsForProducerCode (
producerCode );
int Reccnt = results.Count();
IList<ssp_GetAllAccountsForProducerCodeResult> resultList =
results.ToList ( );
LossReportBOC searchResults = new LossReportBOC ( );
LossReportBO item;

its only returning 32 rows, when i run the stored procedure standup i
get all 400+ rows that im expecting.

any ideas on where to look?

thanks

Woody
any sugestion or comment made by me should be examined first for
validity and appropriateness before assuming i have any idea at all
what the heck i am talking about. I am not responsible for anything you
may see with my name attached to it, i think.
 
Im working on an issue with an aspx page.  

the code is below

StoredProcsDataContext storedProc = new StoredProcsDataContext ( );
var results = storedProc.ssp_GetAllAccountsForProducerCode (
producerCode );
int Reccnt = results.Count();
IList<ssp_GetAllAccountsForProducerCodeResult> resultList =
results.ToList ( );
LossReportBOC searchResults = new LossReportBOC ( );
LossReportBO item;

its only returning 32 rows, when i run the stored procedure standup i
get all 400+ rows that im expecting.

any ideas on where to look?

thanks

Woody
any sugestion or comment made by me should be examined first for
validity and appropriateness before assuming i  have any idea at all
what the heck i am talking about.  I am not responsible for anything you
may see with my name attached to it, i think.

*** Sent via Developersdexhttp://www.developersdex.com***
Click to expand...

Hi Woody,

Did you check it before calling the report?

results.ToList ( );
Response.Write(resultsList.Count());
 
Back
Top