{"id":608,"date":"2010-07-07T12:51:47","date_gmt":"2010-07-07T07:21:47","guid":{"rendered":"http:\/\/JitendraZaa.com\/blog\/?p=608"},"modified":"2010-07-07T12:51:47","modified_gmt":"2010-07-07T07:21:47","slug":"selecting-and-sorting-in-datatable-asp-net-c","status":"publish","type":"post","link":"https:\/\/www.jitendrazaa.com\/blog\/microsoft\/net\/selecting-and-sorting-in-datatable-asp-net-c\/","title":{"rendered":"Selecting and Sorting in DataTable – ASP.net C#"},"content":{"rendered":"

DataTable in C# have very reach features to store the data in Tabular forms and also to display sorted or selected data on predefined category. Below i have provided the source code which demonstrates that how to select and sort the Datatable in ASP.Net.<\/p>\n

\"Sorting<\/a><\/p>\n

below is the snap of C# File:<\/p>\n

\n public partial class _Default : System.Web.UI.Page\n    {\n        protected void Page_Load(object sender, EventArgs e)\n        {\n            DataTable dt = prepareTable();\n            GridView1.DataSource = dt;\n            GridView1.DataBind();\n\n            dt.DefaultView.Sort = "DOB ASC";\n            GridView2.DataSource = dt;\n            GridView2.DataBind();\n\n            dt.DefaultView.Sort = "Age DESC";\n            GridView3.DataSource = dt;\n            GridView3.DataBind();\n\n            dt.DefaultView.Sort = "Id DESC, Age ASC";\n            GridView4.DataSource = dt;\n            GridView4.DataBind();\n\n            DataRow[] dtRows = dt.Select("Age > 20", "Age ASC");\n            DataTable dt1 = new DataTable();\n            dt1.Columns.Add("Id", typeof(int));\n            dt1.Columns.Add("Name", typeof(string));\n            dt1.Columns.Add("Age", typeof(int));\n            dt1.Columns.Add("DOB", typeof(DateTime));\n\n            foreach (DataRow dr in dtRows)\n            {\n                dt1.Rows.Add(dr[0], dr[1], dr[2],dr[3]);\n            }\n\n            GridView5.DataSource = dt1;\n            GridView5.DataBind();\n        }\n\n        \/\/\/ <summary>\n        \/\/\/ Prepares the table for Data.\n        \/\/\/ <\/summary>\n        \/\/\/ <returns><\/returns>\n        private DataTable prepareTable()\n        {\n            DataTable rs = new DataTable();\n            rs.Columns.Add("Id", typeof(int));\n            rs.Columns.Add("Name", typeof(string));\n            rs.Columns.Add("Age", typeof(int));\n            rs.Columns.Add("DOB", typeof(DateTime));\n\n            AddItems(rs,1,"Tuiya",24,DateTime.Now.AddYears(-20));\n            AddItems(rs, 2, "Sonu", 20, DateTime.Now.AddYears(-21));\n            AddItems(rs, 4, "Rohan", 19, DateTime.Now.AddYears(-22));\n            AddItems(rs, 4, "Manoranjan", 27, DateTime.Now.AddYears(-23));\n            AddItems(rs, 1, "Santosh", 24, DateTime.Now.AddYears(-20));\n\n            return rs;\n        }\n\n        \/\/\/ <summary>\n        \/\/\/ Adds the items.\n        \/\/\/ <\/summary>\n        \/\/\/ <param name="rs">The DataTable.<\/param>\n        \/\/\/ <param name="id">The id.<\/param>\n        \/\/\/ <param name="name">The name.<\/param>\n        \/\/\/ <param name="age">The age.<\/param>\n        \/\/\/ <param name="dob">The dob.<\/param>\n        private static void AddItems(DataTable rs,int id,string name,int age,DateTime dob)\n        {\n            DataRow dtRow = rs.NewRow();\n            dtRow[0] = id;\n            dtRow[1] = name;\n            dtRow[2] = age;\n            dtRow[3] = dob;\n            rs.Rows.Add(dtRow);\n        }\n    }\n<\/pre>\n
Working Demo of DataTable<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"
Demonstrates that how to select and sort the Datatable in ASP.Net , C#<\/p>\n","protected":false},"author":1,"featured_media":0,"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],"class_list":["post-608","post","type-post","status-publish","format-standard","hentry","category-net","tag-asp-net"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":227,"url":"https:\/\/www.jitendrazaa.com\/blog\/microsoft\/net\/datagrid-example-sorting-part-2\/","url_meta":{"origin":608,"position":0},"title":"DataGrid Sorting and Paging Example \u2013 Part 2","author":"Jitendra","date":"May 18, 2010","format":false,"excerpt":"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\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\/Sorting1.jpg?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":608,"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":467,"url":"https:\/\/www.jitendrazaa.com\/blog\/microsoft\/net\/telerik-radschedular-tips-and-tricks\/","url_meta":{"origin":608,"position":2},"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":1527,"url":"https:\/\/www.jitendrazaa.com\/blog\/microsoft\/net\/ajax-based-multiselect-jquery-autocomplete-control-in-asp-net\/","url_meta":{"origin":608,"position":3},"title":"Ajax Based Multiselect JQuery Autocomplete Control in ASP.Net","author":"Jitendra","date":"February 19, 2011","format":false,"excerpt":"Tutorial on creating Ajax Based Multiselect JQuery Autocomplete User 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":"Ajax Based Multiselect JQuery Autocomplete Control in ASP.Net","src":"https:\/\/i0.wp.com\/jitendrazaa.com\/blog\/wp-content\/uploads\/2011\/02\/Ajax-Based-Multiselect-JQuery-Autocomplete-Control-in-ASP.Net_.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":7101,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/implement-infinite-scrolling-for-lightning-data-table\/","url_meta":{"origin":608,"position":4},"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":6419,"url":"https:\/\/www.jitendrazaa.com\/blog\/salesforce\/introduction-to-lightning-test-services-with-jasmine\/","url_meta":{"origin":608,"position":5},"title":"Introduction to Lightning Test Services with Jasmine","author":"Jitendra","date":"March 10, 2018","format":false,"excerpt":"Complete Source code and video of using Lightning Datatable Component and Jasmine in Salesforce","rel":"","context":"In "Salesforce"","block_context":{"text":"Salesforce","link":"https:\/\/www.jitendrazaa.com\/blog\/category\/salesforce\/"},"img":{"alt_text":"Lightning Testing Service (LTS)","src":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2018\/03\/Lightning-Testing-Service-LTS.png?fit=1200%2C433&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2018\/03\/Lightning-Testing-Service-LTS.png?fit=1200%2C433&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2018\/03\/Lightning-Testing-Service-LTS.png?fit=1200%2C433&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2018\/03\/Lightning-Testing-Service-LTS.png?fit=1200%2C433&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.jitendrazaa.com\/blog\/wp-content\/uploads\/2018\/03\/Lightning-Testing-Service-LTS.png?fit=1200%2C433&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/608","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=608"}],"version-history":[{"count":0,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/posts\/608\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/media?parent=608"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/categories?post=608"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jitendrazaa.com\/blog\/wp-json\/wp\/v2\/tags?post=608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}