jQuery Datatable Server Side Processing in Asp.Net MVC - Part 2

[@CodAffection]

goo.gl/bPcyXW : Buy me a Coffee bit.ly/3X7cBnL : Next Video bit.ly/3Z5uWUR : Prev. Video bit.ly/36IA1cH : AspNet Core MVC CRUD Operations bit.ly/3Pn2S7y : Expense Tracker App in AspNet Core MVC bit.ly/2yEPlpB : Convert MVC App to Single Page(jQuery Ajax) bit.ly/403lUVC : MVC Login & User Registration bit.ly/39B6xdh : Image Upload in AspNet Core MVC bit.ly/30fPDMg : More MVC Tutorials

[@jaylenshiloh9783]

i guess im asking the wrong place but does anybody know a way to get back into an Instagram account? I stupidly forgot the password. I love any tips you can offer me.

[@lennondarren2186]

@Jaylen Shiloh Instablaster =)

[@jaylenshiloh9783]

@Lennon Darren thanks for your reply. I got to the site thru google and im trying it out now. Takes quite some time so I will get back to you later with my results.

[@jaylenshiloh9783]

@Lennon Darren it did the trick and I finally got access to my account again. Im so happy! Thanks so much you really help me out :D

[@lennondarren2186]

@Jaylen Shiloh no problem xD

[@uditbalyan]

Thanks. its very nice and I finally made my solution based on these inputs, I am loading 50k rows, was taking 2 mins on DOM, now its 1-2 seconds. Thankyou very much.

[@saktiprasadswain6546]

I want to hug you bro..U gave best and simple to implement data table.

[@CodAffection]

Thanks for your kind words. hope I can make more helpful tutorials like this in future.

[@gustavooguedareyes7514]

Thanks man, worked like a charm. Great post and nice explanation

[@douglaskirschman9919]

Great post. Well thought out and narrated. Bravo!

[@CodAffection]

Glad you found the video helpful.

[@sukhwantkaur2885]

You are awesome !!! Thank you so much for taking the time to create this video

[@CodAffection]

glad you found this video helpful. keep learning and sharing.

[@calebalvarezmorales9946]

OMG man you are a genius very thanks your saved me!!!! ❤️❤️❤️❤️

[@CodAffection]

No problem 👍

[@jdldr]

Thanks for this tutorial, you explained it very well.

[@CodAffection]

Glad you found the video helpfu.

[@bhanumathi2841]

Hi Sir, Super demo...Thanks a ton... I have got clear concept idea and as well as how to implement...Great!!!

[@CodAffection]

My Pleasure & Happy Coding.

[@ankushmehndiratta5265]

thankyou so much sir you save my life

[@ipournami]

Thank you sir for this amazing video!

[@niveshshastri8792]

Thank you for the tutorial

[@lifet4800]

thank you Sir

[@uttamsuthar9940]

Very Helpful

[@CodAffection]

thanks for the comment

[@madhugoud6167]

Hi i have tried datatable based on your inputs ,it's working fine when the table having less records ,but when the table having more records ex:1M records than the page showing "loading records please wait" because of getting all records from db(empList = db.Employee.ToList()) .So can you please update the video & Sample project.

[@xintheseeyesx]

Very helpful! Thank you!

[@CodAffection]

you are welcome.

[@AnshumaanChaturvedi]

Hi, Is this viable way when we are talking about 1 lac records or more from DB. Is there are any performance issue that can happen?

[@alejandrohdez8081]

great video, thanks

[@CodAffection]

if you have any angular material topic to be discussed, let me know.

[@abbasroshan1541]

thank u brother!

[@itfastlineexpress8963]

Awesome tutorials

[@CodAffection]

Glad you found the tutorial helpful.

[@manipathak4296]

Hi When ever I pass the json result from action method to ajax,I only get the json data in view not rendering in datatable any suggestion?

[@TaianMonsores]

Thank you very much!!!

[@ThanhThanh-fx1pe]

thanks you so much.

[@DanielMartinez-kh7qf]

Nice video, thanks!

[@CodAffection]

Glad you found the video helpful.

[@greenmountaindeals8411]

You should be using IQueryable on the server, not converting to a List, or you're going to retrieve all your records from the database!!

[@Chhatrachaudhary]

help ful

[@ashish.sparmar5036]

Can U please tell me that. How can I create dynamic columns based on SQL table..

[@rickytomas]

What ABout handling with large record set like 5000,000 + with search export, etc

[@komalshah1987]

I am getting null values from Request object.Any ideas on this?

[@aspnetmvcdeveloper2648]

Hello thanks alot Sir, I have one issue that table total entries count shows 0 entries (filtered from 0 total entries). Please help.

[@aspnetmvcdeveloper2648]

Done It. Thanks alot Sir.

[@logannathan6195]

Even though i copied the source of jquery with https my application is not showing the datatable

[@vikasbhat89]

Here u r fetching all 57 records first..suppos DB has 1million records then wat wil happn? Actually I need only 10 records at load and based on page number click it should bring its next 10 more records. How to achieve it?

[@codeRS95]

Why are we using POST method to get data?

[@douglaskirschman9919]

POST method is used so that parameters are passed back to server in header. If we used GET, we'd have to use a query string for this.

[@getsmartdaddy8516]

sir can you do this with ado.net please i request you

[@spencersullivan3065]

You just build the enumerable list from ADO results. List thePartList = BLL.GetData.RetrieveParts(); Drop the DBModel using block Replace your List "thePartList" with empList Bob's your uncle. Oh, and I had to use Request.Form[] as Request by itself did not work.

