View Complete Post
Is it possible with SQL sorted in descending order according to the word?In Table I shrajeno Mastercard, Visa, Diners etc ...All Visa are the first in the order, another Mastercard, etc. ...Something does not work: ORDER BY PaymentType = 'Visa';I would not want to work in one field PaymentId (111,222,33, etc. ..) and then use the ORDER BY.Is this possible in such a way?
Dear, I want to stop sorting in cross tab report header. And also want to sort in specific order. How can i do that? Please help me. Its urgent
Edited by Nancy Michell
MSDN Magazine October 2002
MSDN Magazine February 2002
Having a little trouble here. I am taking a table (Articles) and grouping all the results by the key that references another table (ArticleSectionCategories). I then want to sort these results by the OrderBy field of the referenced table (ArticleSectionCategory.OrderBy). This is what I am using right now but it is not working. Any thoughts?
var GroupedArticles = from A in DC.Articles
where A.PackagesId == packageId
group A by A.ArticleSectionCategoriesId into G
select G.OrderBy(C => C.ArticleSectionCategory.OrderBy);
I have looked at several posts on Gridview sorting but can't seem to get it to work in my code. I am using Subsonic objects as the DataSource. Every time I click on a page or sorting link it does a postback but the page orientation is left at the top, not where the gridview is on the page. Is there a way around this?
This is the code I have written for it: