Hi All,

I have a requirement in which I dont want to show 5 columns in display.I have used 'Hiding' property of grid.

I have a checkbox in which it is checked want to show all the records of grid in single page and if unchecked want to show with pagination.

I have used the below code to implement.While checking the checkbox hiding property worked and while unchecking hidden columns are displayed in the screen.

Please find the code given below.

$(function () {
$.ig.loader({
scriptPath: '@Url.Content("~/Content/Scripts")',
cssPath: '@Url.Content("~/Content/css")',
resources: 'igGrid.*',
ready: function () {

$.getJSON("@Url.Content("~/Student/GetAllStudentContractData")", null, function (data) {

var headerTextValues = ["Student ID", "PPO Contract Name", "From Date", "Thru Date", "Contract Rates", "Contract Prompt Payment",
"Contract Exceptions", "MasterStudentContractPtr", "MasterStudentInternalNum", "MasterStudentID", "MasterStudentSuffix","StudentInternalNum"];
$('#tbStudentContractGrid').igGrid({
expandCollapseAnimations: true,
animationDuration: 1000,
expandTooltip: "Expand to View Details",
collapseTooltip: "Hide details",
dataSource: data,
responseDataKey: "Records",
dataSourceType: "json",
autoGenerateLayouts: false,
autoGenerateColumns: false,

rowEditDialogContainment: "owner",
showReadonlyEditors: false,

columns: [
{ headerText: headerTextValues[0], key: "StudentContractNum", width: "10%" },
{ headerText: headerTextValues[1], key: "ContractNam", width: "10%" },
{ headerText: headerTextValues[2], key: "StartDate", width: "10%" },
{ headerText: headerTextValues[3], key: "ThruDate", width: "10%" },

{ headerText: headerTextValues[4], key: "CountContractRates", width: "10%",
template: "{{if ${CountContractRates} > 0 }}<a href='@Url.Content("~/StudentContractRates/StudentContractRates?masterflag=${MasterStudentContractPtr}&contractnum=${StudentContractNum}&masterseqnum=${MasterStudentInternalNum}&providerseqnum=${StudentInternalNum}&contractthrudate=${ThruDate}")' target='_blank'>View Details</a>{{else}}No results found{{/if}}"
},
{ headerText: headerTextValues[5], key: "CountPromptPayment", width: "10%",
template: "{{if ${CountPromptPayment} > 0 }}<a href='@Url.Content("~/StudentContractPayment/StudentContractPayment?masterflag=${MasterStudentContractPtr}&contractnum=${StudentContractNum}&masterseqnum=${MasterStudentInternalNum}&providerseqnum=${StudentInternalNum}&contractthrudate=${ThruDate}")' target='_blank'>View Details</a>{{else}}No results found{{/if}}"
},
{ headerText: headerTextValues[6], key: "CountException", width: "10%",
template: "{{if ${CountException} > 0 }}<a href='@Url.Content("~/ContractException/ContractException?masterflag=${MasterStudentContractPtr}&contractnum=${StudentContractNum}&masterseqnum=${MasterStudentInternalNum}&providerseqnum=${StudentInternalNum}&contractthrudate=${ThruDate}")' target='_blank'>View Details</a>{{else}}No results found{{/if}}"
},

{ headerText: headerTextValues[7], key: "MasterStudentContractPtr", width: "10%" },
{
headerText: headerTextValues[8], key: "MasterStudentInternalNum", width: "15%"
},

{ headerText: headerTextValues[9], key: "MasterStudentID", width: "15%" },
{ headerText: headerTextValues[10], key: "MasterStudentSuffix", width: "15%" },
{ headerText: headerTextValues[11], key: "StudentInternalNum", width: "15%"}
],

features: [
{
name: "Selection",
mode: "row",
multipleSelection: false
},
//For Hiding columns
{
name: "Hiding",
columnSettings: [
{
columnKey: "MasterStudentContractPtr",
allowHiding: true,
hidden: true
},
{
columnKey: "MasterStudentInternalNum",
allowHiding: true,
hidden: true
},
{
columnKey: "MasterStudentID",
allowHiding: true,
hidden: true
},
{
columnKey: "MasterStudentSuffix",
allowHiding: true,
hidden: true
},
{
columnKey: "StudentInternalNum",
allowHiding: true,
hidden: true
}
]
},
{
name: 'Paging',
type: 'local',
pageSize: 10,
inherit: true
},
{
name: 'Filtering',
showNullConditions:true
},
{
name: "ColumnMoving",
mode: "immediate",

addMovingDropdown: true,
mode: "deferred",
type: "render"
},
{
name: 'Sorting'

},

{
name: "GroupBy",
columnSettings: [
{
isGroupBy: true
}
]
}

]
,
dataRendered: function(evt, ui) {
if (ui.owner.dataSource.dataView().length > 0) {
//To show the Display all records
$("#GridChkbox").show();
}
}
});
});

}
});
})

Please suggest the solution for this.

Regards,

Pradeep SE