We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

DataManager Search

Thread ID:





118425 Mar 7,2015 01:08 AM UTC Mar 10,2015 05:06 PM UTC ASP.NET MVC 3
Tags: Grid
Sidnei V Lavandoski
Asked On March 7, 2015 01:08 AM UTC

I´m using Entity Framework 6 and I have a table with 2000 > rows.

The Grid component doesn´t have OnDemand option yet, then looking for in this forum I found the solution using DataManager (post http://www.syncfusion.com/forums/118301/grid-performance-in-ie)

Meanwhile, I would like to use search instead filtering, then I change the code like this:

//Provide grid datasource
        public ActionResult GetOrderData(DataManager dm)
            RuasModel ruas = new RuasModel();
            IEnumerable data = ruas.ListaRuas();
            int count = ruas.ListaRuas().Count;

            DataOperations operation = new DataOperations();
            //Performing filtering operation
            if (dm.Where != null)
                data = operation.PerformWhereFilter(data, dm.Where, "and");
                var filtered = (IEnumerable<object>)data;
                count = filtered.Count();

            if (dm.Search != null)
                data = operation.PerformSearching(data, dm.Search);


            //Performing sorting operation
            if (dm.Sorted != null)
                data = operation.PerformSorting(data, dm.Sorted);

            //Performing paging operations
            data = operation.PerformSkip(data, dm.Skip);
            data = operation.PerformTake(data, dm.Take);

            return Json(new { result = data, count = count }, JsonRequestBehavior.AllowGet);


but when make a search the data object always returns null. Using the Visual Studio debug, the dm.Search is not null.

Is there a option to do this?

Thank you

Prasanna Kumar Viswanathan [Syncfusion]
Replied On March 9, 2015 12:09 PM UTC

Hi Sidnei,

Sorry about the inconvenience caused.

We created a sample using IEnumerable data and performing Datamanager operations. We afraid that we were unable to reproduce the issue at run time. Did the object returns null only for string values or all values? Because the searching is case sensitive for string values.

Are you facing that case sensitive issue or any other issues?

Please download the sample from the below link:

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/118425/RemoteServerAdaptorSample_129241-818803486.zip

If we misunderstood your query, please provide a simple sample for us or make this one as issue reproducible sample, we are happy to assist you.

Please let me know if you have any concerns.

With Regards,

Prasanna Kumar N.S.V

Sidnei V Lavandoski
Replied On March 9, 2015 11:47 PM UTC

Hi Prasanna, thank you by your quick assistance!

In fact, the problem was case sensitive, you are correct.

Is there a way to ignore the case sensitive in the search?

Thank you again.

Prasanna Kumar Viswanathan [Syncfusion]
Replied On March 10, 2015 05:06 PM UTC

Hi Sidnei,

We considered this requirement “Searching is case sensitive using DataManager Operations” as a bug and a support incident has been created under your account to track the status of this requirement. Please log on to our support website to check for further updates.



Prasanna Kumar N.S.V


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon