Current filter:
                                You should refresh the page.
                                Support Center
                                0
                                  • 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');
                                    and
                                    gridView1.RowFilter("FIRST_NAME <> 'John');
                                    but nothing worked.
                                    Kindly help me in solving this issue.

                                    Regards
                                    Gunasekaran Eswaran

                                0

                                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,
                                Paul

                                If you need additional product information, write to us at info@devexpress.com 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, Silverlight, ASP.NET, WinForms, HTML5 or Windows 8, DevExpress tools help you build and deliver your best in the shortest time possible.

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