get numerictextbox value based on rowindex

[Loyal User]

hello all ,

I have a radgrid that contains a Template column with radnumericTextBox ,
Users will fill these numericTextBox, every textbox should have a value less than previous one ,

<telerik:GridTemplateColumn HeaderText="value" UniqueName="value">

<ItemTemplate>            
 <telerik:RadNumericTextBox runat="server" ID="value" NumberFormat-AllowRounding="false" >

     <NumberFormat GroupSeparator=""/>

    <ClientEvents OnValueChanged="checkValues" />  

    </telerik:RadNumericTextBox>

</ItemTemplate>           
 </telerik:GridTemplateColumn>

if user add 20 in first row ,
second row should contains 20 or less ...

in "checkValues" function , i want to read value of previous row to compare with current value ..
how can i get it based on row index ?



How can i achieve this task ?

[Shinu]

Hi,

Please have a look into the following code snippet which works fine at my end.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="false" DataSourceID="SqlDataSource1"
    AllowPaging="true" OnItemDataBound="RadGrid1_ItemDataBound">
    <MasterTableView DataKeyNames="OrderID">
        <Columns>
            <telerik:GridBoundColumn UniqueName="OrderID" DataField="OrderID" HeaderText="OrderID">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="ShipCity" HeaderText="ShipCity" UniqueName="ShipCity" />
            <telerik:GridTemplateColumn HeaderText="value" UniqueName="value">
                <ItemTemplate>
                    <telerik:RadNumericTextBox runat="server" ID="value" NumberFormat-AllowRounding="false">
                        <NumberFormat GroupSeparator="" />
                        <ClientEvents OnValueChanged="checkValues" />
                    </telerik:RadNumericTextBox>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>

C#:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
    if (e.Item is GridDataItem)
    {
        GridDataItem item = e.Item as GridDataItem;
        RadNumericTextBox Editbtn = item.FindControl("value") as RadNumericTextBox;
        Editbtn.Attributes.Add("rowindex", item.ItemIndex.ToString());
    }
}

JavaScript:

<script type="text/javascript">
    function checkValues(sender, args) {
        var radGrid = $find('<%=RadGrid1.ClientID %>');
        var masterTable = radGrid.get_masterTableView();
        var row = sender._element.getAttribute("rowindex");
        if (row != 0) {
            for (var i = 0; i < row; i++) {
                if (masterTable.get_dataItems()[i].findControl("value").get_value() < args.get_newValue()) {
                    sender.set_value(" ");
                    sender.focus();
                }
            }
        }
    }
</script>

Thanks,
Shinu.

[Loyal User]

thanks a lot Shinu ,
that's exactly what i was looking for  ..

but i still have a question :
when user add a value , the algorithm (for loop) compare new value with all previous values,
no problem with results ,
but , Is there  another way to prevent looping all grid in each check validation ??
only compare it with previous ...

[Loyal User]

to avoid looping, i have delete "for loop" and compare value with previous (row-1) :

if (masterTable.get_dataItems()[row-1].findControl("commissionTxt").get_value() < args.get_newValue()) ...

thanks a lot ..