[@siddheshkhorjuvekar]

How to pass values using model to controller for datatables?

[@CodAffection]

to controller or action method ?

[@ashokkumarr4762]

I got the error as follow System.Linq.Dynamic.ParseException: 'No property or field 'asc' exists in type 'emp''

[@kunalsingh-lc2yf]

check your naming of columns in the ajax function it should match the column name in the DB

[@vibingokulv2540]

My database is not loading in it

[@adilet123]

cool

[@YoraGlam]

how i can add edit and delete command to edit and delete the row in database

[@CodAffection]

In-Order to Edit a DataTable Row we have to use another plugin - DataTables Editor, which is not free. alternatively you can do this : kzbin.info/www/bejne/laKsinWdjLmfitE

[@uk4876]

why no one is teaching how to access data by code first approach, everyone is going for database approach

[@nipundesilva3518]

I have a table with 20000 rows. this approach is too slow to load the table.

[@quynhtram1919]

20:09

[@GSSM9274]

Hi I really liked your videos. and I tried using Datatables in exact same way to implement server side paging and sorting.I couldn't get value for request["length"] etc.. I got some 500 (Internal Server Error) Could you please have look and let me know where i was missing.Thanks in advance. Here is my Controller.cs ----------------------------------------- public JsonResult ImportKFSData() { string startDate = "01/01/2016"; string endDate = "01/15/2016"; //int totalrows = 0; var _KFSImportList = new List(); List _KFSImportPaymentDetailOrderBy; // var draw = Request.Form.GetValues("draw").FirstOrDefault(); int start = Convert.ToInt32(Request.QueryString["start"]); int length = Convert.ToInt32(Request.QueryString["length"]); string searchValue = Request.QueryString["search[value]"]; string sortColumnName = Request.QueryString["columns[" + Request.QueryString["order[0][column]"] + "][name]"]; string sortDirection = Request.QueryString["order[0][dir]"]; if (Session["KFSImport"] != null) { //If so access it here _KFSImportList = Session["KFSImport"] as List; } else { _KFSImportList = KFSPaymentDetailList.GetKFSImportList(Convert.ToDateTime(startDate), Convert.ToDateTime(endDate), "test").ToList(); Session["KFSImport"] = _KFSImportList; } int totalrows = _KFSImportList.Count; if (!string.IsNullOrEmpty(searchValue) && _KFSImportList.Count >= 1) // Filter { _KFSImportPaymentDetailOrderBy = _KFSImportList.Where(x => x.CheckNumber.ToString().Contains(searchValue.ToLower()) || x.Amount.ToString().Contains(searchValue.ToLower()) || x.PayeeName.ToLower().Contains(searchValue.ToLower()) || x.PayeeId.ToString().Contains(searchValue.ToLower()) || x.PaymentDate.ToString().Contains(searchValue.ToLower())).ToList(); _KFSImportList = _KFSImportPaymentDetailOrderBy; } int totalrowsafterfiltering = _KFSImportList.Count(); ////sorting if (!((string.IsNullOrEmpty(sortColumnName)) && string.IsNullOrEmpty(sortDirection))) { _KFSImportList = _KFSImportList.OrderBy(sortColumnName + "" + sortDirection).ToList(); } //Paging _KFSImportList = _KFSImportList.Skip(start).Take(length).ToList(); return Json(new { data = _KFSImportList, draw = Request["draw"], recordsTotal = totalrows, recordsFiltered = totalrowsafterfiltering }, JsonRequestBehavior.AllowGet); } } Here is my Js. -------------------- $(document).ready(function () { debugger; var KFSImportTable = $('#KFSImporttbl').DataTable({ "serverSide": true, "ajax": { "url": '@Url.Action("ImportKFSData", "KFSReportablePayments")', "type": "POST", "dataType": "json", "dataSrc": "Data", "contentType": "application/json; charset=utf-8" }, "processing": true, "language":{ "processing":"processing....Please wait" }, //"bSort": true, "columns": [ { "data": "PaymentDate" }, { "data": "PayeeName" }, { "data": "SrcDocType" }, { "data": "Amount" }, { "data": "CheckNumber" }, { "data": "ObjectCode" }, { "data": "KFSDocNbr" }, { "data": "TaxTypeCode" }, { "data": "TIN" }, { "data": "AddressLine1" }, { "data": "AddressLine2" }, { "data": "City" }, { "data": "State" }, { "data": "Country" }, { "data": "ZipCode" }, { "data": "VendorOwnerCode" }, { "data": "ReasonCode" } ], "scrollY": 700, "scrollX": true, "lengthMenu": [[10, 20, 50, -1], [10, 20, 50, "All"]], "order": [[0, "asc"]], "aaSorting": [] }); });

[@jaylovett2237]

If you still having trouble: For your dates in the controller try: DateTime.TryParse(searchValue, out var convertedDateTime); var convertedDateTime2 = convertedDateTime.AddDays(1); || x.Your_date_field >= convertedDateTime && x.Your_date_field

[@meftaulislam711]

one erro occour in my project please help me how to solve this problem .Problem is :- DataTables warning: table id=MyTable - Ajax error. For more information about this error, please see datatables.net/tn/7

[@erickdanielhernandezpalma7395]

The sort button fails if I press it several times in a row, why? It only allows me to give order by asc and then order by desc, and if I want to do it again it shows an error System.Linq.Dynamic.ParseException: 'Expression expected'