.net导出excel
来源:互联网 发布:淘宝假货店铺名单2017 编辑:程序博客网 时间:2024/05/21 09:40
html页面
<form id="form1" runat="server"><div>
<asp:Button ID="cmdOpen" runat="server" Text="在线打开" CommandName="open" OnCommand="Button_Click" /> <asp:Button ID="cmdSave"runat="server" Text="本地保存" CommandName="save" OnCommand="Button_Click" />
<asp:DropDownList ID="listType" runat="server">
<asp:ListItem Value="excel">Excel</asp:ListItem>
<asp:ListItem Value="word">Word</asp:ListItem>
</asp:DropDownList><br />
<br />
数据源:<br />
<br />
<asp:GridView ID="myGW" runat="server">
</asp:GridView>
</div></form>
后台代码
protected void Page_Load(object sender, EventArgs e)
{
FillGridView();
}
private void OutPut(string fileType, string strType)
{
Response.Clear();
Response.Buffer = true;
Response.Charset = "GB2312";
Response.AppendHeader("Content-Disposition", fileType);
Response.ContentType = strType;
this.EnableViewState = false;
System.IO.StringWriter swOut = new System.IO.StringWriter();
HtmlTextWriter hTw = new HtmlTextWriter(swOut);
myGW.RenderControl(hTw);
Response.Write(swOut.ToString());
Response.End();
}
protected void Button_Click(object sender, CommandEventArgs e)
{
switch (e.CommandName)
{
case "save":
switch (listType.SelectedValue)
{
case "excel":
OutPut("attachment;filename=out.xls", "application/ms-excel");
break;
case "word":
OutPut("attachment;filename=out.doc", "application/ms-word");
break;
}
break;
case "open":
switch (listType.SelectedValue)
{
case "excel":
OutPut("online;filename=out.xls", "application/ms-excel");
break;
case "word":
OutPut("online;filename=out.doc", "application/ms-word");
break;
}
break;
}
}
public override void VerifyRenderingInServerForm(Control control)
{
}
private void FillGridView()
{
string strConn = "server=localhost\\sqlexpress;database=Northwind;user id=sa;password=sa123";
SqlConnection conn = new SqlConnection(strConn);
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
string strSql = "select * from Categories";
comm.CommandText = strSql;
conn.Open();
this.myGW.DataSource = comm.ExecuteReader();
this.myGW.DataBind();
conn.Close();
}
- asp.net导出excel
- asp.net导出Excel
- .NET----导出EXCEL
- asp.net导出excel
- NET导出Excel-1
- NET导出Excel-2
- .net 导出Excel报表
- asp.net导出Excel
- Asp.net 导出Excel
- asp.net导出excel
- .net导出Excel
- asp.net 导出excel
- .NET导出Excel文件
- .NET导出Excel文件
- asp.net 导出Excel
- .net 导出到Excel
- asp.net 导出 excel
- asp.net导出Excel
- 25个增强iOS应用程序性能的提示和技巧--高级篇
- 湖南工业大学个人选拔赛第一场 解题报告
- 2013-04-12
- Linux C内存泄露检测工具
- 商店管理系统源代码(十)
- .net导出excel
- 如何保证上传文件的安全性
- 静态函数,静态数据成员运用
- Android开发--Canvas高级使用
- 第五次上机实验
- 【Cocos2D-X 游戏引擎】初窥门径(5)CCAction:动作
- MySQL到NoSQL:数据的重思和查询方式的转换
- 建荣dm8261量产工具V1.8(12.06.19)
- 商店管理系统源代码(十一)