Aspxgridview Filter

Uncheck the checkbox to immediately disable and the filter and re-check to the checkbox to re-enable the filter. I do not know which assembly causes this mail function, Devart or DevExpress. net - ASPxGridView. This example illustrates how to filter a grid using the outside text box. Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to filter GridView records using TextBox in ASP. Another cool feature is the new filter feature. Filter Data Using Label Filters Label filters come in handy when you have a huge list and you want to filter specific items based on its name/text. You probably won't be surprised that the ASPxGridView supports a lot of other features, such as grid nesting. You can activate the Filter Control by clicking the image or filter expression link contained in. ActiveFilter object. The server-side query builder (QueryBuilder) will accept a query description, create and run an XPath query, optionally filter the result set, and also extract facets, if desired. To apply a filter to a particular column, perform a callback to the grid and call an instance of the AutoFilterBy method. that the user can fill out to filter the results. The filter condition selects records which contain the values "Produce" or "Seafood" in the CategoryName column. The following will allow the disabling/hiding of an edit button on an AspxGridview based on the value in one of the fields. Use the ASPxGridViewBehaviorSettings. Let's filter it by name or address or mobile, I am trying filter records by name by typing just 'o' in text box. The problem: the AspxGridView. How to: Bind the ASPxGridView to Data Created at Runtime (DataTable) This example demonstrates how you can programmatically create a DataTable and then bind a grid control to it. Using the New ASPxGridView Filter Feature. FilterExpression. Filter and RecordCount Properties Example (VB) 01/19/2017; 2 minutes to read; In this article. I came across this requirement of having a gridview which allows filtering data from within the gridview. What I'm trying to do is that copying selected rows in the first gridview to the second gridview. Built for web applications that require ad-hoc query capabilities, the DevExpress ASP. FilterExpression property). This example illustrates how to filter a grid using the outside text box. In this lesson, you will learn how to create and customize a custom command button at design-time. When I filter an ASPxGridView decimal column the filtering expression is not interpreted correctly. The ASPxGridView is designed to support nesting, the power of Ajax callbacks, tuned performance for small and huge data sets, sorting, grouping, creating summaries, working with themes and skins, and much more. Please provide suggessions. zip; Check out live demo! Introduction. the baton off to the ASPxGridView. Regards VeerendraNadh. According to some laws of various states, a certain amount of reflective orange will be required, such as Texas. This blog will cover ASPxGridView's Main Features and a breakdown of the awesome things those features allow you to do. This makes it possible for you…. To help you explore, I have included several graphics and some code that show you how to use the new filter feature, grid sorting, and grouping, and how to use the XPO Persistent Classes to help you generate your custom entity classes. Now, you have a populated grid and are free to view, edit and filter through it. Make drop down list allowing free text in Excel. There filter parameters should come from the FilterRow of the AspxGridView (preferably using the AspxGridView. Hi to all of you who came in this place searching some info about programming. Built for web applications that require ad-hoc query capabilities, the DevExpress ASP. DevExpress AspxGridView filter in ObjectDataSource as seen on Stack Overflow - Search for 'Stack Overflow' Yet another problem with DevExpress AspxGridView :) The context: One Page In the Page, a custom control In the custom Control, a AspxDropDown The AspxDropDown, has a DropDownWindowTemplate In the DropDownItemTemplate, I add a GridView and. Check out this slick Code Central sample that shows you how to add a multiple selection header filter to the. ASPxGridView Main Features Part I The Data Specifics of ASPxGridView comprises the following parts: unbound columns, server-side data management and master detail support. To display the Filter Row at the top of the ASPxGridView, set the ASPxGridViewSettings. Filter and RecordCount Properties Example (VB) 01/19/2017; 2 minutes to read; In this article. ASPxGridView - How to apply a filter to a column on the server side. It is quite easy to add a comboBox to a filter column in the ASPXGridView. The comboBox only allows a single filter. There are several methods for achieving the same result. Titan's Stocking Distributors and Suppliers. For example, I use the filter [Value]>20, but all the values greater then 3. Angular Forms are a great way to encompass a logic unit of data — something you can submit to the backend for further processing, saving etc. If you missed my previous article you can get it here: ASPxGridView Excel style – Adding notes to grid cells. If you are interested in more you can check this Grid Editing - Edit Modes A rich set of editors for different column types allows column values to be modified with ease. Deprecated: Function create_function() is deprecated in /www/wwwroot/autobreeding. I used the DevExpress ASP. The new filter feature shows up as a link at the bottom of the grid when enabled and pops up a dialog that lets you pick options based on the intuitive operators, field names from the data's schema, and even shows the "correct" user control based on the field's data type. In this snippet, it checks to see if the. the baton off to the ASPxGridView. ASPxGridView master-detail data presentation with context menus Introduction As many companies I worked for are using DevExpress controls I decided to write a couple of posts about some real life situations and ways they can be solved by using DevExpress ASP. The comboBox only allows a single filter. All its properties are set as read-only. NET filter control for the ASPxGridView. C# (CSharp) ASPxGridView - 30 examples found. I have a web page with a GridView control populated from a database. Featured on Meta Congratulations to our 29 oldest beta sites - They're now no longer beta!. NET Time Editor This. ASPxGridView master-detail data presentation with context menus Introduction As many companies I worked for are using DevExpress controls I decided to write a couple of posts about some real life situations and ways they can be solved by using DevExpress ASP. In this blog post I will show you how to do very, I mean very fast export of Your data from AspxGridView to Excel spreadsheet ( or PDF or CSV or RTF file type ). These are the top rated real world C# (CSharp) examples of ASPxGridView extracted from open source projects. I do not know which assembly causes this mail function, Devart or DevExpress. net , C# , comboBox , DevExpress and tagged checkBox comboBox on August 27, 2013 by Robert Kosko. How to implement an external filter for the ASPxGridView (ASPxGridView binds via its callback) UPDATED: Starting with version 14. In this very first post I will explore the most used ASP. See also: ASPxGridView - How to filter the grid using the outside combo box ASPxGridView - How to apply a filter to a column on the client side. The comboBox only allows a single filter. I have a web page with a GridView control populated from a database. It is quite easy to add a comboBox to a filter column in the ASPXGridView. iBasskung 11,345,886 views. One of the most popular web controls is Devexpress' ASPxGridView. The filter row allows end-users to filter data by entering text within its cells. Uncheck the checkbox to immediately disable and the filter and re-check to the checkbox to re-enable the filter. To display the Filter Row at the top of the ASPxGridView, set the ASPxGridViewSettings. Here is my output. Using the New ASPxGridView Filter Feature. I have been using JQuery for a couple of years now and it has helped me to solve many problems on the client side of web development. To display the Filter Row at the top of the ASPxGridView, set the ASPxGridViewSettings. The filter condition selects records which contain the values "Produce" or "Seafood" in the CategoryName column. What I'm trying to do is that copying selected rows in the first gridview to the second gridview. To apply a filter to a particular column, perform a callback to the grid and call an instance of the AutoFilterBy method. The Filter Row allows end-users to filter grid data by typing text directly into the row. ActiveFilter object. Comments Please. Editing the ASPxGridView is very easy. FilterExpression property). It is quite easy to add a comboBox to a filter column in the ASPXGridView. In the same way, you can try by address or mobile as well. Filter and RecordCount Properties Example (VB) 01/19/2017; 2 minutes to read; In this article. Clicking the filter will re-open the filter builder dialog. The server-side query builder (QueryBuilder) will accept a query description, create and run an XPath query, optionally filter the result set, and also extract facets, if desired. Net DevExpress control. NET Grid - How to Create Custom Command Buttons In addition to custom themes and cell templates, the ASPxGridView allows you to customize the grids default buttons to perform different actions based on you and your customers needs. I wonder that the issue is not so big, and it will start again. ASPxGridView - External filter External Filter for GridView P. You can rate examples to help us improve the quality of examples. The filter condition selects records which contain the values "Produce" or "Seafood" in the CategoryName column. ASPxGridView [X] Remove ASPxGridView filter ; Enter terms Release Notes: Updates in v2009 vol 3 New ASP. To display the Filter Row at the top of the ASPxGridView, set the ASPxGridViewSettings. Comments Please. NET Grid View (ASPxGridView) Filter Control allows end-users to build complex filter criteria with an unlimited number of filter conditions and logical operators. All its properties are set as read-only. You can activate the Filter Control by clicking the image or filter expression link contained in. Editing the ASPxGridView is very easy. Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to filter GridView records using TextBox in ASP. This entry was posted in Asp. ASPxGridView master-detail data presentation with context menus Introduction As many companies I worked for are using DevExpress controls I decided to write a couple of posts about some real life situations and ways they can be solved by using DevExpress ASP. NET Grid – How to Create Custom Command Buttons In addition to custom themes and cell templates, the ASPxGridView allows you to customize the grids default buttons to perform different actions based on you and your customers needs. Featured on Meta Congratulations to our 29 oldest beta sites - They're now no longer beta!. Filter Data Using Label Filters Label filters come in handy when you have a huge list and you want to filter specific items based on its name/text. DevExpress AspxGridView Filter In ObjectDataSource Mar 16, 2010. I have a ASPxGridView component that is filled from a SQL query I wanted to apply a filter on my ASPX Gridview so I wrote: Devexpress Gridview Filter Control. The Filter Row allows end-users to filter grid data by typing text directly into the row. To help you explore, I have included several graphics and some code that show you how to use the new filter feature, grid sorting, and grouping, and how to use the XPO Persistent Classes to help you generate your custom entity classes. This makes it possible for you…. 00 are show. the baton off to the ASPxGridView. The link will include a preceding checkbox. The problem: the AspxGridView. Education-related costs. The comboBox only allows a single filter. Filter and RecordCount Properties Example (VB) 01/19/2017; 2 minutes to read; In this article. NET Grid View (ASPxGridView) provides a number of easy-to-use data filtering options. Filter Data Using Label Filters Label filters come in handy when you have a huge list and you want to filter specific items based on its name/text. Make drop down list allowing free text in Excel. I hope you like it. This entry was posted in Asp. It adds the rows without values with the code below. 2, GridView provides the built-in. NET GridView Filtering with DropDownList Display filtered subsets of data in the GridView control using DropDownList embedded in GridView column HeaderTemplate. The DXperience 2008 Volume 3 release is now available for download. On some reports I may want to Fit Sheet to one Page, others I might want to Fit all Co. Here Mudassar Ahmed Khan has explained with an example and attached sample code, how to filter GridView records using TextBox in ASP. I used the DevExpress ASP. Net DevExpress control. In this snippet, it checks to see if the. ASPxGridView - How to apply a filter to a column on the server side. Built for web applications that require ad-hoc query capabilities, the DevExpress ASP. Now, you have a populated grid and are free to view, edit and filter through it. that the user can fill out to filter the results. The ASPxGridView is designed to support nesting, the power of Ajax callbacks, tuned performance for small and huge data sets, sorting, grouping, creating summaries, working with themes and skins, and much more. The problem: the AspxGridView. This video walks you through some of the basics of the DevExpress ASPxGridView. FilterExpression property). What I'm trying to do is that copying selected rows in the first gridview to the second gridview. But what happens if you need multiple filtering in the same column. The issue with the client-side memory leaks and performance has been resolved in version v2010 vol 2. The new filter feature shows up as a link at the bottom of the grid when enabled and pops up a dialog that lets you pick options based on the intuitive operators, field names from the data's schema, and even shows the "correct" user control based on the field's data type. I want to have a form that users can use to filter the results presented in the GridView. Hi All, this is my first post in this forum, so I'd like to start with a big thank you for the great work on primefaces you did so far! Ok,. NET Grid View (ASPxGridView) provides a number of easy-to-use data filtering options. Hi to all of you who came in this place searching some info about programming. The following will allow the disabling/hiding of an edit button on an AspxGridview based on the value in one of the fields. The comboBox only allows a single filter. The DevExpress ASP. 2 (ASPxGridView - Client-side memory leaks when the Auto Filter Row is used or Edit Form is displayed). I recommend that you use the approach from the How to emulate ASPxGridView command button functionality code example to create custom command buttons and apply Bootstrap theming to them as described in the ASPxGridView - Bootstrap icons ticket. Watch the "Mastering ASP. ASPxGridView [X] Remove ASPxGridView filter ; Enter terms Release Notes: Updates in v2009 vol 3 New ASP. The DXperience 2008 Volume 3 release is now available for download. DevExpress AspxGridView filter in ObjectDataSource as seen on Stack Overflow - Search for 'Stack Overflow' Yet another problem with DevExpress AspxGridView :) The context: One Page In the Page, a custom control In the custom Control, a AspxDropDown The AspxDropDown, has a DropDownWindowTemplate In the DropDownItemTemplate, I add a GridView and. With the above setup, your grid should now filter based on the drop-down when a user selects a new item. ShowHeaderFilterButton property to true. Comments Please. The ASPxGridView is designed to support nesting, the power of Ajax callbacks, tuned performance for small and huge data sets, sorting, grouping, creating summaries, working with themes and skins, and much more. Use the ASPxGridViewBehaviorSettings. 00 are show. 6m developers to have your questions answered on How to get selected rows column value/s ? of UI for WPF GridView. ASPxGridView master-detail data presentation with context menus Introduction As many companies I worked for are using DevExpress controls I decided to write a couple of posts about some real life situations and ways they can be solved by using DevExpress ASP. This behavior occurs just when we set the filtering criteria through the grid.  …. It is quite easy to add a comboBox to a filter column in the ASPXGridView. NET Time Editor This. This chapter and the next chapter explore the ASPxGridView. Watch the "Mastering ASP. Dropdown sorting and filtering using Jquery Here i'm going to give you an tutorial about select option dropdown filter using Jquery with isotope. The DXperience 2008 Volume 3 release is now available for download. I do not know which assembly causes this mail function, Devart or DevExpress. Check out this slick Code Central sample that shows you how to add a multiple selection header filter to the. I use dotconnect 5. 2 (ASPxGridView - Client-side memory leaks when the Auto Filter Row is used or Edit Form is displayed). Filter and RecordCount Properties Example (VB) 01/19/2017; 2 minutes to read; In this article. Adblock Plus recently updated itself (it opened the "Adblock Plus has been installed" tab), and since then it has not been saving filter lists (subscriptions) nor manually entered filters ("add your own filters") between Chrome session. I have a web page with a GridView control populated from a database. ActiveFilter object. Recently, while working on one of the company's web based projects, I needed to display filtered subsets of the data in the GridView control. The DevExpress solution creates a new class called DataTemplate which gets the data from the database and builds a list box. The server-side query builder (QueryBuilder) will accept a query description, create and run an XPath query, optionally filter the result set, and also extract facets, if desired. DevExpress AspxGridView Filter In ObjectDataSource Mar 16, 2010. To apply a filter to a particular column, perform a callback to the grid and call an instance of the AutoFilterBy method. Editing the ASPxGridView is very easy. When handling the selecting event of the ObjectDataSource, I should set filter parameters for the datasource. DataGridView BindingSource Filter Part 1/2 - Duration: 24:59. Apply Default Filter on Initial Load. thanks for your feedback!. The DevExpress ASP. FilterRowMode property to specify the Filter Row mode:. This video walks you through some of the basics of the DevExpress ASPxGridView. Uncheck the checkbox to immediately disable and the filter and re-check to the checkbox to re-enable the filter. ASPxGridView - How to apply a filter to a column on the server side. NET GridView: Filtering and Multiple Checkboxes" webinar and learn how-to add this easily the ASPxGridView. It adds the rows without values with the code below. Another cool feature is the new filter feature. This chapter and the next chapter explore the ASPxGridView. DevExpress is a company made up of developers with a rich understanding and deep appreciation for a diverse set of technologies, from Windows Forms (WinForms. Net controls. Make drop down list allowing free text in Excel. The Export row type combo box controls the ExportSelectedRowsOnly property value and specifies whether all rows displayed within the ASPxGridView are exported (or only selected rows). Is there an elegant way of doing this?. To specify the initial filter, set the FilterExpression property of the MasterTableView (or detail GridTableView). This video walks you through some of the basics of the DevExpress ASPxGridView. With the above setup, your grid should now filter based on the drop-down when a user selects a new item. This blog will cover ASPxGridView's Main Features and a breakdown of the awesome things those features allow you to do. Apply Default Filter on Initial Load. The DevExpress ASP. You can rate examples to help us improve the quality of examples. ActiveFilter object. To apply a filter to a particular column, perform a callback to the grid and call an instance of the AutoFilterBy method. To apply a filter to a particular column, perform a callback to the grid and call an instance of the AutoFilterBy method. The DevExpress ASPxGridView comes with several Built-in Customizable Edit Modes. I have sorted by a column in ascending only. DevExpress AspxGridView filter in ObjectDataSource as seen on Stack Overflow - Search for 'Stack Overflow' Yet another problem with DevExpress AspxGridView :) The context: One Page In the Page, a custom control In the custom Control, a AspxDropDown The AspxDropDown, has a DropDownWindowTemplate In the DropDownItemTemplate, I add a GridView and. NET filter control for the ASPxGridView. I have two gridviews on my page. Net DevExpress control. Devexpress ASPxGridView GetSelectedFieldValues Can't get values. 00 are show. 2, GridView provides the built-in. Filter Data Using Label Filters Label filters come in handy when you have a huge list and you want to filter specific items based on its name/text. In this very first post I will explore the most used ASP. The filter condition selects records which contain the values "Produce" or "Seafood" in the CategoryName column. Hi to all of you who came in this place searching some info about programming. The following code shows how to add a filter condition to a View via its ColumnView. How to implement an external filter for the ASPxGridView (ASPxGridView binds via its callback) UPDATED: Starting with version 14. This example illustrates how to filter a grid using the outside text box. ASPxGridView [X] Remove ASPxGridView filter ; Enter terms Release Notes: Updates in v2009 vol 3 New ASP. 6m developers to have your questions answered on How to get selected rows column value/s ? of UI for WPF GridView. How to implement an external filter for the ASPxGridView (ASPxGridView binds via its callback) UPDATED: Starting with version 14. I have a devexpress ASPxGridView linked to a LLBLGenProDataSource2 datasource. Recently, while working on one of the company's web based projects, I needed to display filtered subsets of the data in the GridView control. With the above setup, your grid should now filter based on the drop-down when a user selects a new item. Using the New ASPxGridView Filter Feature. Still there are a couple of tricks that we will see in the following lines. Adblock Plus recently updated itself (it opened the "Adblock Plus has been installed" tab), and since then it has not been saving filter lists (subscriptions) nor manually entered filters ("add your own filters") between Chrome session. In this video, you will learn how to handle the CustomColumnDisplayText event of the grid control to replace the "0" with the text "Empty". Check out this slick Code Central sample that shows you how to add a multiple selection header filter to the. iBasskung 11,345,886 views. Use the ASPxGridViewBehaviorSettings. I have been using JQuery for a couple of years now and it has helped me to solve many problems on the client side of web development. To show filter buttons, set the Settings. Deprecated: Function create_function() is deprecated in /www/wwwroot/autobreeding. Angular Forms are a great way to encompass a logic unit of data — something you can submit to the backend for further processing, saving etc. toolbar asp. Here is my output. In this snippet, it checks to see if the. I used the DevExpress ASP. Make drop down list allowing free text in Excel. I use dotconnect 5. Net controls and I would like to present you with some hands-on examples on how to use these ASP. NET Time Editor This. You can set the initial filter for a RadGrid control so that when the Web page is first loaded, it presents an already-filtered set of data. ActiveFilter object. iBasskung 11,345,886 views. Check out this slick Code Central sample that shows you how to add a multiple selection header filter to the. Clicking the filter will re-open the filter builder dialog. The DevExpress ASPxGridView comes with several Built-in Customizable Edit Modes. NET filter control for the ASPxGridView. Make drop down list allowing free text in Excel. Let's filter it by name or address or mobile, I am trying filter records by name by typing just 'o' in text box. Use the ASPxGridViewBehaviorSettings. I have a devexpress ASPxGridView linked to a LLBLGenProDataSource2 datasource. You can activate the Filter Control by clicking the image or filter expression link contained in. It is quite easy to add a comboBox to a filter column in the ASPXGridView. net , C# , comboBox , DevExpress and tagged checkBox comboBox on August 27, 2013 by Robert Kosko. net - ASPxGridView. In this lesson, you will learn how to create and customize a custom command button at design-time. I do not know which assembly causes this mail function, Devart or DevExpress. NET Time Editor This. This video walks you through some of the basics of the DevExpress ASPxGridView. NET Time Editor This. These are the top rated real world C# (CSharp) examples of ASPxGridView extracted from open source projects. NET filter control for the ASPxGridView. DevExpress AspxGridView filter in ObjectDataSource as seen on Stack Overflow - Search for 'Stack Overflow' Yet another problem with DevExpress AspxGridView :) The context: One Page In the Page, a custom control In the custom Control, a AspxDropDown The AspxDropDown, has a DropDownWindowTemplate In the DropDownItemTemplate, I add a GridView and. Net GridView control. FilterExpression property is not set to the proper values (set by. FilterRowMode property to specify the Filter Row mode:. that the user can fill out to filter the results. If you missed my previous article you can get it here: ASPxGridView Excel style – Adding notes to grid cells. DataGridView BindingSource Filter Part 1/2 - Duration: 24:59. Adblock Plus recently updated itself (it opened the "Adblock Plus has been installed" tab), and since then it has not been saving filter lists (subscriptions) nor manually entered filters ("add your own filters") between Chrome session. For example, it might have fields for last name, first name, department, wages, date of hire, etc. When you use a complex LINQ query, the result that is returned from the Linq-To-Sql is a projection that can't be edited. Watch the "Mastering ASP. To accomplish the task I have made use of SqlDataSource with FilterExpression along with FilterParameters to filter records and bind the ASP. You can activate the Filter Control by clicking the image or filter expression link contained in. These are the top rated real world C# (CSharp) examples of ASPxGridView extracted from open source projects. I used the DevExpress ASP. The server-side query builder (QueryBuilder) will accept a query description, create and run an XPath query, optionally filter the result set, and also extract facets, if desired. Filter and RecordCount Properties Example (VB) 01/19/2017; 2 minutes to read; In this article. The problem: the AspxGridView. Devexpress ASPxGridView GetSelectedFieldValues Can't get values. and set the dataSource filter based on the selected customerId. thanks for your feedback!. 00 are show. In the same way, you can try by address or mobile as well. Net GridView control. Now, you have a populated grid and are free to view, edit and filter through it. Hi to all of you who came in this place searching some info about programming. Adblock Plus recently updated itself (it opened the "Adblock Plus has been installed" tab), and since then it has not been saving filter lists (subscriptions) nor manually entered filters ("add your own filters") between Chrome session. There filter parameters should come from the FilterRow of the AspxGridView (preferably using the AspxGridView. php on line 143 Deprecated: Function create_function() is deprecated. FilterRowMode property to specify the Filter Row mode:. It will filter all names contain character 'o'. One Page In the Page, a custom control In the custom Control, a AspxDropDown The AspxDropDown, has a DropDownWindowTemplate In the DropDownItemTemplate, I add a GridView and a paging/sorting/filtering enabled ObjectDataSource When handling the Selecting event of the ObjectDataSource, I should set filter parameters for the datasource. In this very first post I will explore the most used ASP. I used the DevExpress ASP. Net GridView control. I recommend that you use the approach from the How to emulate ASPxGridView command button functionality code example to create custom command buttons and apply Bootstrap theming to them as described in the ASPxGridView - Bootstrap icons ticket. 39 and DXperience 9. Net controls. When handling the selecting event of the ObjectDataSource, I should set filter parameters for the datasource. NET Time Editor This. It adds the rows without values with the code below. The new filter feature shows up as a link at the bottom of the grid when enabled and pops up a dialog that lets you pick options based on the intuitive operators, field names from the data's schema, and even shows the "correct" user control based on the field's data type. See also: ASPxGridView - How to filter the grid using the outside combo box. You can rate examples to help us improve the quality of examples. ASPxGridView Main Features Part I The Data Specifics of ASPxGridView comprises the following parts: unbound columns, server-side data management and master detail support. See also: ASPxGridView - How to filter the grid using the outside combo box ASPxGridView - How to apply a filter to a column on the client side. 2, GridView provides the built-in. When handling the selecting event of the ObjectDataSource, I should set filter parameters for the datasource. Uncheck the checkbox to immediately disable and the filter and re-check to the checkbox to re-enable the filter. php on line 143 Deprecated: Function create_function() is deprecated. In the same way, you can try by address or mobile as well. This makes it possible for you…. NET and in ASPxGridView I'm unable to retrieve columns. To display the Filter Row at the top of the ASPxGridView, set the ASPxGridViewSettings. In this very first post I will explore the most used ASP. Net GridView control. The ASPxGridView allows you to create custom filter values, define a filter criteria for them and display these values within a column's filter dropdown. Browse other questions tagged filter devexpress controls aspxgridview or ask your own question.