Click here to Skip to main content
       

ASP.NET

 
Questionhow to redirect in a url? PinmemberJassim Rahma17-Jan-13 9:42 
AnswerRe: how to redirect in a url? PinmemberParwej Ahamad18-Jan-13 7:17 
GeneralRe: how to redirect in a url? PinmemberJassim Rahma18-Jan-13 7:36 
GeneralRe: how to redirect in a url? PinmemberParwej Ahamad18-Jan-13 17:23 
AnswerRe: how to redirect in a url? PinmemberRekhash18-Jan-13 23:01 
QuestionHow to add KML file to google Map using javascript in asp.net PinmemberTrivikramarao Vurubandi17-Jan-13 0:40 
QuestionExport data in Excel(xlsx) without using Excel Object from Datatable. Pinmembermca_rameshkumar16-Jan-13 22:00 
AnswerRe: Export data in Excel(xlsx) without using Excel Object from Datatable. Pingroupchester_it2118-Jan-13 6:52 
Redirect/open window to pageListForExportExcel.aspx in page1.aspx
so in page1 set input button to redirect/open window to pageListForExportExcel.aspx
in page1 :
 
<input type="button" value="Export to Excel" onclick="ExportToExcel()"/>

and you need javascript or JQuery for create function redirect/open window to pageListForExportExcel.aspx
 
  <script type="text/javascript">
  		function ExportToExcel() 
		{
			var txt = window.open("pageListForExportExcel.aspx");
		}
  </script>
 

in ASPX (pageListForExportExcel.aspx), use repeater for display you data from datatable,Example set to be this :
<%@ Page Language="C#" AutoEventWireup="true" EnableSessionState="ReadOnly" EnableViewState="false" CodeBehind="BukuInduk_exportToExcel.aspx.cs" Inherits="LimSys.Web.Laporan.BukuInduk_exportToExcel" %>
		<asp:Repeater ID="rep1" runat="server">
			<HeaderTemplate>
				<table border=1>
					<tr>
						<td>NAME</td>
						<td>ADDRESS</td>
						<td>TELP</td>
						<td>GENDER</td>
					</tr>
			</HeaderTemplate>
			<ItemTemplate>
					<tr>
						<td><%# Eval("name")%></td>
						<td><%# Eval("address")%></td>
						<td><%# Eval("telp")%></td>
						<td><%# Eval("gender")%></td>
					</tr>
			</ItemTemplate>
			<FooterTemplate>
				</table>
			</FooterTemplate>
		</asp:Repeater>
 
and the last,in code behind pageListForExportExcel.aspx.cs
use this :
 
         protected void Page_Load(object sender, EventArgs e)
        {
            Response.Clear();// this for clear any response
            Response.Buffer = true; // and then set to Buffer is true
            Response.ContentType = "application/vnd.ms-excel";// and this is for call type what you want to set File extention for save....you can export to pdf ,if you change value Response.ContentType

            var process = new DataLayersCollections();//set here by name your BusinesLogic
            var list = process.GetListFromDataTable(); //set here by name your functions  
            rep1.DataSource = list;
            rep1.DataBind();
        }
 
and the latter again .......
good luck ....
hope this help you.....Big Grin | :-D
QuestionButton or ImageButton? PinmemberJassim Rahma16-Jan-13 9:40 
AnswerRe: Button or ImageButton? Pinmemberjkirkerx16-Jan-13 12:40 
QuestionGoogle Translate vb.net PinmemberDotNetFellow15-Jan-13 22:31 
AnswerRe: Google Translate vb.net PinmvpSandeep Mewara16-Jan-13 2:57 
Questionunzipping file in host ? Pinmemberjojoba201115-Jan-13 17:59 
AnswerRe: unzipping file in host ? PinmemberVani Kulkarni16-Jan-13 2:44 
QuestionRe: unzipping file in host ? Pinmemberjojoba201116-Jan-13 7:41 
QuestionProblem with MapPageRoute.. PinmemberJassim Rahma15-Jan-13 10:06 
AnswerRe: Problem with MapPageRoute.. PinmentorBrij15-Jan-13 17:30 
AnswerRe: Problem with MapPageRoute.. PinmvpRichard MacCutchan15-Jan-13 23:02 
Questionhow to install downloaded nested master page template??? PinmemberMember 876986514-Jan-13 3:25 
AnswerRe: how to install downloaded nested master page template??? PinmentorBrij15-Jan-13 18:10 
AnswerRe: how to install downloaded nested master page template??? PinmvpSandeep Mewara15-Jan-13 18:19 
QuestionA strange problem Pinmemberindian14313-Jan-13 22:00 
AnswerRe: A strange problem PinmentorAbhijit Jana14-Jan-13 7:52 
GeneralRe: A strange problem Pinmemberindian14314-Jan-13 13:15 
Questionhow to MapPageRoute this? PinmemberJassim Rahma13-Jan-13 10:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web01 | 2.8.141029.1 | Last Updated 30 Oct 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid