LinqSql Sorting Asp.net

Question

SessionIDs ids = (SessionIDs)Session["IDs"];
BSDataContext ct = new BSDataContext();

var customers = from cust in ct.tblCustomers
                where cust.AccountID == ids.accountID
                join mem in ct.tblCustomerMemberships on cust.CustomerID equals mem.CustomerID
                orderby drpFilter.SelectedValue descending
                select new { cust.CustomerID, cust.Mobile, cust.BusinessPhone, cust.Code, cust.Email, cust.HomePhone, mem.Membership, Name = cust.FirstName + cust.LastName };
grdCustomer.DataSource = customers;
grdCustomer.DataBind();

Still sorting is not performing.

If I write cust.Code instead of drp.selectedvalue then sorting is done! Why?

I suggest you wrap all this in an ObjectDataSource or if you are using Web Forms 4.5 jump directly into model binders and binding to IQueryable — Stilgar
– Stilgar, Commented Nov 18, 2014 at 10:33

Ehsan Sajjad · Accepted Answer · 2014-11-18 10:37:10Z

1

You have to check with if condition that user wants to sort on what column and sort it accordingly:

var customers = from cust in ct.tblCustomers
                        where cust.AccountID == ids.accountID
                        join mem in ct.tblCustomerMemberships
                        on cust.CustomerID equals mem.CustomerID
                        select new 
                              { cust.CustomerID, 
                                cust.Mobile, 
                                cust.BusinessPhone, 
                                cust.Code, 
                                cust.Email, 
                                cust.HomePhone, 
                                mem.Membership, 
                               Name = cust.FirstName + cust.LastName 
                             };

if(drpFilter.SelectedValue == "Code")
   customers = customers.OrderByDescending(x=>x.Code);

edited Nov 18, 2014 at 10:37

answered Nov 18, 2014 at 10:21

Ehsan Sajjad

62.6k16 gold badges113 silver badges171 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Waqar Ahmed Over a year ago

Still not performing :(

Ehsan Sajjad Over a year ago

what is the selectedValue coming? it is just for example that you have to check selectedValue and sort on property user is asking accordingly

Waqar Ahmed Over a year ago

i am using debugging to check the whether if function is true or not. Its true and orderby function is also performed but still sorting is not showing...

Ehsan Sajjad Over a year ago

you have to reassign customers as it returns new list like customers = customers.OrderByDescending(x=>x.Code)

Collectives™ on Stack Overflow

LinqSql Sorting Asp.net

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related