How to customize GridView's paging to select records month wise
I have created a GridView and binded it using dataTable which is filled by SqlDataAdapter. I have also created a table in sql server 2005 which contains a column named 'Calls_Date' which has data type of 'DateTime'.
I have also set the AllowPaging property to true and PagerSettings-Position to bottom. Now I want to display month wise records in grid view. I want to display January to December months not 1,2,3... in pager links . If user select 'March' month pager link then only records will be selected which has March month in 'Calls_Date' column.