Sorting gridview using ado.net entity framework

Question

i used below code to fill my gridview but i need sorting gridview . How can i do that in Ado.net enttiy framework? (Sorting gridview if filling gridview with ado.net entity )

  void LoadStaffPersonel()
        {
            int selectedDepartman = Convert.ToInt32(Request.QueryString["SelectedDepartmanID"]);
            string name = "";
            using (staffContext = new StaffManagementEntities())
            {
 name = staffContext.Departman.Where(d => d.ID == selectedDepartman).First().Name;


                ObjectResult<StaffsPersonel> personalData = staffContext.GetPersonelData(name);
                gvPersonel.DataSource = personalData.ToList();
                gvPersonel.DataBind();
            }
        }

marc_s · Accepted Answer · 2009-06-21 20:19:22Z

2

You will need to use an "EntityDataSource" on your page, and use it to provide sorting and paging. See the MSDN Documentation for more details.

If you "materialize" your list of data by issuing a .ToList() call, you lose all those capabilities.

answered Jun 21, 2009 at 20:19

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

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

Collectives™ on Stack Overflow

Sorting gridview using ado.net entity framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related