or
<form id="form1" runat="server"><div> <telerik:RadScriptManager ID="RadScriptManager1" runat="server" /> <!-- content start --> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="RadGrid1"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="RadGrid1" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadGrid ID="RadGrid1" runat="server" ShowStatusBar="True" DataSourceID="SqlDataSource1" AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True" GridLines="None" ShowGroupPanel="True" AllowAutomaticDeletes="true" AllowAutomaticInserts="true" AllowAutomaticUpdates="true"> <HeaderContextMenu EnableImageSprites="True" CssClass="GridContextMenu GridContextMenu_Default"> </HeaderContextMenu> <MasterTableView DataSourceID="SqlDataSource1" AutoGenerateColumns="False" DataKeyNames="EmissionFactorGroupID" AllowMultiColumnSorting="True" PageSize="20" CommandItemDisplay="Bottom" CommandItemSettings-AddNewRecordText=" Add New Emission Factor Group" CommandItemSettings-ShowAddNewRecordButton="true" CommandItemSettings-ShowExportToExcelButton="true"> <DetailTables> <telerik:GridTableView DataKeyNames="EmissionFactorID" DataSourceID="SqlDataSource2" Width="100%" runat="server" AutoGenerateColumns="false" AllowFilteringByColumn="false" CommandItemDisplay="Bottom" CommandItemSettings-AddNewRecordText=" Add New Emission Factor" CommandItemSettings-ShowAddNewRecordButton="true"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="EmissionFactorGroupID" MasterKeyField="EmissionFactorGroupID" /> </ParentTableRelation> <DetailTables> <telerik:GridTableView DataKeyNames="EmissionGasBreakdownID" DataSourceID="SqlDataSource3" Width="100%" runat="server" AutoGenerateColumns="false" AllowFilteringByColumn="false" CommandItemDisplay="Bottom" CommandItemSettings-AddNewRecordText=" Add New Gas" CommandItemSettings-ShowAddNewRecordButton="true"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="EmissionFactorID" MasterKeyField="EmissionFactorID" /> </ParentTableRelation> <Columns> <telerik:GridBoundColumn Visible="false" ReadOnly="true" DataField="EmissionGasBreakdownID" DataType="System.Int32" SortExpression="EmissionGasBreakdownID" UniqueName="EmissionGasBreakdownID"> </telerik:GridBoundColumn> <telerik:GridBoundColumn Visible="false" ReadOnly="true" DataField="EmissionFactorID" SortExpression="EmissionFactorID" UniqueName="EmissionFactorID" DataType="System.Int32"> </telerik:GridBoundColumn> <telerik:GridDropDownColumn DropDownControlType="RadComboBox" DataType="System.Int32" DataField="GasID" HeaderText="Gas" SortExpression="GasID" UniqueName="GasID" DataSourceID="SqlDataSource4" ListTextField="GasName" ListValueField="EmissionGasID"> </telerik:GridDropDownColumn> <telerik:GridNumericColumn DataField="Factor" DataType="System.Decimal" HeaderText="Factor" SortExpression="Factor" UniqueName="Factor" KeepNotRoundedValue="true"> </telerik:GridNumericColumn> <telerik:GridBoundColumn DataField="UOM" HeaderText="UOM" SortExpression="UOM" UniqueName="UOM"> </telerik:GridBoundColumn> </Columns> </telerik:GridTableView> </DetailTables> <Columns> <telerik:GridBoundColumn Visible="false" ReadOnly="true" DataField="EmissionFactorID" DataType="System.Int32" HeaderText="EmissionFactorID" SortExpression="EmissionFactorID" UniqueName="EmissionFactorID"> </telerik:GridBoundColumn> <telerik:GridNumericColumn DataField="Factor" DataType="System.Decimal" HeaderText="Factor" SortExpression="Factor" UniqueName="Factor" KeepNotRoundedValue="true" AllowRounding="false" NumericType="Number" DataFormatString="{0:0.0000000000}"> </telerik:GridNumericColumn> <telerik:GridDateTimeColumn DataField="EffectiveFrom" DataType="System.DateTime" HeaderText="Effective From" SortExpression="EffectiveFrom" UniqueName="EffectiveFrom"> </telerik:GridDateTimeColumn> <telerik:GridDateTimeColumn DataField="EffectiveTo" DataType="System.DateTime" HeaderText="Effective To" SortExpression="EffectiveTo" UniqueName="EffectiveTo"> </telerik:GridDateTimeColumn> <telerik:GridBoundColumn DataField="Description" HeaderText="Description" SortExpression="Description" UniqueName="Description"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Source" HeaderText="Source" SortExpression="Source" UniqueName="Source"> </telerik:GridBoundColumn> <telerik:GridBoundColumn Visible="false" ReadOnly="true" DataField="EmissionFactorGroupID" DataType="System.Int32" HeaderText="EmissionFactorGroupID" SortExpression="EmissionFactorGroupID" UniqueName="EmissionFactorGroupID"> </telerik:GridBoundColumn> <telerik:GridNumericColumn DataField="IPCCTier" DataType="System.Byte" HeaderText="IPCC" SortExpression="IPCCTier" UniqueName="IPCCTier" HeaderStyle-Width="20px" ItemStyle-Width="20px" NumericType="Number"> </telerik:GridNumericColumn> </Columns> <CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings> <ExpandCollapseColumn Visible="True"> </ExpandCollapseColumn> </telerik:GridTableView> </DetailTables> <CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings> <RowIndicatorColumn> <HeaderStyle Width="20px"></HeaderStyle> </RowIndicatorColumn> <ExpandCollapseColumn> <HeaderStyle Width="20px"></HeaderStyle> </ExpandCollapseColumn> <Columns> <telerik:GridBoundColumn Visible="false" ReadOnly="true" DataField="EmissionFactorGroupID" DataType="System.Int32" HeaderText="EmissionFactorGroupID" SortExpression="EmissionFactorGroupID" UniqueName="EmissionFactorGroupID"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="GroupName" HeaderText="Group Name" SortExpression="GroupName" UniqueName="GroupName"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ResourceType" HeaderText="Resource Type" SortExpression="ResourceType" UniqueName="ResourceType"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ResourceName" HeaderText="Name" SortExpression="ResourceName" UniqueName="ResourceName"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ResourceUOM" HeaderText="UOM" SortExpression="ResourceUOM" UniqueName="ResourceUOM"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Region" HeaderText="Region" SortExpression="Region" UniqueName="Region"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="OwnerTenantID" HeaderText="Owner Tenant ID" SortExpression="OwnerTenantID" UniqueName="OwnerTenantID" DataType="System.Int32"> </telerik:GridBoundColumn> <telerik:GridCheckBoxColumn DataField="Shared" DataType="System.Boolean" HeaderText="Shared" SortExpression="Shared" UniqueName="Shared"> </telerik:GridCheckBoxColumn> </Columns> </MasterTableView> <ClientSettings AllowDragToGroup="True"> </ClientSettings> </telerik:RadGrid> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" DeleteCommand=" DELETE FROM [_FFEmissionGasBreakdown] WHERE [EmissionFactorID] IN (SELECT [EmissionFactorID] FROM [_FFEmissionFactor] WHERE ([EmissionFactorGroupID] = @EmissionFactorGroupID)); DELETE FROM [_FFEmissionFactor] WHERE [EmissionFactorGroupID] = @EmissionFactorGroupID; DELETE FROM [_FFEmissionFactorGroupToGroupSetLink] WHERE [EmissionFactorGroupID] = @EmissionFactorGroupID; DELETE FROM [_FFEmissionFactorGroup] WHERE [EmissionFactorGroupID] = @EmissionFactorGroupID; " InsertCommand=" INSERT INTO [_FFEmissionFactorGroup] ([GroupName], [ResourceType], [ResourceName], [ResourceUOM], [Region], [OwnerTenantID], [Shared]) VALUES (@GroupName, @ResourceType, @ResourceName, @ResourceUOM, @Region, @OwnerTenantID, @Shared); INSERT INTO [_FFEmissionFactorGroupToGroupSetLink] ([EmissionFactorGroupID], [EmissionFactorGroupSetID]) VALUES ((SELECT TOP 1 EmissionFactorGroupID FROM _FFEmissionFactorGroup ORDER BY EmissionFactorGroupID DESC), (SELECT TOP 1 EmissionFactorGroupSetID FROM _FFEmissionFactorGroupSet WHERE GroupSetOwnerTenantID = @OwnerTenantID)); " SelectCommand="SELECT * FROM [_FFEmissionFactorGroup] WHERE ([OwnerTenantID] = @OwnerTenantID) ORDER BY [Region], [GroupName], [ResourceUOM]" UpdateCommand="UPDATE [_FFEmissionFactorGroup] SET [GroupName] = @GroupName, [ResourceType] = @ResourceType, [ResourceName] = @ResourceName, [ResourceUOM] = @ResourceUOM, [Region] = @Region, [OwnerTenantID] = @OwnerTenantID, [Shared] = @Shared WHERE [EmissionFactorGroupID] = @EmissionFactorGroupID"> <SelectParameters> <asp:SessionParameter Name="OwnerTenantID" SessionField="OwnerTenantID" Type="Int32" /> </SelectParameters> <DeleteParameters> <asp:Parameter Name="EmissionFactorGroupID" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="GroupName" Type="String" /> <asp:Parameter Name="ResourceType" Type="String" /> <asp:Parameter Name="ResourceName" Type="String" /> <asp:Parameter Name="ResourceUOM" Type="String" /> <asp:Parameter Name="Region" Type="String" /> <asp:Parameter Name="OwnerTenantID" Type="Int32" /> <asp:Parameter Name="Shared" Type="Boolean" /> <asp:Parameter Name="EmissionFactorGroupID" Type="Int32" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="GroupName" Type="String" /> <asp:Parameter Name="ResourceType" Type="String" /> <asp:Parameter Name="ResourceName" Type="String" /> <asp:Parameter Name="ResourceUOM" Type="String" /> <asp:Parameter Name="Region" Type="String" /> <asp:SessionParameter Name="OwnerTenantID" SessionField="OwnerTenantID" Type="Int32" /> <asp:Parameter Name="Shared" Type="Boolean" /> </InsertParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" SelectCommand="SELECT [EmissionFactorID], [Factor], [EffectiveFrom], [EffectiveTo], [Description], [Source], [EmissionFactorGroupID], [IPCCTier] FROM [_FFEmissionFactor] WHERE ([EmissionFactorGroupID] = @EmissionFactorGroupID) ORDER BY [EffectiveFrom], [Description]" DeleteCommand="DELETE FROM [_FFEmissionGasBreakdown] WHERE [EmissionFactorID] = @EmissionFactorID; DELETE FROM [_FFEmissionFactor] WHERE [EmissionFactorID] = @EmissionFactorID" InsertCommand="INSERT INTO [_FFEmissionFactor] ([Factor], [EffectiveFrom], [EffectiveTo], [Description], [Source], [EmissionFactorGroupID], [IPCCTier], [MaterialID]) VALUES (@Factor, @EffectiveFrom, @EffectiveTo, @Description, @Source, @EmissionFactorGroupID, @IPCCTier, 1)" UpdateCommand="UPDATE [_FFEmissionFactor] SET [Factor] = @Factor, [EffectiveFrom] = @EffectiveFrom, [EffectiveTo] = @EffectiveTo, [Description] = @Description, [Source] = @Source, [IPCCTier] = @IPCCTier WHERE [EmissionFactorID] = @EmissionFactorID"> <SelectParameters> <asp:SessionParameter Name="EmissionFactorGroupID" SessionField="EmissionFactorGroupID" Type="Int32" /> </SelectParameters> <DeleteParameters> <asp:Parameter Name="EmissionFactorID" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="Factor" Type="Decimal" /> <asp:Parameter Name="EffectiveFrom" Type="DateTime" /> <asp:Parameter Name="EffectiveTo" Type="DateTime" /> <asp:Parameter Name="Description" Type="String" /> <asp:Parameter Name="Source" Type="String" /> <asp:SessionParameter Name="EmissionFactorGroupID" SessionField="EmissionFactorGroupID" Type="Int32" /> <asp:Parameter Name="IPCCTier" Type="Byte" /> <asp:Parameter Name="EmissionFactorID" Type="Int32" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="Factor" Type="Decimal" /> <asp:Parameter Name="EffectiveFrom" Type="DateTime" /> <asp:Parameter Name="EffectiveTo" Type="DateTime" /> <asp:Parameter Name="Description" Type="String" /> <asp:Parameter Name="Source" Type="String" /> <asp:Parameter Name="EmissionFactorGroupID" Type="Int32" /> <asp:Parameter Name="IPCCTier" Type="Byte" /> </InsertParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" DeleteCommand="DELETE FROM [_FFEmissionGasBreakdown] WHERE [EmissionGasBreakdownID] = @EmissionGasBreakdownID" InsertCommand="INSERT INTO [_FFEmissionGasBreakdown] ([EmissionFactorID], [GasID], [Factor], [UOM]) VALUES (@EmissionFactorID, @GasID, @Factor, @UOM)" SelectCommand="SELECT * FROM [_FFEmissionGasBreakdown] WHERE EmissionFactorID = @EmissionFactorID ORDER BY [GasID]" UpdateCommand="UPDATE [_FFEmissionGasBreakdown] SET [GasID] = @GasID, [Factor] = @Factor, [UOM] = @UOM WHERE [EmissionGasBreakdownID] = @EmissionGasBreakdownID"> <SelectParameters> <asp:SessionParameter Name="EmissionFactorID" SessionField="EmissionFactorID" Type="String" /> </SelectParameters> <DeleteParameters> <asp:Parameter Name="EmissionGasBreakdownID" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="GasID" Type="Int32" /> <asp:Parameter Name="Factor" Type="Decimal" /> <asp:Parameter Name="UOM" Type="String" /> <asp:Parameter Name="EmissionGasBreakdownID" Type="Int32" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="EmissionFactorID" Type="Int32" /> <asp:Parameter Name="GasID" Type="Int32" /> <asp:Parameter Name="Factor" Type="Decimal" /> <asp:Parameter Name="UOM" Type="String" /> </InsertParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>" SelectCommand="SELECT EmissionGasID, GasName FROM _FFEmissionGas Order By GasName" /></div></form>gviewFormBlok.MasterTableView.HierarchyDefaultExpanded = true; gviewFormBlok.ExportSettings.ExportOnlyData = true; gviewFormBlok.ExportSettings.IgnorePaging = true; gviewFormBlok.ExportSettings.OpenInNewWindow = true; gviewFormBlok.MasterTableView.ExportToExcel();
FilterControlAltText="Filter Facility column" ReadOnly="True"
HeaderText="Facility" SortExpression="Facility"
UniqueName="Facility">
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="keyup.Default" %><%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title> <script src="Scripts/jquery-1.4.1.min.js" type="text/javascript"></script> <style type="text/css"> fieldset { width:300px; } legend { color:Blue; } </style></head><body> <form id="form1" runat="server"> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> </telerik:RadScriptManager> <div> <fieldset> <legend>keyup</legend> <asp:TextBox ID="TextBox1" runat="server" onkeyup="onkeyup_TextBox1();"></asp:TextBox> <br /> <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox> </fieldset> <br /> <br /> <fieldset> <legend>keydown</legend> <asp:TextBox ID="TextBox3" runat="server" onkeydown="onkeydown_TextBox3();"></asp:TextBox> <br /> <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox> </fieldset> <br /> <br /> <fieldset> <legend>keypress</legend> <asp:TextBox ID="TextBox5" runat="server" onkeypress="onkeypress_TextBox5();"></asp:TextBox> <br /> <asp:TextBox ID="TextBox6" runat="server"></asp:TextBox> </fieldset> <br /> <br /> <fieldset> <legend>Telerik - keyup</legend> <telerik:RadNumericTextBox ID="RadNumericTextBox1" runat="server" DataType="System.Int32" onkeyup="onkeyup_RadNumericTextBox1();"> <NumberFormat DecimalDigits="0" /> </telerik:RadNumericTextBox> <br /> <telerik:RadNumericTextBox ID="RadNumericTextBox2" runat="server" DataType="System.Int32" Culture="fa-IR" Width="125px"> <NumberFormat DecimalDigits="0" /> </telerik:RadNumericTextBox> </fieldset> </div> <script type="text/javascript"> function onkeyup_TextBox1() { $('#TextBox2').val($('#TextBox1').val()); } function onkeydown_TextBox3() { $('#TextBox4').val($('#TextBox3').val()); } function onkeypress_TextBox5() { $('#TextBox6').val($('#TextBox5').val()); } function onkeyup_RadNumericTextBox1() { var RadNumericTextBox1 = $find("<%= RadNumericTextBox1.ClientID %>"); var RadNumericTextBox2 = $find("<%= RadNumericTextBox2.ClientID %>"); RadNumericTextBox2.set_value(RadNumericTextBox1.get_value()); } </script> </form></body></html>for my purpose onkeyup event on regular asp.net textbox controls is ok...
but it does n't work sometimes in telerik input controls!(there is no problem about onkeyup syntax , just when typing in first text box the other one have 1 character less , why ?)
which event should i use for telerik input controls for doing this job?
thanks in advance