avevo immaginato da come mi hai risposto, non ti preoccupare, sto provando un work-around
avevo immaginato da come mi hai risposto, non ti preoccupare, sto provando un work-around
era ironico. Certo che lo sò cos'è un crosspage postbackOriginariamente inviato da realbenny
avevo immaginato da come mi hai risposto, non ti preoccupare, sto provando un work-around
I got the remedy
ok scusa, ho capito male, allora per tornare a noi mi hai chiesto
perchè la pagina che contiene i due ImageButton si chiama pagina.aspx.
Giusto?
no, si chiama in un altro modo es. pippo.aspx
Ho capito. Il problema è che hai inserito un evento. Ecco perchè non funziona.
Non ha senso fare un postback e utilizzare anche un evento.
I got the remedy
ok.
però come faccio a passare dei valori?
guarda questo esempio
http://msdn.microsoft.com/en-us/library/ms178139.aspx
I got the remedy
è quello che faccio, ma non cambia niente. ti posto il codice:
pagina con i vari bottoni .aspx
codice:<%@ Page Language="C#" MasterPageFile="~/BackofficeMaster.Master" AutoEventWireup="true" CodeBehind="ReportAbbonamenti.aspx.cs" Inherits="BackOffice.Edotto.ReportAbbonamenti" Title="::: SDI - Backoffice: Punto&Lex :::" %> <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %> <asp:Content ID="Content1" ContentPlaceHolderID="cphPaginaCentrale" runat="server"> <asp:HiddenField ID="hdfDataAttivazioneDal" runat="server" /> <asp:HiddenField ID="hdfDataAttivazioneAl" runat="server" /> <asp:HiddenField ID="hdfDataScadenzaDal" runat="server" /> <asp:HiddenField ID="hdfDataScadenzaAl" runat="server" /> <asp:HiddenField ID="hdfLoginSDI" runat="server" /> <table style="height: 495px; width: 773px;" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="center" valign="top" colspan="2" class="backendtitle" style="height: 30px;"> <ul>[*] [img]../images/transparent.gif[/img]GESTIONE PUNTO&LEX: ELENCO ABBONAMENTI [/list] </td> </tr> <tr> <td class="backendpatcenter" valign="top" style="height: 465px;"> <table style="width: 745px;" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="4"> <table border="0" cellpadding="0" cellspacing="0" width="500"> <tr> <td>[img]~/images/trasparent.gif[/img]</td> <td class="menuvocibackend" nowrap>Attivazione dal: </td> <td>[img]~/images/trasparent.gif[/img]</td> <td> <asp:TextBox ID="txtAttivazioneDal" runat="server" CssClass="inputboxbackend" AutoCompleteType="none" TabIndex="5"></asp:TextBox> <cc1:MaskedEditExtender ID="meeAttivazioneDal" runat="server" Mask="99/99/9999" MaskType="Date" TargetControlID="txtAttivazioneDal" /> <cc1:CalendarExtender CssClass="MyCalendar" PopupButtonID="imgbtnAttivazioneDal" ID="CalendarExtender1" TargetControlID="txtAttivazioneDal" Animated="true" Format="dd/MM/yyyy" runat="server"> </cc1:CalendarExtender> </td> <td align="left"> <asp:ImageButton ID="imgbtnAttivazioneDal" runat="server" ImageUrl="~/images/calendario.gif" TabIndex="11" CausesValidation="false" /> </td> <td class="menuvocibackend" nowrap>Attivazione al: </td> <td>[img]~/images/trasparent.gif[/img]</td> <td align="left"> <asp:TextBox ID="txtAttivazioneAl" runat="server" CssClass="inputboxbackend" AutoCompleteType="None" Width="142" TabIndex="6"></asp:TextBox> <cc1:MaskedEditExtender ID="meeAttivazioneAl" runat="server" Mask="99/99/9999" MaskType="Date" TargetControlID="txtAttivazioneAl" /> <cc1:CalendarExtender CssClass="MyCalendar" PopupButtonID="imgbtnAttivazioneAl" ID="CalendarExtender2" TargetControlID="txtAttivazioneAl" Animated="true" Format="dd/MM/yyyy" runat="server"> </cc1:CalendarExtender> </td> <td align="left"> <asp:ImageButton ID="imgbtnAttivazioneAl" runat="server" ImageUrl="~/images/calendario.gif" TabIndex="13" CausesValidation="false" /> </td> <td>[img]~/images/trasparent.gif[/img]</td> <td>[img]~/images/trasparent.gif[/img]</td> </tr> <tr> <td colspan="11" height="10">[img]~/images/trasparent.gif[/img]</td> </tr> <tr> <td>[img]~/images/trasparent.gif[/img]</td> <td class="menuvocibackend" nowrap>Scadenza dal: </td> <td>[img]~/images/trasparent.gif[/img]</td> <td> <asp:TextBox ID="txtDataDal" runat="server" CssClass="inputboxbackend" AutoCompleteType="none" TabIndex="10"></asp:TextBox> <cc1:MaskedEditExtender ID="meeDataDal" runat="server" Mask="99/99/9999" MaskType="Date" TargetControlID="txtDataDal" /> <cc1:CalendarExtender CssClass="MyCalendar" PopupButtonID="imgbtnDataDal" ID="cexDataDal" TargetControlID="txtDataDal" Animated="true" Format="dd/MM/yyyy" runat="server"> </cc1:CalendarExtender> </td> <td align="left"> <asp:ImageButton ID="imgbtnDataDal" runat="server" ImageUrl="~/images/calendario.gif" TabIndex="11" CausesValidation="false" /> </td> <td class="menuvocibackend" nowrap>Scadenza al: </td> <td>[img]~/images/trasparent.gif[/img]</td> <td align="left"> <asp:TextBox ID="txtDataAl" runat="server" CssClass="inputboxbackend" AutoCompleteType="None" Width="142" TabIndex="12"></asp:TextBox> <cc1:MaskedEditExtender ID="meeDataAl" runat="server" Mask="99/99/9999" MaskType="Date" TargetControlID="txtDataAl" /> <cc1:CalendarExtender CssClass="MyCalendar" PopupButtonID="imgbtnDataAl" ID="cexDataAl" TargetControlID="txtDataAl" Animated="true" Format="dd/MM/yyyy" runat="server"> </cc1:CalendarExtender> </td> <td align="left"> <asp:ImageButton ID="imgbtnDataAl" runat="server" ImageUrl="~/images/calendario.gif" TabIndex="13" CausesValidation="false" /> </td> <td>[img]~/images/trasparent.gif[/img]</td> <td>[img]~/images/trasparent.gif[/img]</td> </tr> <tr> <td colspan="11" height="10">[img]~/images/trasparent.gif[/img]</td> </tr> <tr> <td>[img]~/images/trasparent.gif[/img]</td> <td class="menuvocibackend">LoginSDI: </td> <td>[img]~/images/trasparent.gif[/img]</td> <td> <asp:TextBox ID="txtLogin" runat="server" CssClass="inputboxbackend" TabIndex="1"></asp:TextBox> <cc1:FilteredTextBoxExtender ID="ftbLogin" runat="server" TargetControlID="txtLogin" FilterType="UppercaseLetters, LowercaseLetters, Numbers" /> </td> <td>[img]~/images/trasparent.gif[/img]</td> <td colspan="6"> <table border="0" cellpadding="0" cellspacing="0" width="100%"> <tr> <td>[img]~/images/transparent.gif[/img]</td> <td align="right"><asp:ImageButton CausesValidation="true" ID="ImageButton1" runat="server" ImageUrl="~/images/avvia_ricerca.png" OnClick="imgbtnRicerca_Click" /></td> <td align="right"><asp:ImageButton ID="imgbtnAnnulla" runat="server" ImageUrl="~/images/cs_bt_annulla2.gif" OnClick="imgbtnAnnulla_Click" /></td> <td>[img]~/images/transparent.gif[/img]</td> </tr> </table> </td> </tr> <tr> <td colspan="11" height="10">[img]~/images/trasparent.gif[/img]</td> </tr> <tr> <td colspan="11"> <table border="0" width="500" cellpadding="0" cellspacing="0"> <tr> <td align="right" width="393"></td> <td width="50">[img]~/images/trasparent.gif[/img]</td> <td width="57"></td> <td>[img]~/images/trasparent.gif[/img]</td> <td>[img]~/images/trasparent.gif[/img]</td> </tr> </table> </td> </tr> </table> </td> </tr> <tr> <td colspan="4">[img]~/images/trasparent.gif[/img]</td> </tr> <tr> <td class="backendboxresultitle" width="70">Risultati</td> <td width="570">[img]../images/transparent.gif[/img]</td> <td width="80" class="menuvocibackend" valign="middle">Esporta in Excel</td> <td width="25"> <asp:ImageButton ID="ImageButton2" runat="server" ImageUrl="~/images/excel.png" AlternateText="Esporta in Excel" PostBackUrl="~/Edotto/ReportAbbonamentiExcel.aspx" /> </td> </tr> </table> </td> </tr> </table> </asp:Content>
.cs
codice:using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using BackOffice.classeutente; namespace BackOffice.Edotto { public partial class ReportAbbonamenti : System.Web.UI.Page { protected string dtDataDal = ""; protected string dtDataAl = ""; protected string dtAttivazioneDal = ""; protected string dtAttivazioneAl = ""; protected bool bEdit = false; protected void Page_Load(object sender, EventArgs e) { bool bEdit = false; Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.Cache.SetAllowResponseInBrowserHistory(false); IUserAuthentication iAuth = new UserAuthenticationManager(); HttpCookie authCookie = iAuth.CreateAuthenticationCookie(); ExecStoredProcedure esp = new ExecStoredProcedure(); if (Request.Cookies[FormsAuthentication.FormsCookieName] != null && iAuth.GetUtente.UtenteID > 0) { if (esp.checkUtente2Menu(iAuth.GetUtente.UtenteID, 1)) { Form.DefaultButton = this.ImageButton1.UniqueID; if (dtDataDal.ToString().Trim().Length > 0 && dtDataAl.ToString().Trim().Length > 0) { this.txtDataDal.Text = String.Format("{0:dd/MM/yyyy}", DateTime.Parse(dtDataDal)); this.txtDataAl.Text = String.Format("{0:dd/MM/yyyy}", DateTime.Parse(dtDataAl)); this.txtAttivazioneDal.Text = String.Format("{0:dd/MM/yyyy}", DateTime.Parse(dtAttivazioneDal)); this.txtAttivazioneAl.Text = String.Format("{0:dd/MM/yyyy}", DateTime.Parse(dtAttivazioneAl)); } else { if (!IsPostBack) { this.odsAbbonamenti.SelectParameters["dtDataScadenzaDal"].DefaultValue = "01/01/1900"; this.odsAbbonamenti.SelectParameters["dtDataScadenzaAl"].DefaultValue = "01/01/2100"; this.odsAbbonamenti.SelectParameters["dtDataAttivazioneDal"].DefaultValue = "01/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString(); this.odsAbbonamenti.SelectParameters["dtDataAttivazioneAl"].DefaultValue = DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month).ToString() + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year; this.txtAttivazioneDal.Text = "01/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString(); this.txtAttivazioneAl.Text = DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month).ToString() + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year; } } } else Response.Redirect("../Menu.aspx", true); } else Response.Redirect("../Login.aspx", true); } protected void imgbtnRicerca_Click(object sender, ImageClickEventArgs e) { this.odsAbbonamenti.SelectParameters["dtDataScadenzaDal"].DefaultValue = "01/01/1900"; this.odsAbbonamenti.SelectParameters["dtDataScadenzaAl"].DefaultValue = "01/01/2100"; this.odsAbbonamenti.SelectParameters["dtDataAttivazioneDal"].DefaultValue = "01/01/1900"; this.odsAbbonamenti.SelectParameters["dtDataAttivazioneAl"].DefaultValue = "01/01/2100"; this.odsAbbonamenti.SelectParameters["sLoginSDI"].DefaultValue = ""; IUserAuthentication iAuth = new UserAuthenticationManager(); HttpCookie authCookie = iAuth.CreateAuthenticationCookie(); if (Request.Cookies[FormsAuthentication.FormsCookieName] != null && iAuth.GetUtente.UtenteID > 0) { if (this.txtDataDal.Text.Trim().Length > 0 && this.txtDataAl.Text.Trim().Length > 0) { //DateTime DataDal = DateTime.Parse("01/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString()); //DateTime DataAl = DateTime.Parse(DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month).ToString() + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year); DateTime DataDal = DateTime.Parse(this.txtDataDal.Text); DateTime DataAl = DateTime.Parse(this.txtDataAl.Text).AddDays(1); if (DataAl > DataDal) { string sData = ""; dtDataDal = String.Format("{0:dd/MM/yyyy}", DataDal); dtDataAl = String.Format("{0:dd/MM/yyyy}", DataAl); this.odsAbbonamenti.SelectParameters["dtDataScadenzaDal"].DefaultValue = dtDataDal; this.odsAbbonamenti.SelectParameters["dtDataScadenzaAl"].DefaultValue = dtDataAl; } } if (this.txtAttivazioneDal.Text.Trim().Length > 0 && this.txtAttivazioneAl.Text.Trim().Length > 0) { //DateTime DataDal = DateTime.Parse("01/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString()); //DateTime DataAl = DateTime.Parse(DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month).ToString() + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year); DateTime DataDal = DateTime.Parse(this.txtAttivazioneDal.Text); DateTime DataAl = DateTime.Parse(this.txtAttivazioneAl.Text).AddDays(1); if (DataAl > DataDal) { string sData = ""; dtDataDal = String.Format("{0:dd/MM/yyyy}", DataDal); dtDataAl = String.Format("{0:dd/MM/yyyy}", DataAl); this.odsAbbonamenti.SelectParameters["dtDataAttivazioneDal"].DefaultValue = dtDataDal; this.odsAbbonamenti.SelectParameters["dtDataAttivazioneAl"].DefaultValue = dtDataAl; } } if (txtLogin.Text.Trim().Length > 0) { this.odsAbbonamenti.SelectParameters["sLoginSDI"].DefaultValue = txtLogin.Text; } this.gvwAbbonamenti.DataBind(); } else Response.Redirect("../Login.aspx", false); } protected void imgbtnAnnulla_Click(object sender, ImageClickEventArgs e) { IUserAuthentication iAuth = new UserAuthenticationManager(); HttpCookie authCookie = iAuth.CreateAuthenticationCookie(); if (Request.Cookies[FormsAuthentication.FormsCookieName] != null && iAuth.GetUtente.UtenteID > 0) { this.txtLogin.Text = ""; this.txtDataDal.Text = ""; this.txtDataAl.Text = ""; this.txtAttivazioneDal.Text = ""; this.txtAttivazioneAl.Text = ""; } else Response.Redirect("../Login.aspx", false); } //public override void VerifyRenderingInServerForm(Control control) //{ //} protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { if (this.gvwAbbonamenti.EditIndex <= 0) { this.hdfDataAttivazioneDal.Value = this.txtAttivazioneDal.Text; this.hdfDataAttivazioneAl.Value = this.txtAttivazioneAl.Text; this.hdfDataScadenzaDal.Value = this.txtDataDal.Text; this.hdfDataScadenzaAl.Value = this.txtDataAl.Text; this.hdfLoginSDI.Value = this.txtLogin.Text; //string sJavascript = "<script language=javascript>getExcel('" + this.hdfDataAttivazioneDal.Value + "', '" + this.hdfDataAttivazioneAl.Value + "', '" + this.hdfDataScadenzaDal.Value + "', '" + this.hdfDataScadenzaAl.Value + "', '" + this.hdfLoginSDI.Value + "')</script>"; //ClientScript.RegisterStartupScript(this.GetType(), "OpenNewWindow", sJavascript); //Response.Clear(); //Response.AddHeader("content-disposition", "attachment;filename=FileName.xls"); //Response.Charset = ""; //Response.ContentType = "application/vnd.ms-excel"; //System.IO.StringWriter stringWrite = new System.IO.StringWriter(); //System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); //this.gvwAbbonamenti.RenderControl(htmlWrite); //Response.Write(stringWrite.ToString()); //Response.End(); } } protected void gvwAbbonamenti_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.DataItemIndex >= 0) { Label lblEmail = (Label)e.Row.FindControl("lblEmail"); if (lblEmail != null) { if (lblEmail.Text.Trim().Length > 20) { lblEmail.Text = lblEmail.Text.Substring(0, 20) + "..."; } } else bEdit = true; if (bEdit) this.ImageButton2.Enabled = false; else this.ImageButton2.Enabled = true; switch (e.Row.Cells[6].Text) { case "1": e.Row.Cells[6].Text = "Carta di credito"; break; case "2": e.Row.Cells[6].Text = "Bonifico"; break; case "3": e.Row.Cells[6].Text = "SdiCard"; break; } } } } }
pagina chiamata in post .aspx
codice:<%@ Page Language="C#" MasterPageFile="~/BackofficeMaster.Master" EnableEventValidation="false" AutoEventWireup="true" CodeBehind="ReportAbbonamentiExcel.aspx.cs" Inherits="BackOffice.Edotto.ReportAbbonamentiExcel" Title="Untitled Page" %> <asp:Content ID="Content1" ContentPlaceHolderID="cphPaginaCentrale" runat="server"> <asp:GridView ID="gvwAbbonamenti" runat="server" AutoGenerateColumns="false" AllowPaging="false" AllowSorting="False" EmptyDataText="Nessun elemento presente" GridLines="None" Width="100%" EmptyDataRowStyle-CssClass="menuvocibackend2" DataSourceID="odsAbbonamenti" DataKeyNames="idAbbonamento" OnRowDataBound="gvwAbbonamenti_RowDataBound"> <AlternatingRowStyle BackColor="#e7e7e7" /> <Columns> <asp:BoundField DataField="IdTransazione" HeaderText="IdTransazione"> <ItemStyle Font-Bold="False" CssClass="backendtabelrow" /> <HeaderStyle CssClass="backendtableheadernoalignbianco" HorizontalAlign="Left" ForeColor="black" /> </asp:BoundField> <asp:BoundField DataField="loginSDI" HeaderText="LoginSDI"> <ItemStyle Font-Bold="False" CssClass="backendtabelrow" /> <HeaderStyle CssClass="backendtableheadernoalignbianco" HorizontalAlign="Left" ForeColor="black" /> </asp:BoundField> <asp:BoundField DataField="passwordSDI" HeaderText="PwdSDI" Visible="False"> <ItemStyle Font-Bold="False" CssClass="backendtabelrow" /> <HeaderStyle CssClass="backendtableheadernoalignbianco" /> </asp:BoundField> <asp:BoundField DataField="idDistributore" HeaderText="Distributore"> <ItemStyle Font-Bold="False" CssClass="backendtabelrow" /> <HeaderStyle CssClass="backendtableheadernoalignbianco" HorizontalAlign="Left" ForeColor="black" /> </asp:BoundField> <asp:BoundField DataField="loginEdotto" HeaderText="Login Edotto"> <ItemStyle Font-Bold="False" CssClass="backendtabelrow" /> <HeaderStyle CssClass="backendtableheadernoalignbianco" HorizontalAlign="Left" ForeColor="black" /> </asp:BoundField> <asp:BoundField DataField="passwordEDotto" HeaderText="Pwd Edotto"> <ItemStyle Font-Bold="False" CssClass="backendtabelrow" /> <HeaderStyle CssClass="backendtableheadernoalignbianco" HorizontalAlign="Left" ForeColor="black" /> </asp:BoundField> <asp:BoundField DataField="TipoPagamento" HeaderText="Pagamento"> <ItemStyle Font-Bold="False" CssClass="backendtabelrow" /> <HeaderStyle CssClass="backendtableheadernoalignbianco" HorizontalAlign="Left" ForeColor="black" /> </asp:BoundField> <asp:TemplateField ItemStyle-Width="110" HeaderText="Attivazione" ItemStyle-CssClass="backendtabelrow" HeaderStyle-ForeColor="black" HeaderStyle-CssClass="backendtableheadernoalignbianco" HeaderStyle-HorizontalAlign="Left" HeaderStyle-Wrap="false"> <ItemTemplate> <asp:Label ID="lblDataAttivazione" runat="server" Text='<%# Bind("dataAttivazione", "{0:dd/MM/yyyy}") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField ItemStyle-Width="110" HeaderText="Scadenza" ItemStyle-CssClass="backendtabelrow" HeaderStyle-ForeColor="black" HeaderStyle-CssClass="backendtableheadernoalignbianco" HeaderStyle-HorizontalAlign="Left" HeaderStyle-Wrap="false"> <ItemTemplate> <asp:Label ID="lblDataScandenza" runat="server" Text='<%# Bind("dataScadenza", "{0:dd/MM/yyyy}") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:BoundField DataField="flagProva" HeaderText="Prova"> <ItemStyle Font-Bold="False" CssClass="backendtabelrow" /> <HeaderStyle CssClass="backendtableheadernoalignbianco" HorizontalAlign="Left" ForeColor="black" /> </asp:BoundField> <asp:BoundField DataField="flagAbbonamento" HeaderText="Abbonamento"> <ItemStyle Font-Bold="False" CssClass="backendtabelrow" /> <HeaderStyle CssClass="backendtableheadernoalignbianco" HorizontalAlign="Left" ForeColor="black" /> </asp:BoundField> <asp:TemplateField ItemStyle-Width="160" HeaderText="Email" ItemStyle-CssClass="backendtabelrow" HeaderStyle-ForeColor="black" HeaderStyle-CssClass="backendtableheadernoalignbianco" HeaderStyle-HorizontalAlign="Left"> <ItemTemplate> <asp:Label ID="lblEmail" runat="server" Text='<%# Bind("eMail") %>' ToolTip='<%# Bind("eMail") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> <asp:ObjectDataSource ID="odsAbbonamenti" runat="server" OldValuesParameterFormatString="{0}" TypeName="BackOffice.BackofficeDataProvider" SelectMethod="GetAbbonamento" UpdateMethod="UpdAbbonamento"> <SelectParameters> <asp:FormParameter ConvertEmptyStringToNull="true" FormField="txtLogin" Name="sLoginSDI" Type="string" DefaultValue="" /> <asp:Parameter Name="sLoginEdotto" Type="string" DefaultValue="" ConvertEmptyStringToNull="true" /> <asp:Parameter Name="sPwdEdotto" Type="string" DefaultValue="" ConvertEmptyStringToNull="true" /> <asp:Parameter Name="dtDataAttivazioneDal" Type="DateTime" DefaultValue="01/01/1900" ConvertEmptyStringToNull="true" /> <asp:Parameter Name="dtDataAttivazioneAl" Type="DateTime" DefaultValue="01/01/2100" ConvertEmptyStringToNull="true" /> <asp:Parameter Name="dtDataScadenzaDal" Type="DateTime" DefaultValue="" ConvertEmptyStringToNull="true" /> <asp:Parameter Name="dtDataScadenzaAl" Type="DateTime" DefaultValue="" ConvertEmptyStringToNull="true" /> <asp:Parameter Name="bProva" Type="Char" DefaultValue="" ConvertEmptyStringToNull="true" /> <asp:Parameter Name="bAbbonamento" Type="Char" DefaultValue="" ConvertEmptyStringToNull="true" /> <asp:Parameter Name="sEmail" Type="string" DefaultValue="" ConvertEmptyStringToNull="true" /> </SelectParameters> </asp:ObjectDataSource> </asp:Content>
.cs
codice:using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; namespace BackOffice.Edotto { public partial class ReportAbbonamentiExcel : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (PreviousPage != null) { ContentPlaceHolder cph = (ContentPlaceHolder)PreviousPage.Master.FindControl("cphPaginaCentrale"); string sDataAttivazioneDal = ((TextBox)cph.FindControl("txtAttivazioneDal")).Text; string sDataAttivazioneAl = ((TextBox)cph.FindControl("txtAttivazioneAl")).Text; string sDataScadenzaDal = ((TextBox)cph.FindControl("txtDataDal")).Text; string sDataScadenzaAl = ((TextBox)cph.FindControl("txtDataAl")).Text; string sLoginSDI = ((TextBox)cph.FindControl("txtLogin")).Text; //string sDataAttivazioneDal = Request.Form["txtDataAttivazioneDal2"].ToString(); //string sDataAttivazioneAl = Request.Form["txtDataAttivazioneAl2"].ToString(); //string sDataScadenzaDal = Request.Form["txtDataScadenzaDal2"].ToString(); //string sDataScadenzaAl = Request.Form["txtDataScadenzaAl2"].ToString(); //string sLoginSDI = Request.Form["txtLoginSDI2"].ToString(); if (sDataAttivazioneDal.Trim().Length == 0) sDataAttivazioneDal = "01/01/1900"; if (sDataAttivazioneAl.Trim().Length == 0) sDataAttivazioneAl = "01/01/2100"; if (sDataScadenzaDal.Trim().Length == 0) sDataScadenzaDal = "01/01/1900"; if (sDataScadenzaAl.Trim().Length == 0) sDataScadenzaAl = "01/01/2100"; this.odsAbbonamenti.SelectParameters["dtDataAttivazioneDal"].DefaultValue = sDataAttivazioneDal; this.odsAbbonamenti.SelectParameters["dtDataAttivazioneAl"].DefaultValue = sDataAttivazioneAl; this.odsAbbonamenti.SelectParameters["dtDataScadenzaDal"].DefaultValue = sDataScadenzaDal; this.odsAbbonamenti.SelectParameters["dtDataScadenzaAl"].DefaultValue = sDataScadenzaAl; ; this.odsAbbonamenti.SelectParameters["sLoginSDI"].DefaultValue = sLoginSDI; this.gvwAbbonamenti.DataBind(); Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=FileName.xls"); Response.Charset = ""; Response.ContentType = "application/vnd.ms-excel"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); this.gvwAbbonamenti.RenderControl(htmlWrite); Response.Write(stringWrite.ToString()); Response.End(); } } } public override void VerifyRenderingInServerForm(Control control) { } protected void gvwAbbonamenti_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.DataItemIndex >= 0) { //Label lblEmail = (Label)e.Row.FindControl("lblEmail"); //if (lblEmail != null) //{ // if (lblEmail.Text.Trim().Length > 20) // { // lblEmail.Text = lblEmail.Text.Substring(0, 20) + "..."; // } //} switch (e.Row.Cells[6].Text) { case "1": e.Row.Cells[6].Text = "Carta di credito"; break; case "2": e.Row.Cells[6].Text = "Bonifico"; break; case "3": e.Row.Cells[6].Text = "SdiCard"; break; } } } } }
Permessi di invio
Rispondi quotando