Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

42 Comments

  1. Thanks for your great posts.
    Please make a post about “Autocomplete Input” in asp.net core 3.1.

  2. Thanks,
    The render function parameters must be changed as (data, type, row) then DeleteCustomer(‘” + row.id + “‘)

    1. Thanks for this comment. You are a life saver.
      Thanks also to OP for this magnificent and in depth explanation.

  3. Great , But keeping a tables and ajax call and configuration in each razor pages is mess, there must be a way to to reuse the maximum code , If you come across something please update

  4. Excellent tutorial with clean and details presentation.
    Highly appriciatted your knowledge in this young age that too sitting in India.

  5. hey,mukesh i have noticed that ,if i have 5 lakh records then it is picking data 500000 data in customerData,which leads a performance issue.

    var customerData = (from tempcustomer in context.Customers select tempcustomer);

    so how we can improve improve this

  6. Thank you so much, it’s really a helpful article
    but I was thinking of a scenario with permission like (edit or delete) a record
    according to the logged in user

  7. Great article. How can we add searching for a boolean variable at the Searching part? I tried m.BooleanEntity.ToString().Contains(searchValue) but it didn’t work.

      1. Hi!
        I follow your tutorial all the way but I don’t find the data in View of the controller. Can you help me?

  8. Line 33 should be as bellow because you may cause an useless search for “asc” or “desc” in your table, as ‘sortColumn’ can be empty.
    if (!string.IsNullOrEmpty(sortColumn) && !string.IsNullOrEmpty(sortColumnDirection))

  9. Thanks Mukesh, you have explained all the steps in great detail and this has helped me find the solution to the problems that were coming in moving from .Net framework to .NetCore 3.1.

  10. Hi Mukesh,

    Great Article!!

    I have a query – In your “ASP.NET Core Hero Boilerplate” you have used datatable in the Products but it is all client side – though you had given GetAllPaged in the Application project.

    Can that be integrated for server side code or the way you have described here in this article is the right approach.

    Thanks

  11. Thanks a lot Mukesh for your great efforts. It’s very good tool but it would be and excellent complete tool if you add individual column search to it. Of course keep it Server Side.

  12. Thank you for the information and clear steps Mukesh. Can you explain further why the GetCustomers method in the controller is determining the page size, sort columns, etc? The Datatable usually takes care of that functionality by default. My other question is related to the JSON objects – in my case I am using EF but with database first so I don’t have JSON objects. Is it necessary to have JSON objects for EF objects (when not using HTML as the source)?

  13. I dont know how nobody noticed it but for me when I sort or search using 1000 customers data it almost took 25-28 seconds to complete loading of data.

    Has anyone noticed it? Any ways to improve it?

  14. Dear Mukesh
    Thanks for such beautiful article, I have tried it in ASP.NET Core MVC , every this goes fine except 1. error
    var data = customerData.Skip(skip).Take(pageSize).ToList(); is throw error.
    can you please guide me
    Regards
    Merchant.

    1. 1) line no.33 will be if (!string.IsNullOrEmpty(sortColumn) && !string.IsNullOrEmpty(sortColumnDirection))
      In current code if sortColumn is empty and sortColumnDirection is not empty then condition statisfied and it will execute if block and throw error.I have faced this issue in my case.
      2) line no.24 in html page should be this
      render: function (data, row, item, index) { return “Delete“;
      }

      this is beacuse the row has no we need id which you can get from item.id.

  15. Hi thanks to your post.
    So actually I work 60 000 files in FileTable in DB from SQL. So I would like to know if I can use sever side processing with File Tables.
    Thanks in advance

  16. Hi, I follow your tutorial and everything works as expected. Now I’m trying to implement the Delete function but with no luck. I tried almost everything but it seems to be a problem calligrafia the action from ahax
    Could you please help me? I’m becoming crazy
    Thanks

  17. At OP,
    If you have some free time, would you be able to provide a tutorial to use searchPanes while using server side rendering?

    Thanks in advance.

  18. Thanks for the excellent example. It is working well for me. I do have a question on how to get this request form value:
    {[columns[1][search][value], {^4$}]}

  19. I am getting error with above code : DataTable warning : table id=example-reqeusted unknown parameter