MVC JQ grid loading large data

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

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

}

2 Replies

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

Ravi Kumar11y ago
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 Kumar11y ago
what error coming