Custom Search in jQuery Datatable - Part 3

[@CodAffection]

goo.gl/bPcyXW : Buy me a Coffee bit.ly/3XcDUNd : Next Video bit.ly/3AXsdm8 : Prev. Videos 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

[@bkcy18]

Thanks a lot for this playlist. The sever side videos are really helpful. Any resources on how to query the database with multiple values for a column? Basically, i need a multiselect dropdown in the ui for some columns.

[@erisonnicodemos]

Man this tutorial helped me a lot, congrats!

[@CodAffection]

Glad you found the video helpful.

[@TanvirMahmudKhan]

Thank you so much... But the dropdown is not loading server-side.... It's generating from the current 10 rows... Do you have any solution for this ?

[@erisonnicodemos]

First thank you for this tutorial, but in my case I need have more than one column in my Grid with select box! How I can do this!

[@kunireddysrikanthreddy5773]

Hi , it was nice explanation.i have an doubt Individual column filtering using fixed columns in data table, it is possible?, if yes, any article link please

[@casimirogreco6968]

Thank you for the great tutorial. I think there is mistake. In the Office Dropdown population Serverside, not all the values of the Domain are populated (ex. Singapore is missing, see minute at 39:44). This is because the dropdown is populated with the values from the first 10 elements of the server (where no Employees are from Singapore). Thank you again for your effort :)

[@TanvirMahmudKhan]

@Casimiro Did you find any solution for this ?

[@mohsinali-uf9dl]

Great

[@manipathak4296]

Great videos.Can you please help to make this datatable as inline with save functionality for each record?

[@CodAffection]

I'll try. but not in datatable plugin. they provide the feature in paid plugin : datatable editable.

[@manipathak4296]

Hey I have made the inline template using datatable with modifications in jquery.But as soon as I post data in the indvisual search columns they get disappeared after the post request.Is there any other method where the input text box generated would not be destroyed on request fom server. Thanks in advance.

[@ioannistallis5172]

Τhanks for the great video

[@CodAffection]

Glad you found the video helpful.

[@manipathak4296]

I tried the code but to the vain it cant able to find the "index" in the function ...can you please help me what I doing wrong in this?

[@nazmulhyder8695]

help!!! how to include action link inside Jquery datatable ?

[@CodAffection]

did you try this : stackoverflow.com/a/11262595/4133590

[@nazmulhyder8695]

@@CodAffection no!but I've seen this ... not clear so much... pls make a video for action links integration in client/server side processing jquery data table .

[@GSSM9274]

Hi, This is really useful tutorial, Thanks for posting.I have some issue in data table. Can you please tell me where I am missing.Here is my problem. I am trying to load JSON data into data tables using ajax call with 'GET' type. When ever I am using more than 8 columns I am getting 404 error.If its 8 columns then i can able to bind the data to data table successfully. Here is my table: ------------------------- Payment Date Payee Name Src Doc Type Amount Check Number Object Code KFSDocNbr Tax TypeCode @* TIN AddressLine1 AddressLine2 City State Country Zip Code Vendor Owner Code Reason Code*@ Payment Date Payee Name Src Doc Type Amount Check Number Object Code KFSDocNbr Tax TypeCode @* TIN AddressLine1 AddressLine2 City State Country Zip Code Vendor Owner Code Reason Code*@ here is my script ---------------------------- $(document).ready(function () { debugger; var KFSImportTable = $('#KFSImporttbl').DataTable({ "serverSide": true, //"fixedHeader": { footer: true }, "ajax": { "url": '@Url.Action("ImportKFSData", "KFSReportablePayments")', "dataType": "json", "type": "GET" // "contentType": "application/json; charset=utf-8" }, "bProcessing": true, "bSort": true, "dataSrc": "Data", "columns": [ { "data": "PaymentDate", //"bSearchable": false, }, { "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": 500, "scrollX": 400, "paging": false }); }); Here is my Controller.cs ------------------------------------- public JsonResult ImportKFSData() //(int rows,string sidx,string sord,int page)//,DateTime startDate,DateTime endDate) { string startDate = "01/01/2016"; string endDate = "01/15/2016"; int page = 1; var _KFSImportList = new KFSPaymentDetailList(); if (Session["KFSImport"] != null) { //If so access it here _KFSImportList = Session["KFSImport"] as KFSPaymentDetailList; } else { // var _KFSImportList = new KFSPaymentDetailListViewModel(Convert.ToDateTime(startDate), Convert.ToDateTime(endDate), "mareedum"); _KFSImportList = KFSPaymentDetailList.GetKFSImportList(Convert.ToDateTime(startDate), Convert.ToDateTime(endDate), "mareedum"); Session["KFSImport"] = _KFSImportList; } var result = new { total = 50, Page = page.ToString(), records = _KFSImportList.Count(), Data = _KFSImportList.Select(kfsRawData => new { kfsRawData.PaymentDate, kfsRawData.PayeeId, kfsRawData.PayeeName, kfsRawData.SrcDocType, kfsRawData.Amount, kfsRawData.CheckNumber, kfsRawData.ObjectCode, kfsRawData.KFSDocNbr, kfsRawData.TaxTypeCode, kfsRawData.TIN, kfsRawData.AddressLine1, kfsRawData.AddressLine2, kfsRawData.City, kfsRawData.State, kfsRawData.ZipCode, kfsRawData.Country, kfsRawData.VendorOwnerCode, kfsRawData.ReasonCode }).ToArray() }; return Json(result, JsonRequestBehavior.AllowGet); } }