DataTables warning (table id = 'example-datatables'): Requested unknown parameter '0' from the data source for row 0
Example 1: DataTables warning: table id=DivisionTable - Requested unknown parameter '0' for row 0, column 0. For more information about this error
Plain text12345678910111213141516171819202122232425262728293031323334353637383940 using (var db = new Database(sqlType, connectionSQL)) { var response = new Editor(db, "tblImmigrationNotes", new[] { "imnImmigrationNoteID" }) .TryCatch(true) .Model() .Field(new Field("imnAdvisingDate") .Validator(Validation.DateFormat( Format.DATE_ISO_8601, new ValidationOpts { Message = "Please enter a date in the format yyyy-mm-dd" } )) .GetFormatter(Format.DateSqlToFormat(Format.DATE_ISO_8601)) .SetFormatter(Format.DateFormatToSql(Format.DATE_ISO_8601)) ) .Field(new Field("imnStudentUserID") .Validator(Validation.Required()) ) .Field(new Field("imnSchoolMasterID") .Validator(Validation.Required()) ) .Field(new Field("imnAdvisingAction") .Validator(Validation.NotEmpty()) ) .Field(new Field("imnAdvisingType") .Validator(Validation.NotEmpty()) ) .Field(new Field("imnAdvisingSource") .Validator(Validation.NotEmpty()) ) .Field(new Field("imnAdvisingNote") .Validator(Validation.NotEmpty()) ) // no more fields .Process(request) .Data(); return Json(response); } }}
Example 2: DataTables warning: table id=DivisionTable - Requested unknown parameter '0' for row 0, column 0. For more information about this error
Plain text12345678910111213141516// setup and establish DataTable $("#ImmigrationNotes").DataTable({ ajax: "/api/StudentImmigrationNotesDT", model: "StudentImmigrationNotesModel", // the columns used //data: data, columns: [ { data: 'Advised Date:' }, { data: 'Action Given:' }, { data: 'Advise Type:' }, { data: 'Advise Note:' }, { data: 'Advise Source:' }, { data: 'School ID:' }, { data: 'Student ID:' }, { data: 'Immigration Note ID' } ]