[Solved] Global search/Spotlight search on several fields of a table

[Julien]

Hi,

I would like to know how to create an "autocomplete" textbox in the asp.net mvc grid, allowing to do a search on all fields of an object(even non displayed columns).

I saw that: http://demos.telerik.com/aspnet-mvc/grid/customtoolbar?theme=simple But it seems to be only possible to make the search on one field.

Thank you!

[Atanas Korchev]

Hello Julien,

 You can use this example as a start and then in your controller filter the data based on what the user has typed:

        function dataBinding(args) {
            var text= $("#Customers").data("tAutoComplete").value();
            args.data = $.extend(args.data, { text: text});
        }

        [GridAction]
        public ActionResult _CustomToolBar(string text)
        {
            IEnumerable<Order> orders = GetOrders();
            var result = from o in orders
                         where o.Property1 == text || o.Property2 == text
                         select o;

            return View(new GridModel(result));
        }

I hope this helps,
Atanas Korchev
the Telerik team