or
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication3._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></head><body> <form id="form1" runat="server"> <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" height="200px" width="737px" HorizontalAlign="NotSet" LoadingPanelID="RadAjaxLoadingPanel1" RenderMode="Inline"> <div style="float:left; margin-left:20px"> <telerik:RadListBox runat="server" ID="RadListBox1" DataSourceID="SqlDataSource1" DataKeyField="mail" DataTextField="mail" DataSortField="mail" Height="200px" AllowTransfer="True" TransferToID="RadListBox2" AutoPostBackOnTransfer="True" DataValueField="mail" style="top: 0px; left: 0px; width: 222px" AllowAutomaticUpdates="True" TransferMode="Copy" /> </div> <div style="float:left; margin-left:20px;"> <telerik:RadListBox runat="server" ID="RadListBox2" DataSourceID="SqlDataSource2" DataKeyField="mail" DataTextField="mail" DataSortField="SortOrder" Width="230px" Height="200px" AllowReorder="True" AutoPostBackOnReorder="True" AllowDelete="True" AutoPostBackOnDelete="True" AllowAutomaticUpdates="True" DataValueField="mail" TransferToID="RadListBox1" /> </div> </telerik:RadAjaxPanel> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" Runat="server" Skin="Default"> </telerik:RadAjaxLoadingPanel> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:notifications_dbConnectionString %>" DeleteCommand="DELETE FROM [utilisateurs] WHERE [mail] = @mail" InsertCommand="INSERT INTO [utilisateurs] ([mail]) VALUES (@mail)" SelectCommand="SELECT [mail] FROM [utilisateurs]"> <DeleteParameters> <asp:Parameter Name="mail" Type="String" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="mail" Type="String" /> </InsertParameters> </asp:SqlDataSource> <telerik:RadScriptManager ID="RadScriptManager1" Runat="server"> </telerik:RadScriptManager> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:notifications_dbConnectionString %>" DeleteCommand="DELETE FROM [presents] WHERE [mail] = @mail AND [id_plan] = @id_plan" InsertCommand="INSERT INTO [presents] ([mail], [id_plan]) VALUES (@mail, @id_plan)" SelectCommand="SELECT [mail], [id_plan] FROM [presents]"> <DeleteParameters> <asp:Parameter Name="mail" Type="String" /> <asp:Parameter Name="id_plan" Type="Int32" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="mail" Type="String"/> <%--in my project the id_plan key is transferred with a link but you can do the same by adding to the current page adresse in the browser " ?id_plan=key" key could be 2 or 1 here --%> <asp:QueryStringParameter DefaultValue="2" Name="id_plan" QueryStringField="id_plan" Type="Int32" /> </InsertParameters> </asp:SqlDataSource> </form></body></html>
protected void ImgbtExcel_Click(object sender, ImageClickEventArgs e)
{
RadGridEmp.ExportSettings.ExportOnlyData =
true;
RadGridEmp.ExportSettings.IgnorePaging =
true;
RadGridEmp.ExportSettings.OpenInNewWindow =
true;
RadGridEmp.MasterTableView.ExportToExcel();
}
everytime it only save the current page.
<telerik:GridEditCommandColumn UniqueName="EditCommandColumn" EditImageUrl="/Common/Images/GridIcons/Edit.png" ButtonType="ImageButton" CancelImageUrl="/Common/Images/GridIcons/Cancel.png" UpdateImageUrl="/Common/Images/GridIcons/Save.png" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" ItemStyle-Wrap="false" ItemStyle-Width="60px" HeaderStyle-Width="60px" /><telerik:RadTabStrip ID="tsTabs" Align="Left" runat="server" Width="750px" AutoPostBack="True" ReorderTabsOnSelect="True" SelectedIndex="0" > <Tabs> <telerik:RadTab runat="server" Text="Main" ID="tabMain" /> <telerik:RadTab runat="server" Text="Addresses" ID="tabAddresses" /> <telerik:RadTab runat="server" Text="Phones" ID="tabPhones" /> <telerik:RadTab runat="server" Text="Notes" ID="tabNotes" /> <telerik:RadTab runat="server" Text="Quotes" ID="tabQuotes" /> <telerik:RadTab runat="server" Text="Remarket" ID="tabRemarket" /> <telerik:RadTab runat="server" Text="Research" ID="tabResearch" /> <telerik:RadTab runat="server" Text="Groups" ID="tabGroups" IsBreak="true" /> <telerik:RadTab runat="server" Text="Marketing" ID="tabMarketing" /> <telerik:RadTab runat="server" Text="Appts" ID="tabOtherInfo" /> <telerik:RadTab runat="server" Text="Files" ID="tabFiles" /> <telerik:RadTab runat="server" Text="PreSettlement" ID="tabPreSettlement" /> <telerik:RadTab runat="server" Text="Perms" ID="tabPermissions" /> <telerik:RadTab runat="server" Text="Admin" ID="tabAdmin" /> <telerik:RadTab runat="server" Text="Misc Info" ID="tabImportedInfo" /> <telerik:RadTab runat="server" Text="FedEx" ID="tabFedEx" /> </Tabs> </telerik:RadTabStrip><asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"> <telerik:RadScriptManager ID="RadScriptManager1" runat="server" EnableScriptLocalization="True"> </telerik:RadScriptManager> <div> <table cellpadding="0" cellspacing="0" width="100%"> <tr> <td> </td> </tr> <tr> <td><strong>Cadastro de educação </strong></td> </tr> <tr> <td> </td> </tr> <tr> <td>Nome: <asp:Label ID="lblNome" runat="server" Text=""></asp:Label> </td> </tr> <tr> <td> </td> </tr> <tr> <td>Tipo: <asp:DropDownList ID="dropTipo" runat="server" onselectedindexchanged="dropTipo_SelectedIndexChanged" AutoPostBack="True" DataSourceID="sqlTiposEducacao" DataTextField="tipoFluxo_desc" DataValueField="tipoFluxo_id"> </asp:DropDownList> <asp:SqlDataSource ID="sqlTiposEducacao" runat="server" ConnectionString="<%$ ConnectionStrings:GCConnectionString %>" SelectCommand="SELECT * FROM tipofluxo WHERE tipofluxo_id >= 1 and tipofluxo_id <= 8"></asp:SqlDataSource> <asp:Label ID="lblEspecifique" runat="server" Text="Especifique:" Visible="false"></asp:Label> <asp:TextBox ID="txtEspecifique" runat="server" Width="260px" Visible="false" ValidationGroup="form"></asp:TextBox> </td> </tr> <tr> <td> </td> </tr> <tr> <td> Data de inÃcio: <asp:TextBox ID="txtDataInicio" runat="server" ValidationGroup="form" ></asp:TextBox> mm/aaaa <asp:RequiredFieldValidator ID="rfvDataInicio" runat="server" ControlToValidate="txtDataInicio" ErrorMessage="*" ValidationGroup="form"></asp:RequiredFieldValidator> </td> </tr> <tr> <td> </td> </tr> <tr> <td> Data de término: <asp:TextBox ID="txtDataTermino" runat="server" ValidationGroup="form" ></asp:TextBox> mm/aaaa <asp:RequiredFieldValidator ID="rfvDataTermino" runat="server" ControlToValidate="txtDataTermino" ErrorMessage="*" ValidationGroup="form"></asp:RequiredFieldValidator> </td> </tr> <tr> <td> </td> </tr> <tr> <td> Valor anual: <telerik:RadNumericTextBox ID="txtValorAnual" runat="server" Culture="pt-BR" Type="Currency" Width="125px" > </telerik:RadNumericTextBox> ou Valor mensal: <telerik:RadNumericTextBox ID="txtValorMensal" runat="server" Culture="pt-BR" Type="Currency" Width="125px" > </telerik:RadNumericTextBox> </td> </tr> <tr> <td> </td> </tr> <tr> <td align="center" class="style1"> <asp:LinkButton ID="btnSalvar" runat="server" Text="Salvar" onclick="btnSalvar_Click" ValidationGroup="form"/> <asp:LinkButton ID="btnExcluir" runat="server" Text="Excluir" onclick="btnExcluir_Click" /> <asp:HyperLink ID="linkCancelar" runat="server" NavigateUrl="~/educacao.aspx">Cancelar</asp:HyperLink> </td> </tr> </table> </div> </asp:Content>