This is a migrated thread and some comments may be shown as answers.

get radnumeric value from radgrid

3 Answers 228 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Robert asked on 20 Jan 2012, 07:09 PM

hi everybody i have some problem for get the value of some radnumerictexbox in my footer template of my radgrid, i have to save this value in my database when the user push a button
this is my aspx code:

<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False"
                Width="1300px" GridLines="None" Skin="Sunset">
                <MasterTableView ShowFooter="true">
                    <Columns>
                        <telerik:GridBoundColumn DataField="COD_MATPRIMA" HeaderText="CODIGO">
                        </telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="NOMMATPRI" HeaderText="NOMBRE">
                        </telerik:GridBoundColumn>

                        <telerik:GridTemplateColumn UniqueName="Quantity" HeaderText="UNIDADES">
                            <ItemTemplate>
                                <telerik:RadNumericTextBox Type="Number" DataType="System.Decimal" Value="0" ID="unidadesTextBox" runat="server" Width="75">
                                    <NumberFormat   />
                                    <ClientEvents OnBlur="recalculate" />
                                </telerik:RadNumericTextBox>
                            </ItemTemplate>

                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn UniqueName="Price" HeaderText="VALOR UNITARIO">
                            <ItemTemplate>
                                <telerik:RadNumericTextBox Type="Number" DataType="System.Decimal" ID="ValorUnitarioTextBox" Value="0" runat="server" Width="75">
                                    <NumberFormat DecimalDigits="2" />
                                    <ClientEvents OnBlur="recalculate" />
                                </telerik:RadNumericTextBox>
                            </ItemTemplate>
                            <FooterTemplate>
                                Total:
                            </FooterTemplate>
                        </telerik:GridTemplateColumn>
                        <telerik:GridTemplateColumn UniqueName="Result" HeaderText="VALOR TOTAL">
                            <ItemTemplate>
                                <telerik:RadNumericTextBox Value="0" DataType="System.Double" ID="ResultTextBox" runat="server" ReadOnly="true">
                                    <NumberFormat
                                        PositivePattern="$ n" NegativePattern="- $ n"/>
                                </telerik:RadNumericTextBox>
                            </ItemTemplate>
                            <FooterTemplate>

3 Answers, 1 is accepted

answered on 21 Jan 2012, 01:09 PM

Hello,

<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">

<script type="text/javascript">

var footerlabel = null;

function setFooterlabel(lblobj) {

footerlabel = lblobj;

}

function ValueChanged(send, args) {

var grid = $find("<%= RadGrid1.ClientID %>");

var masterTableView = grid.get_masterTableView();

var sumtemp = 0;

var Rows = masterTableView.get_dataItems();

for (var i = 0; i < Rows.length; i++) {

var row = Rows[i];

var RadNumericTextBox1 = row.findControl("RadNumericTextBox1");

if (RadNumericTextBox1.get_value()) {

sumtemp = sumtemp + RadNumericTextBox1.get_value();

}

if (footerlabel != null) {

document.getElementById(footerlabel).outerText = sumtemp;

}

</script>

</telerik:RadCodeBlock>

<telerik:RadScriptManager ID="RadScriptManager1" runat="server">

</telerik:RadScriptManager>

<telerik:RadGrid ID="RadGrid1" runat="server" OnNeedDataSource="RadGrid1_NeedDataSource"

OnItemDataBound="RadGrid1_ItemDataBound" GridLines="None" OnItemCommand="RadGrid1_ItemCommand"

ShowFooter="true">

<MasterTableView AutoGenerateColumns="False">

<Columns>

<telerik:GridBoundColumn DataField="ID" UniqueName="ID">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn UniqueName="Test1" Resizable="false">

<ItemTemplate>

<telerik:RadNumericTextBox ID="RadNumericTextBox1" runat="server">

<ClientEvents OnValueChanged="ValueChanged" />

</telerik:RadNumericTextBox>

</ItemTemplate>

<FooterTemplate>

<asp:Label ID="Label1" runat="server" Text="0"></asp:Label>

</FooterTemplate>

</telerik:GridTemplateColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

DataTable dt = new DataTable();

dt.Columns.Add("ID");

dt.Columns.Add("Name");

dt.Columns.Add("IsAdd");

dt.Rows.Add(1, "Name1", false);

dt.Rows.Add(2, "Naem2", false);

dt.Rows.Add(3, "Name3", false);

Session["dt"] = dt;

}

protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)

{

RadGrid1.DataSource = (DataTable)Session["dt"];

}

protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)

{

if (e.Item is GridFooterItem)

{

GridFooterItem item = e.Item as GridFooterItem;

Label Label1 = item.FindControl("Label1") as Label;

this.Page.ClientScript.RegisterStartupScript(this.GetType(),"test","setFooterlabel('"+Label1.ClientID+"');",true);

}

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)

{

}

Thanks,
Jayesh Goyani