[sreeni379Member]

Hi ,

Last week i posted nested grid problem still i dint get any response your side , i posted my code also,please find what wrong above code i posted. Please help me , it very urgent to me.
Thanks
Sreeni

[sreeni379Member]

Hi Peter Stove,

I am sorry ,last time posted wrong code, this is my actual code for nested grid, Can check once what wrong in that code ,Can please help me .

This is code i written for nested Grid:
$(“#jqxgridPeripheralAdmin”).jqxGrid(
{
width: ‘100%’,
height: 206,
showdefaultloadelement: true,
source: dataAdapterForMainGrid,
theme: theme,
columnsresize: true,
pageable: true, altrows: true,
editable: true,
enablehover: false,
selectionmode: ‘none’,
enabletooltips: true,
filterable: true,
sortable: true,
//rendergridrows: function () { return dataAdapterForMainGrid.records; },
rowdetails: true,
autoshowfiltericon: true,
rowdetailstemplate: { rowdetails: “

“, autoheight: true, rowdetailshidden: true },
initrowdetails: function (index, parentElement, gridElement, record) {
var PeripheralIDValue = $(‘#jqxgridPeripheralAdmin’).jqxGrid(‘getcellvalue’, index, “PeripheralID”);
var DellPartNumberValue = $(‘#jqxgridPeripheralAdmin’).jqxGrid(‘getcellvalue’, index, “DellPartNumber”);
//debugger;
var val = row.DellPartNumber + “”;
var val1 = val.replace(//g, ”);
splitval = val1.split(”);
var lenght = splitval.length;
var i = lenght – 1;
if (i === 1) {
$(‘#jqxgridPeripheralAdmin’).jqxGrid(‘setrowheight’, index, 25);
}
else {
$(‘#jqxgridPeripheralAdmin’).jqxGrid(‘setrowheight’, index, 18 * i);
}
splitval = [];
grid = $($(parentElement).children()[0]);
grid.bind(‘bindingcomplete’, function (event) {
if (event.target.id == “grid” + index) {
grid.jqxGrid(‘beginupdate’);
var datainformation = grid.jqxGrid(‘getdatainformation’);
for (var i = 0; i < datainformation.rowscount; i++) {
var hidden = true;
grid.jqxGrid('setrowdetails', i, "

“, 220, hidden);
}
grid.jqxGrid(‘endupdate’);
}
});
//debugger;
$.ajax({
url: ‘../Peripheral/GetRegionalData’, cache: false, async: false, data: { PeripheralID: PeripheralIDValue },
success: function (data, status, xhr) {
var jqxGridForNestedGrid = {};
jqxGridForNestedGrid = data;
var ssourcenstedgrid = {
datafields: [{ name: ‘RegionName’ }, { name: ‘ChangeClass’ }, { name: ‘HiddenExternal’, type: ‘bool’ }, { name: ‘HiddenInternal’, type: ‘bool’ }, { name: ‘RTSDate’ }, { name: ‘FCSDate’ }, { name: ‘EOMLDate’ }, { name: ‘ReasonForChange’ }, { name: ‘TestOnly’ }, { name: ‘CustomerComments’ }, { name: ‘EditorComments’ }, { name: ‘CreatedDateTime’ }],
datatype: “array”,
localdata: jqxGridForNestedGrid
}
/*format dateTime*/
var dataAdapternstedgrid = new $.jqx.dataAdapter(FormatDateTime(ssourcenstedgrid));
if (grid != null) {
grid.jqxGrid({
source: dataAdapternstedgrid, theme: theme, width: 900, autoheight: true, rowdetails: true, enabletooltips: true, editable: false,
columns: [
{ text: ‘Regions’, datafield: ‘RegionName’, width: 180 },
{ text: ‘Change Class’, datafield: ‘ChangeClass’, columntype: ‘dropdownlist’, width: 130 },
{ text: ‘Reason For Change’, datafield: ‘ReasonForChange’, width: 150 },
{ text: ‘Hidden External’, datafield: ‘HiddenExternal’, columntype: ‘checkbox’, width: 130 },
{ text: ‘Hidden Internal’, datafield: ‘HiddenInternal’, columntype: ‘checkbox’, width: 130 },
{ text: ‘RTS Date’, datafield: ‘RTSDate’, width: 100 },
{ text: ‘FCS Date’, datafield: ‘FCSDate’, width: 100 },//sree
{ text: ‘EOL Date’, datafield: ‘EOMLDate’, width: 100 },
{ text: ‘Test Only’, datafield: ‘TestOnly’, columntype: ‘checkbox’, width: 80 },
{ text: ‘Customer Comments’, datafield: ‘CustomerComments’, width: 170 },
{ text: ‘Editor Comments’, datafield: ‘EditorComments’, width: 140 },
{ text: ‘Last Updated’, datafield: ‘CreatedDateTime’, width: 110 }
]
});
}
Gridrowidth();
}
});
},
columns: [
{
text: ”, datafield: ‘SelectAll’, filterable: false, sortable: false, columntype: ‘checkbox’, width: 40,
renderer: function () {
var value = CheckAndUncheck1stRenderer();
return value;
},
rendered: function (element) { SelectAllPaging(element, Maingrid); }
},
{
text: ‘MapPlatform’, datafield: ‘Edit’, columntype: ‘button’, cellsalign: ‘center’, width: 80, cellsrenderer: function () {
return “Platform”;
},
buttonclick: function (row) {
//debugger;
PeripheralID = $(“#jqxgridPeripheralAdmin”).jqxGrid(‘getcellvalue’, row, ‘PeripheralID’);
$(“#PlotNamePOP”).jqxWindow(‘show’);
PlotformDetail(PeripheralID);
// alert(row.PeripheralID +”Hi”);
}
},
{ text: ‘Status’, datafield: ‘FlagPartPresentStatus’, editable: false, width: 60, cellsrenderer: imagerenderer },
{ text: ‘PeripheralID’, editable: false, dataField: ‘PeripheralID’, hidden: true },
{ text: ‘GroupID’, editable: false, dataField: ‘GroupID’, hidden: true },
{ text: ‘Dell Part No.’, editable: false, dataField: ‘DellPartNumber’, cellsalign: ‘center’, width: 100 },
{ text: ‘UnGroupID’, editable: false, dataField: ‘UnGroupID’, width: 100, hidden: true },
{ text: ‘GroupID’, editable: false, dataField: ‘GroupID’, width: 100, hidden: true },
{ text: ‘Part Description’, editable: false, dataField: ‘PartDescription’, cellsalign: ‘center’, width: 141 },
{ text: ‘Peripheral Type’, editable: false, dataField: ‘PeripheralType’, width: 172 },
{
text: ‘Peripheral Sub Type ‘, editable: true, dataField: ‘PeripheralSubType’, columntype: ‘dropdownlist’, width: 170,
createeditor: function (row, cellvalue, editor) {
PeripheralTypeID = $(“#jqxgridPeripheralAdmin”).jqxGrid(‘getcellvalue’, row, ‘PeripheralType’);
var PeripheralsubtypeList = “”;
//debugger;
PeripheralsubtypeList = LoadPeripheralSubType(PeripheralTypeID);
editor.jqxDropDownList({ displayMember: ‘PeripheralSubType’, valueMember: ‘PeripheralSubTypeID’, source: PeripheralsubtypeList });
},
validation: function (row, value) {
if (value == “”) {
return { result: false, message: “PeripheralSubType is Required.” };
}

return true;
}

},
{
text: ‘Brand Name’, editable: true, dataField: ‘PeripheralBrandName’, width: 120,
validation: function (rowdetails, value) {
var PeripheralIDVal = “”;
PeripheralIDVal = $(“#jqxgridPeripheralAdmin”).jqxGrid(‘getcellvalue’, rowdetails.row, ‘PeripheralID’);
if (PeripheralIDVal != 0) {
if (value == “”) {
return { result: false, message: “Please enter PeripheralBrandName” };
}
else if (value.length >= 30) {
return { result: false, message: “PeripheralBrandName should below 30 characters only” };
}
return true;
}
return true;
}
},
{
text: ‘Internal Marketing Name’, editable: true, dataField: ‘InternalMarketingName’, width: 150,
validation: function (rowdetails, value) {
var PeripheralIDVal = “”;
PeripheralIDVal = $(“#jqxgridPeripheralAdmin”).jqxGrid(‘getcellvalue’, rowdetails.row, ‘PeripheralID’);
if (PeripheralIDVal != 0) {
if (value == “”) {
return { result: false, message: “Please enter InternalMarketingName” };
}
else if (value.length >= 30) {
return { result: false, message: “InternalMarketingName should below 30 characters only” };
}
return true;
}
return true;
}
},
{ text: ‘GSP’, editable: true, dataField: ‘GSP’, columntype: ‘checkbox’, width: 90 },
{ text: ‘Cust Kit’, editable: true, dataField: ‘CustKit’, columntype: ‘checkbox’, width: 90 },
//{ text: ‘Test Only’, editable: false, dataField: ‘TestOnly’, columntype: ‘checkbox’, width: 90 },
{ text: ‘Vendor’, editable: false, dataField: ‘Vendors’, cellsalign: ‘center’, width: 120 }
]
});

Thanks
Sreeni

[sreeni379Member]

Hi Dimitar,

I Changed ‘AdminUserIDs’ ‘ datafield. Still i have same problem , Here i find problem , Dropdownlist iteam selected through mouse after selection that iteam is not binding to row ,when i press enter key in keyboard than that item is binding row than i reading that value.is there any mouse evet for bind row after selection iteam . Please can suggest me.

Thanks
Sreeni

[sreeni379Member]

Hi Dimitar,

I change what ever you suggested but still have same problem, I am not read values from dropdownlists,Can you suggest me .
Thanks
Sree

[sreeni379Member]

Hi Dimitar,

is there any possibly for get valueMember of dropdownlist while reading a row.

Thanks
Sree

[sreeni379Member]

Hi Dimitar,

In grid can i have Ajax Auto complete text box using in grid using jquery ,user enter text based on list items has to display. It possible in cut some column create Ajax Auto-complete using jquery. If it is possible can suggested me.

Thanks
Sreeni

[sreeni379Member]

Hi Dimita,

Thanks for valuable help. it is help me lot. But here i have problem delete selected rows in grid.it is not happening to me to delete. if selected two rows from grid. if get row ids of selected whatever i selected two rows ids i am getting here but while deleting first record is deleting and second record is not deleting .following code i have written for delete rows in grid .

function GetExternalauserDetails() {

Exarr15 = [];
ExIndexesArray = [];
EXpageArray = [];

var rowscount = $(“#Exjqxgrid”).jqxGrid(‘getrows’).length;
var IndexesArray = new Array();
for (var i = 0; i < rowscount; i++) {
var ExvisibleIndex = $("#Exjqxgrid").jqxGrid('getrowvisibleindex', i);
IndexesArray.push({ bound: i, visible: ExvisibleIndex });
};
var paginginformation = $("#Exjqxgrid").jqxGrid('getpaginginformation');
var pagenum = paginginformation.pagenum;
var pagesize = paginginformation.pagesize;
var pageArray = new Array();

for (var j = 0; j = pagenum * pagesize && IndexesArray[j].visible 0) {
for (var i = 0; i < arr20.length; i++) {
//var row = $("#Injqxgrid").jqxGrid('getrowdata', arr20[i]);
// var row = $('#Injqxgrid').jqxGrid('getcellvalue', arr20[i], "UserID");
var row = $('#Injqxgrid').jqxGrid('getcell', arr20[i], "UserID");
arr20["UserID"] = row.UserID;
dataRecord4.push(arr20);
var id = $("#Injqxgrid").jqxGrid('getrowid', arr20[i]);
$("#Injqxgrid").jqxGrid('deleterow', id);

}

}
var val = JSON.stringify(dataRecord4);
debugger;
$.ajax({
url: '/UserAdmin/DeleteData',
type: 'POST',
data: val,
datatype: "json",
contentType: 'application/json; charset=utf-8',
success: function (result) {
}
});
arr20 = [];
}

Thanks
Sreeni

[sreeni379Member]

Hi Dimitar,

Last you post code is working fine ,but here if check box checked one page and if move different page there also showing checkbox column checked.

Here I need Selected pages should check box should check reaming unchecked.Please help me.

Thank
sree

[sreeni379Member]

Hi Dimitar,

Thank for your help.You posted code if change page, grid check box column clearing and previous selected column also clearing.

Here my requirement is selected check box column as keep same if move different page.selected check box column as keep selected if move different page .

How i can read rows from selected rows from different pages . if click save button what every selected pages as to clear or unchecked.This is my requirement please me.

Thanks
Sreeni

[sreeni379Member]

Hi Dimitar,

sorry ,last time I posted different method and wrong one,

In documention have one method for ‘setcolumnproperty’ .from the documention for ‘setcolumnproperty’ .Please check like for
‘setcolumnproperty’ .

http://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxgrid/jquery-grid-api.htm

$(‘#grid’).jqxGrid(‘setcolumnproperty’, ‘firstname’, ‘width’, 100,renderer: headercheckboxRenderer);

This Code i wrote for render method in Setcolumnproperty for grid,it not reneder it saying error.How can i write code for render for coulmn in Setcolumnproperty.

Thanks
Sreeni

[sreeni379Member]

Hi Dimitar,

Thanks for your help .Here I have problem with sorting.Is there any Sort concept for particular page. added sort concept to grid, if click any column in grid then it was selecting previous rows of before sorting in grid particular page.

Here I need If sort either one from this ASC, DESC.is there any concept for sorting for particular page and if sorted also i need selected that page elements only.

If there is no sorting concept for particular page ,help me if sort also it should be selecting that rows of that page only.

I am very happy see u quick replay .Can u Please help me.

Thanks
Sreeni

[sreeni379Member]

Hi Dimitar,

Thanks for your  help .Here I have problem with sorting.Is there any Sort concept for particular page. added sort concept to grid, if click any  column in grid then it was selecting previous rows of before sorting  in grid  particular page.

Here I need If sort either one from this ASC, DESC.is there any concept for sorting for particular page and if sorted also i need selected that page elements only.

If there is no sorting concept for particular page ,help me if sort also it should be selecting that rows of that page only.

I am very happy see u quick replay .Can u Please help me.

Thanks
Sreeni

[sreeni379Member]

Hi Peter Stoev,

In getdatainformation’ method used i was not getting any data of particular page. If right now I am second page and click the button I need to read second page rows from grid only.is there any method for this. Can you Please suggest to me .

Thanks
Sreeni

[sreeni379Member]

HI

Here What function i need call and set Settings as for u replay.I want code i need to put bindingcomplete event handler.Grid call back.

Can Suggest any code for this problem please.

[Author]

Posts