How to get DataGrid column's value by column number and variable ?

[Jonny]

Dear All,

             Currently, If i want to get value from datagrid field, i did like this:

row = $("#dg").datagrid("getSelected");
vname=row.productname;

Could you please tell me, how to capture value from field using column number & variabel ?

Column Number:
Imagine the field "productname" located on column number 3 in datagrid
Is there any technic to get the value from  "productname"  by using column number?
Imagine --> vname = row.getfromcol(3);

Variable:
Is there any technic to get the value from  "productname"  by using string variable?
this is my imagination:
field="productname"; 
vname = row.getfromfield(field);


Any help would be very appreciated...
thank you..

Regards,
JONNY

[jarry]

The following code can achieve this functionality.

Code:

function getSelectedValue(dg, field){
    var dg = $(dg);
    var row = dg.datagrid('getSelected');
    if (!row){return undefined;}
    var fields = dg.datagrid('getColumnFields',true).concat(dg.datagrid('getColumnFields',false));
    if (typeof field == 'number'){
        return row[fields[field]];
    } else {
        return row[field];
    }
}

Usage example:

Code:

var v1 = getSelectedValue('#dg', 3);
var v2 = getSelectedValue('#dg','productname');

[Jonny]

Thank you very much Jarry,

        Your solution is very good ( almost perfect ).
Both function works and get result succesfull.

But, I still unable get data when using variable that is not inside array...

For example,
I had field name -> "NETPRICE"  which is not listed in the datagrid
Because this column is not for public / standard user...
but it needed when comparing price...

Although I can get it using common way:
row = $("#dg").datagrid("getSelected");
vname=row.NETPRICE;

But I like the way you create that function...

So, please help me finalized the function that you gave..
Thanks in advance.


Regards,
JONNY

[jarry]

Please try the updated code. If a field does not be defined in the 'columns' or 'frozenColumns' properties, it can not be accessed by field index. But you still can access it by the field name.

Code:

var v2 = getSelectedValue('#dg','productname');
var v3 = getSelectedValue('#dg','NETPRICE');

[Jonny]

Thank you Jarry,

That is the perfect solution for me, no problem with the rule...
As always, I get helped successfully in this forum again..
 


Regards,
Jonny