public void fillGrid()
        {
            empTbl        e   = new empTbl();
            List <empTbl> emp = e.getAll();

            GridView1.DataSource = emp;
            GridView1.DataBind();
        }
 protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
 {
     GridViewSortExpression = e.SortExpression;
     if (GridViewSortDirection == SortDirection.Ascending)
     {
         GridViewSortDirection = SortDirection.Descending;
         empTbl        em  = new empTbl();
         List <empTbl> emp = em.getAll();
         GridView1.DataSource = emp.OrderBy(x => x.GetType().GetProperty(GridViewSortExpression).GetValue(x, null)).ToList();
     }
     else
     {
         GridViewSortDirection = SortDirection.Ascending;
         empTbl        em  = new empTbl();
         List <empTbl> emp = em.getAll();
         GridView1.DataSource = emp.OrderBy(x => x.GetType().GetProperty(GridViewSortExpression).GetValue(x, null)).ToList();
     }
     GridView1.DataBind();
 }