how to catch jquery datatable server side data source parameters in ASP.Net MVC

Question

I'm using jQuery Datatable and server side proccessing as data source in my ASP.Net MVC application. I need to apply search term in my query but I don't know how to catch it.

here is short version of my controller :

public JsonResult Index(POFilter m) {
   return Json(new {
      data = data,
      ...
   })
}

POFilter.cs

public class POFilter
{
    public int start { get; set; }
    public int length { get; set; }
    public int draw { get; set; }
    public List<DT_Order> order { get; set; }
    public string[] search { get; set; }

    public POFilter()
    {
        start = 0;
        length = 10;
        draw = 1;
    }
}

public class DT_Order
{
    public int column { get; set; }
    public string dir { get; set; }
}

but for some reason the search property is always null. you can see the parameters which are passed by jquery datatable:

order[0][column]:0
order[0][dir]:desc
start:0
length:10
search[value]:my search term
search[regex]:false

how can I get my search term from passed parameters?

@adricadar no it's not null itself but order[0].column and order[0].dir have wrong values. anyway, I found the answer. I should use m.search = Request["search[value]"] or in general Request[key] — mhesabi
– mhesabi, Commented Apr 22, 2015 at 6:51

o..o · Accepted Answer · 2016-03-03 15:51:20Z

1

Use datatables.mvc5 nuget package to get typed modelbinder:

public JsonResult GetData([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel)
{
    // requestModel.Start..
    // requestModel.Length..
    // requestModel.Columns..
}

answered Mar 3, 2016 at 15:51

o..o

1,9317 gold badges37 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

BrianLegg · Accepted Answer · 2016-03-03 15:46:38Z

1

I'm using an object to hold the search result. Instead of using:

public string[] search { get; set; }

I use:

public DataTableSearch Search { get; set; }

Where DataTableSearch is defined as:

public class DataTableSearch
{
    public string Value { get; set; }
    public string Regex { get; set; }
}

Let me know if that doesn't fix your issue (if you're still having an issue).

answered Mar 3, 2016 at 15:46

BrianLegg

1,7003 gold badges21 silver badges40 bronze badges

Comments

Gelootn · Accepted Answer · 2015-04-22 07:46:36Z

0

Take a look at this project, it is a MVC / Jquery datatable implementation made by a friend. I use this in almost all of my projects

https://github.com/amoerie/generic-datatables

its a bit hard to implement, but once it is in place, its easy to work with

answered Apr 22, 2015 at 7:46

Gelootn

6016 silver badges16 bronze badges

Collectives™ on Stack Overflow

how to catch jquery datatable server side data source parameters in ASP.Net MVC

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related