MVC JQ grid loading large data

Question

Hi friends In my MVC5 application we are using JQ grid inside a pop up window to load the user data.Normally it can render the data while click the button.Suppose above 10000 thousands records its not able to load .Its giving javascript error like error while retrive data  ..So that i would like to know that can we load the large number of data in the jq grid. Please provide your suggestion... Thanks Anand R

Ravi Kumar · Answer

check the fallowing code *.cshtml ----------------------------- *.js------ $('#MainSearchContainer').jtable({ title: 'ColorList' paging: true pageSize: 15 sorting: false defaultSorting: 'Name ASC' actions: { listAction: '/Color/ColorListByFiter' updateAction: '' createAction: '' deleteAction: '' } fields: { Pk_Color: { title: 'Id' key: true } ColorName: { title: 'Name' } } }); *controller.cs------------------------------------------- [HttpPost] public JsonResult ColorListByFiter(string ColorName =  string Pk_Color =  int jtStartIndex = 0 int jtPageSize = 0 string jtSorting = null) { try { List oSearchParams = new List (); oSearchParams.Add(new SearchParameter(Pk_Color Pk_Color)); oSearchParams.Add(new SearchParameter(ColorName ColorName)); oSearchParams.Add(new SearchParameter(StartIndex jtStartIndex.ToString())); oSearchParams.Add(new SearchParameter(PageSize jtPageSize.ToString())); SearchResult oSearchResult = oDoaminObject.Search(oSearchParams); List oColorToDisplayObjects = oSearchResult.ListOfRecords; List oColorObjects = oColorToDisplayObjects.Select(p => p).OfType ().ToList(); //Create a anominious object here to break the circular reference var oColorToDisplay = oColorObjects.Select(p => new { Pk_Color = p.Pk_Color ColorName = p.ColorName }).ToList(); return Json(new { Result = OK Records = oColorToDisplay TotalRecordCount = oSearchResult.RecordCount }); } catch (Exception ex) { return Json(new { Result = ERROR Message = ex.Message }); } }

Ravi Kumar · Answer

what error coming