Current filter:
                                You should refresh the page.
                                Support Center
                                  • Hi,
                                    I need to know is there any way to filter the values in the datatable that doesnot have values equal to that of a given value.
                                    For Example,
                                    let us consider that i should get rows that donot have firstname us 'John'. How could we acheive this using rowfilter.

                                    I tried
                                    gridView1.RowFilter("FIRST_NAME NOT LIKE 'John');
                                    gridView1.RowFilter("FIRST_NAME <> 'John');
                                    but nothing worked.
                                    Kindly help me in solving this issue.

                                    Gunasekaran Eswaran


                                Hello Gunasekaran,

                                Assuming that FIRST_NAME is the name of the underlying grid column field, the code that implements the desired filter is:
                                gridView1.ActiveFilter.Add(gridView1.Columns["FIRST_NAME"], new ColumnFilterInfo("[FIRST_NAME]<>'John'",""));

                                Thank you,

                                If you need additional product information, write to us at or call us at +1 (818) 844-3383

                                FOLLOW US

                                DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, along with high-performance HTML JS Mobile Frameworks for developers targeting iOS, Android and Windows Phone. Whether using WPF, ASP.NET, WinForms, HTML5 or Windows 10, DevExpress tools help you build and deliver your best in the shortest time possible.

                                Copyright © 1998-2017 Developer Express Inc.
                                All trademarks or registered trademarks are property of their respective owners