Solution
colNames: ['Name','WWID', 'Department', 'Email Id', 'Cost Center', 'Badge Type','Ids Id','Manager WWID', 'Authcode', 'Extension','Mobile', 'Authcode Level','Site','Generic','Mac'],
colModel: [
{ name: 'UserName', index: 'UserName', key: true, width: '200', editable: true, sortable: true, align: 'center' },
{ name: 'WWID', index: 'WWID', width: '250', editable: true, sortable: true, sorttype: 'int', align: 'center' },
{ name: 'DepName', index: 'depName', width: '200', editable: true, sortable: true, sorttype: 'text', align: 'center' },
{ name: 'MailId', index: 'MailId', width:'400', editable: true, sortable: true,sorttype:'text', align: 'center' },
{ name: 'CostCenter', index: 'Costcenter', width:'200', editable: true, sortable: true,sorttype:'int', align: 'center' },
{ name: 'Batch', index: 'Batch', width: '200', editable: true, sortable: true, sorttype: 'text', align: 'center' },
{ name: 'Groups', index: 'Groups', width:'200', editable: true, sortable: true,sorttype:'text', align: 'center' },
{ name: 'MonthlyQuota', index: 'MonthlyQuota', width:'250', editable: true,sortable: true,sorttype:'text', align: 'center' },
{ name: 'Authcode', index: 'Authcode', width:'200', editable: true, sortable: true,sorttype:'int', align: 'center' },
{ name: 'Extension', index: 'Extension', width:'200', editable: true, sortable: true,sorttype:'int', align: 'center' },
{ name: 'Mobile', index: 'Mobile', width:'300', editable: true, sortable: true,sorttype:'int', align: 'center' },
{ name: 'Landline', index: 'Landline', width:'300', editable: true, sortable: true,sorttype:'int', align: 'center' },
{ name: 'Businessunit', index: 'Businessunit', width: '300', editable: true, sortable: true, sorttype: 'text', align: 'center' },
{ name: 'Generic', index: 'generic', width: '1', editable: true, sortable: true, sorttype: 'text', hidden: 'true', align: 'center' },
{ name: 'Mac', index: 'mac', width: '200', editable: true, sortable: true, sorttype: 'int', align: 'center' },
],
{ edit: true, add: true, del: true, search: false, excel: true, exceltext: 'Excel', cloneToTop: true },
{
url: "Uploading.ashx", closeAfterEdit: true, afterSubmitCell: function () { $('#gridId').trigger('reloadGrid'); },
beforeShowForm: function (form) { $('#tr_UserName', form).hide(); $('#tr_DepName', form).hide(); $('#tr_MailId', form).hide(); $('#tr_CostCenter', form).hide(); $('#tr_Batch', form).hide(); $('#tr_Groups', form).hide(); $('#tr_MonthlyQuota', form).hide(); $('#tr_Mobile', form).hide(); $('#tr_Landline', form).hide(); $('#tr_Businessunit', form).hide(); $('#tr_Generic', form).hide(); }
},
{
url: "Uploading.ashx", closeAfterAdd: true,
beforeShowForm: function (form) { $('#tr_UserName', form).show(); $('#tr_DepName', form).show(); $('#tr_MailId', form).show(); $('#tr_CostCenter', form).show(); $('#tr_Batch', form).show(); $('#tr_Groups', form).show(); $('#tr_MonthlyQuota', form).show(); $('#tr_Mobile', form).show(); $('#tr_Landline', form).show(); $('#tr_Businessunit', form).show(); $('#tr_Generic', form).hide(); }
}