I have a SP that returns two result sets. One is the page count and product count for the category, thte other result set is the actual product/product info returned.
For pagination, I need to access the fist result to know how many pages there are so I can build the 'page-control' of sorts.
This is in XSL/XML in an ASPDotNetStoreFront XMl package. I do a query calling the SP and I get the products/prod info back, not the first result set with teh page num count/totals. Anyone know how to do this?
Hi Banu,
As far i know, aspdotnetstorefront package is the XML based product for building
Some theme based(which are similar in nature in somehow) Projects quickly. Correct Me, If I am Wrong!!!
So, I suggest you to ask this query on thier forum. They can better assist you.
http://forums.aspdotnetstorefront.com/
Thnaks...
Please "Mark As Answer;", if this Post helps you.
Visit My Blog
No, their forums are dead. I haven't received a reply from posts for several weeks if at all. So, no that is not a good forum to ask questions as they are no help even when they do reply. the parent company also shuns you for asking for help for anything
that the ehlp files wouldn't say. If you ask about customizing anything, they wash their hands of you and tell you there's no help available.
So, here, asp.net forums, is where I have always received help. So, take note. dnsf forums are terrible and their support staff is of no help other than for licensing issues, or 'out of the box' understanding of functionality.
Beau_Damore
Member
120 Points
305 Posts
XSL: accessing different result sets from stored procedure.
Feb 13, 2012 11:45 AM|LINK
Hello,
I have a SP that returns two result sets. One is the page count and product count for the category, thte other result set is the actual product/product info returned.
For pagination, I need to access the fist result to know how many pages there are so I can build the 'page-control' of sorts.
This is in XSL/XML in an ASPDotNetStoreFront XMl package. I do a query calling the SP and I get the products/prod info back, not the first result set with teh page num count/totals. Anyone know how to do this?
Consultant
www.beaudamore.com
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: XSL: accessing different result sets from stored procedure.
Feb 15, 2012 12:33 AM|LINK
Hello：）
1）If you want to do paging manually，I suggest you using a 3-rd party tool control called "ASPNETPAGER"，so you can download the sample here：
AspNetPagerSample.rar
2）
What's that？
kuber.manral
Contributor
3051 Points
714 Posts
Re: XSL: accessing different result sets from stored procedure.
Feb 15, 2012 03:36 AM|LINK
Hi Banu, As far i know, aspdotnetstorefront package is the XML based product for building Some theme based(which are similar in nature in somehow) Projects quickly. Correct Me, If I am Wrong!!! So, I suggest you to ask this query on thier forum. They can better assist you. http://forums.aspdotnetstorefront.com/ Thnaks...Visit My Blog
Beau_Damore
Member
120 Points
305 Posts
Re: XSL: accessing different result sets from stored procedure.
Feb 20, 2012 05:15 PM|LINK
No, their forums are dead. I haven't received a reply from posts for several weeks if at all. So, no that is not a good forum to ask questions as they are no help even when they do reply. the parent company also shuns you for asking for help for anything that the ehlp files wouldn't say. If you ask about customizing anything, they wash their hands of you and tell you there's no help available.
So, here, asp.net forums, is where I have always received help. So, take note. dnsf forums are terrible and their support staff is of no help other than for licensing issues, or 'out of the box' understanding of functionality.
thanks
Consultant
www.beaudamore.com
TimoYang
Contributor
3732 Points
1275 Posts
Re: XSL: accessing different result sets from stored procedure.
Feb 21, 2012 12:12 AM|LINK
Hello BEau_Damore：）
Sorry to hear that，and what's going on with you？