Click here to Skip to main content
13,357,530 members (70,735 online)
   

ASP.NET

 
AnswerRe: How can we export data into csv format in c#.net Pin
Sandeep Mewara19-Jan-13 6:54
mvpSandeep Mewara19-Jan-13 6:54 
QuestionHow to asp:Literal with more..? Pin
Jassim Rahma18-Jan-13 4:19
memberJassim Rahma18-Jan-13 4:19 
AnswerRe: How to asp:Literal with more..? Pin
Parwej Ahamad18-Jan-13 8:13
memberParwej Ahamad18-Jan-13 8:13 
AnswerRe: How to asp:Literal with more..? Pin
Nandakishorerao18-Jan-13 22:46
memberNandakishorerao18-Jan-13 22:46 
QuestionTracking Emails Pin
Jaison Joe17-Jan-13 18:49
memberJaison Joe17-Jan-13 18:49 
QuestionHow to add KML file to google Map using javascript in asp.net Pin
Trivikramarao Vurubandi17-Jan-13 1:40
memberTrivikramarao Vurubandi17-Jan-13 1:40 
QuestionExport data in Excel(xlsx) without using Excel Object from Datatable. Pin
mca_rameshkumar16-Jan-13 23:00
membermca_rameshkumar16-Jan-13 23:00 
AnswerRe: Export data in Excel(xlsx) without using Excel Object from Datatable. Pin
chester_it2118-Jan-13 7:52
groupchester_it2118-Jan-13 7: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? Pin
Jassim Rahma16-Jan-13 10:40
memberJassim Rahma16-Jan-13 10:40 
AnswerRe: Button or ImageButton? Pin
jkirkerx16-Jan-13 13:40
memberjkirkerx16-Jan-13 13:40 
QuestionGoogle Translate vb.net Pin
DotNetFellow15-Jan-13 23:31
memberDotNetFellow15-Jan-13 23:31 
AnswerRe: Google Translate vb.net Pin
Sandeep Mewara16-Jan-13 3:57
mvpSandeep Mewara16-Jan-13 3:57 
Questionunzipping file in host ? Pin
jojoba201115-Jan-13 18:59
memberjojoba201115-Jan-13 18:59 
AnswerRe: unzipping file in host ? Pin
Vani Kulkarni16-Jan-13 3:44
memberVani Kulkarni16-Jan-13 3:44 
QuestionRe: unzipping file in host ? Pin
jojoba201116-Jan-13 8:41
memberjojoba201116-Jan-13 8:41 
Questionhow to install downloaded nested master page template??? Pin
Member 876986514-Jan-13 4:25
memberMember 876986514-Jan-13 4:25 
AnswerRe: how to install downloaded nested master page template??? Pin
Brij15-Jan-13 19:10
mentorBrij15-Jan-13 19:10 
AnswerRe: how to install downloaded nested master page template??? Pin
Sandeep Mewara15-Jan-13 19:19
mvpSandeep Mewara15-Jan-13 19:19 
QuestionImage Export Issue Pin
ashu_12311-Jan-13 7:54
memberashu_12311-Jan-13 7:54 
AnswerRe: Image Export Issue Pin
jkirkerx13-Jan-13 14:29
memberjkirkerx13-Jan-13 14:29 
QuestionDisable Pop-up Blocker Pin
arunmisra10-Jan-13 9:32
memberarunmisra10-Jan-13 9:32 
AnswerRe: Disable Pop-up Blocker Pin
jkirkerx10-Jan-13 13:46
memberjkirkerx10-Jan-13 13:46 
AnswerRe: Disable Pop-up Blocker Pin
Richard MacCutchan10-Jan-13 22:54
mvpRichard MacCutchan10-Jan-13 22:54 
GeneralRe: Disable Pop-up Blocker Pin
arunmisra11-Jan-13 12:22
memberarunmisra11-Jan-13 12:22 
JokeRe: Disable Pop-up Blocker Pin
jkirkerx13-Jan-13 14:31
memberjkirkerx13-Jan-13 14:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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 |
Web01 | 2.8.180111.1 | Last Updated 23 Jan 2018
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid