{"id":227,"date":"2010-05-18T22:59:34","date_gmt":"2010-05-18T17:29:34","guid":{"rendered":"http:\/\/JitendraZaa.com\/blog\/?p=227"},"modified":"2010-05-18T22:59:34","modified_gmt":"2010-05-18T17:29:34","slug":"datagrid-example-sorting-part-2","status":"publish","type":"post","link":"https:\/\/www.jitendrazaa.com\/blog\/microsoft\/net\/datagrid-example-sorting-part-2\/","title":{"rendered":"DataGrid Sorting and Paging Example \u2013 Part 2"},"content":{"rendered":"

For Part 1, visit This URL\u00a0https:\/\/jitendrazaa.com\/blog\/?p=191<\/a><\/p>\n

In this part, i will show that how to Sort the Datagrid Component of ASP.NET.<\/p>\n

To sort Datagrid, we will need DataView <\/span><\/strong>and then assign Dataview as datasource to our Grid control.<\/p>\n

We will need to change our code of Part 1.<\/p>\n

Previously, we used DataSet <\/strong>as a Datasource. This time we will use DataTable <\/strong>and get the DataView from DataTable using below line.<\/p>\n

\nDataView dv = dt.DefaultView; \/\/Where dt id DataTable\n<\/pre>\n
So we have created a function, which will return the DataTable as shown below:<\/p>\n
\nprivate DataTable GetTableFromDataBase()\n{\nSqlConnection con = null;\nSqlDataAdapter adp = null;\nDataTable dt = new DataTable();\ntry\n{\ncon = new SqlConnection(conString);\ncon.Open();\nadp = new SqlDataAdapter("Select * from Employee",con);\nadp.Fill(dt);\nreturn dt;\n}\ncatch (CustomException ex)\n{\nex.logException();\n}finally{\ncon.Close();\n}\nreturn null;\n}\n<\/pre>\n
we will need to create the function on Sortcommand <\/strong>of the DataGrid.<\/p>\n
The format for sorting the grid is like:<\/p>\n
SortExpression+”asc”<\/strong><\/p>\n
OR<\/p>\n
SortExpression+”desc”<\/strong><\/p>\n
Below is the code snap used for the sorting:<\/p>\n
\nprotected void grdEmp_Sort(object source, DataGridSortCommandEventArgs e)\n{\nDataTable dt = GetTableFromDataBase();\nDataView dv = dt.DefaultView;\nstring dir = string.Empty;\nif (e.SortExpression.Length > 0)\n{\nif (Session["OldSortDir"] == null)\n{\nSession["OldSortDir"] = e.SortExpression;\n}\nelse\n{\nstring oldSortExp = Session["OldSortDir"].ToString();\nif (oldSortExp == "asc")\n{\ndir = "desc";\nSession["OldSortDir"] = "desc";\n}\nelse\n{\ndir = "asc";\nSession["OldSortDir"] = "asc";\n}\n}\ndv.Sort = e.SortExpression+" \u00a0"+dir;\n}\ngrdEmp.DataSource = dv;\ngrdEmp.DataBind();\n}\n<\/pre>\n
The code for the Pagination is written below. Consider Page Size as 3.<\/p>\n
\n
\nprotected void grdEmp_Paging(object source,DataGridPageChangedEventArgs p)\n{\ngrdEmp.CurrentPageIndex = p.NewPageIndex;\nBindTable();\n}\n<\/pre>\n
\"\"<\/a>Download Source code<\/a><\/h1>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
For Part 1, visit This URL\u00a0https:\/\/jitendrazaa.com\/blog\/?p=191 In this part, i will show that how to Sort the Datagrid Component of ASP.NET. To sort Datagrid, we will need DataView and then assign Dataview as datasource to our Grid control. We will need to change our code of Part 1. Previously, we used DataSet as a Datasource. […]<\/p>\n","protected":false},"author":1,"featured_media":350,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"jz_research_post":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[21],"tags":[43,71],"class_list":["post-227","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-net","tag-asp-net","tag-datagrid"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":608,"url":"https:\/\/www.jitendrazaa.com\/blog\/microsoft\/net\/selecting-and-sorting-in-datatable-asp-net-c\/","url_meta":{"origin":227,"position":0},"title":"Selecting and Sorting in DataTable – ASP.net C#","author":"Jitendra","date":"July 7, 2010","format":false,"excerpt":"Demonstrates that how to select and sort the Datatable in ASP.Net , C#","rel":"","context":"In "ASP.NET"","block_context":{"text":"ASP.NET","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/microsoft\/net\/"},"img":{"alt_text":"Sorting and Selecting DataTable in ASP","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/07\/Sorting-and-Selecting-DataTable-in-ASP-300x223.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1419,"url":"https:\/\/www.jitendrazaa.com\/blog\/microsoft\/this-row-already-belongs-to-another-table-error\/","url_meta":{"origin":227,"position":1},"title":"This row already belongs to another table – Error","author":"Jitendra","date":"February 6, 2011","format":false,"excerpt":"This row already belongs to another table - Error resolved","rel":"","context":"In "c#"","block_context":{"text":"c#","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/microsoft\/csharp\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":7101,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/implement-infinite-scrolling-for-lightning-data-table\/","url_meta":{"origin":227,"position":2},"title":"Implement Infinite Scrolling for lightning-datatable","author":"Jitendra","date":"June 10, 2020","format":false,"excerpt":"When to use wire vs Imperative approach to call Apex in Lightning Web Component","rel":"","context":"In "Lightning Web Components"","block_context":{"text":"Lightning Web Components","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/lightning-web-components\/"},"img":{"alt_text":"Salesforce Lightning Datatable Infinite Scrolling","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2020\/06\/Salesforce-Lightning-Datatable-Infinite-Scrolling-e1624579111169.png?fit=700%2C385&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2020\/06\/Salesforce-Lightning-Datatable-Infinite-Scrolling-e1624579111169.png?fit=700%2C385&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2020\/06\/Salesforce-Lightning-Datatable-Infinite-Scrolling-e1624579111169.png?fit=700%2C385&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2020\/06\/Salesforce-Lightning-Datatable-Infinite-Scrolling-e1624579111169.png?fit=700%2C385&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":191,"url":"https:\/\/www.jitendrazaa.com\/blog\/microsoft\/net\/datagrid-example-part-1\/","url_meta":{"origin":227,"position":3},"title":"DataGrid Example – Part 1","author":"Jitendra","date":"May 18, 2010","format":false,"excerpt":"For the basics of DataGrid please refer this post: https:\/\/jitendrazaa.com\/blog\/?p=188 In this example, i will explain the basics of DataGrid control like Theming, Databinding etc. We will start our example with creating the SQL Express database of Employee which will contain the following fields : Id, FName, LName, Email. Now\u2026","rel":"","context":"In "ASP.NET"","block_context":{"text":"ASP.NET","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/microsoft\/net\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2010\/05\/Employee.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":467,"url":"https:\/\/www.jitendrazaa.com\/blog\/microsoft\/net\/telerik-radschedular-tips-and-tricks\/","url_meta":{"origin":227,"position":4},"title":"Telerik RadSchedular Tips and Tricks","author":"Jitendra","date":"July 1, 2010","format":false,"excerpt":"Change the style of the Today Cell in Month View and Bind Extra Column \/ Add Argument in RadSchedular","rel":"","context":"In "ASP.NET"","block_context":{"text":"ASP.NET","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/microsoft\/net\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1178,"url":"https:\/\/www.jitendrazaa.com\/blog\/microsoft\/net\/datagrid-gridview-datalist-and-repeater-control-in-asp-net\/","url_meta":{"origin":227,"position":5},"title":"DataGrid, GridView, DataList and Repeater Control in ASP.net","author":"Jitendra","date":"October 1, 2010","format":false,"excerpt":"DataGrid, GridView, DataList and Repeater Control in ASP.net","rel":"","context":"In "ASP.NET"","block_context":{"text":"ASP.NET","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/microsoft\/net\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/227","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/comments?post=227"}],"version-history":[{"count":0,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/227\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/media?parent=227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/categories?post=227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/tags?post=227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}