Custom Search in jQuery Datatable - Part 3

Custom Search in jQuery Datatable in Asp.net MVC Application.
This tutorial discusses how to implement custom search in jQuery DataTable using asp.net MVC,
Contents :
1. Datatable Custom Search in Client-Side
2. Custom Search Using Drop Down List
3. Datatable Custom Search in Client-Side
4. Custom Search Using Outside Text box
📂 GitHub Repository
► goo.gl/ST4QAM
💖 Buy me a Coffee
➤ bit.ly/3L36ut4 (PayPal)
➤ bit.ly/3VF0iPT (Razorpay)
🌀 Related Videos
goo.gl/7G377x : Server Side Processing in Datatable
datatables.net/ : Official Website of Datatable
goo.gl/ySUFf8 : Similar Mvc Tutorials
goo.gl/3ajHuA : Similar C# Video Tutorials
goo.gl/yHZcCo : Build Complete Asp.Net MVC App
goo.gl/ZXKqT9 : jQuery Ajax in Asp.net MVC
🔗 Find me in
Udemy : bit.ly/3RtyQSB
Facebook : / codaffection
GitHub : github.com/cod...
Discord : / discord
Twitter : / codaffection
#jqueryDataTable #AspNet #CodAffection

[@CodAffection]

goo.gl/RFY5C2 : Subscribe to CodAffection
goo.gl/C9TSBT : Part 4 - Column Visibility And Fixed Column in Datatable
goo.gl/w2AfHf : Part 2 - Server Side Processing in jQuery Datatable
goo.gl/daCAGp : Complete jQuery Datatable and Asp.Net MVC Integration Videos

[@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.

[@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!

[@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

[@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

[@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 ?

[@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?

[@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);
}
}

[@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 .

[@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.