Dinesh Ambaliya

Dinesh Ambaliya

  • NA
  • 42
  • 80k

How to customize GridView's paging to select records month wise

Jul 9 2012 2:35 AM
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.

Answers (1)