empty record list on your Jquery dataTable

Guest User

6y1.3k.NET

Hi Team

I am returning an empty record list on my dataTable, what could be an issue? Is the issue on my calling of dbContext not correcttly? Please help me mates as i am returning an empty record list on UI. Here is my logic below for this reason.

[HttpPost]
public ActionResult GetList() {
//Server side Parameter.
int start = Convert.ToInt32(Request["start"]);
int length = Convert.ToInt32(Request["length"]);
string searchValue = Request["search[value]"];
string sortColumnName = Request["columns[" + Request["order[0][column]"] + "][name]"];
string sortDirection = Request["order[0][dir]"];
using(eNtsaOnlineRegistrationDBContext db = new eNtsaOnlineRegistrationDBContext()) {
IQueryable < TblEventsManagements > empList = db.TblEventsManagements;
int totalrows = empList.Count();
int totalrowsafterfiltering = totalrows;
if (!string.IsNullOrEmpty(searchValue)) {
empList = empList.Where(x => x.TrainingType.Contains(searchValue) || x.TrainingDescription.Contains(searchValue) || x.Price.ToString().Contains(searchValue.ToLower()) ||
x.Venue.Contains(searchValue) || x.Facilitator.Contains(searchValue) || x.WhoAttend.Contains(searchValue) || x.Rsvp.Contains(searchValue));
totalrowsafterfiltering = empList.Count();
}
empList = empList.OrderBy(sortColumnName + " " + sortDirection).Skip(start).Take(length);
return Json(new {
data = empList.ToList(), draw = Request["draw"], recordsTotal = totalrows, recordsFiltered = totalrowsafterfiltering
}, JsonRequestBehavior.AllowGet);
}
}

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Asma Khalid6y ago
Accepted answer
update following
   "columns": [
    {"data": "TrainingType", "name": "TrainingType"},
    { "data": "TrainingDescription", "name": "TrainingDescription" },
    { "data": "Price", "name": "Price" },
    { "data": "Venue", "name": "Venue" },
    { "data": "Facilitator", "name": "Facilitator" },
    { "data": "WhoAttend", "name": "WhoAttend" },
    {"data": "RSVP", "name": "RSVP"},
],    0
as
   "columns": [
    {"data": "TrainingType"},
    { "data": "TrainingDescription" },
    { "data": "Price" },
    { "data": "Venue" },
    { "data": "Facilitator"},
    { "data": "WhoAttend" },
    {"data": "RSVP"},
],    0
I can remote acces using anydesk if you like Msg your IP in inbox of C-Sharpcorner.

Mark the answer as accepted if helpful

Thanks & Regards,
Asma Khalid

For more visit www.asmak9.com
+1
Ecco Suprastyo6y ago
Hello,

You can use this method for passing data in datatable:
1. Change in controller return
return Json(empList.ToList());
2.remove all code in javascript and replace with this:
0
Guest User6y ago
Hi Asma

I have sent IP to connect to Anydesk, please connect remotely.
0
Guest User6y ago
Hi Asma

the issue now is format of my data to pull through, see below some fields do reference and they dont load well format of my file. Javascript debugger do picked this up. the status is 200 and with data file. People please help me i am stuck
0
Asma Khalid6y ago
are you able to hit your controller method?
are you getting data from your database?

your flow is not correct but needs few tweeking from client and server side. Do let me know otherwise.

Also, the link I have provide contains data from SQL server not from file. kindly, download and execute that solution. I am sure you will be able to resolve your issue.

Mark the answer as accepted if helpful

Thanks & Regards,
Asma Khalid

For more visit www.asmak9.com

0
Guest User6y ago
Hi Asma

it seems on my case i do need on my Controller load the data first to the path, as i seen access the file content/.... folder. While mine is sitting on the App_Data as db table not file. Then modify my get method to reference the load data to allow server side access on my URL path of this controller well. Am i wrong? please advice.
0
Asma Khalid6y ago
Look into this and try to resolve your issue https://bit.ly/38mXbkt

You are doing a lot of mistakes here on client side and server side for example.

on client side you are not correctly mapping the columns

on Server side you are not sending correct value of filterrecord and also you are not managing pagination, for serverside, you neeed to manage the pagination yourself.

Also ensure that in your server side you are actually getting the data.

Mark the answer as accepted if helpful

Thanks & Regards,
Asma Khalid

For more visit www.asmak9.com
0
Guest User6y ago
Hi Mate

I am not, my question is my DbContext has more than table record, yet i do specify on the IQueryable which one is relevant has data. But why am i returning an empty record.
0
Salman Beg6y ago
First check whether you are getting value in empList or not. Thanks
0