问题是:datagrid导出的excel在打开时候出现乱码。如何处理??谢谢。
原代码如下:
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
Me.EnableViewState = False
Dim sw As System.IO.StringWriter = New System.IO.StringWriter
Dim hw As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(sw)
Dim ncur As Int32 = dg_detail.CurrentPageIndex
Dim nsize As Int32 = dg_detail.PageSize
dg_detail.AllowPaging = False
Call Me.binddata()
' int nCur = dgShow.CurrentPageIndex;
'int nSize = dgShow.PageSize;
' dgShow.AllowPaging = false;
'BindData();
Me.dg_detail.Columns(4).Visible = False
Me.dg_detail.Columns(5).Visible = False
Me.dg_detail.RenderControl(hw)
Me.dg_detail.Columns(4).Visible = True
Me.dg_detail.Columns(5).Visible = True dg_detail.AllowPaging = True
dg_detail.CurrentPageIndex = ncur
dg_detail.PageSize = nsize
Call Me.binddata() 'dgShow.AllowPaging = true;
'dgShow.CurrentPageIndex = nCur;
'dgShow.PageSize = nSize;
'BindData(); 'System.IO.StringWriter sw = new System.IO.StringWriter();
' System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); ' dgShow.RenderControl(hw); Response.Write(sw.ToString())
Response.End()
不胜感激~!
原代码如下:
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
Me.EnableViewState = False
Dim sw As System.IO.StringWriter = New System.IO.StringWriter
Dim hw As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(sw)
Dim ncur As Int32 = dg_detail.CurrentPageIndex
Dim nsize As Int32 = dg_detail.PageSize
dg_detail.AllowPaging = False
Call Me.binddata()
' int nCur = dgShow.CurrentPageIndex;
'int nSize = dgShow.PageSize;
' dgShow.AllowPaging = false;
'BindData();
Me.dg_detail.Columns(4).Visible = False
Me.dg_detail.Columns(5).Visible = False
Me.dg_detail.RenderControl(hw)
Me.dg_detail.Columns(4).Visible = True
Me.dg_detail.Columns(5).Visible = True dg_detail.AllowPaging = True
dg_detail.CurrentPageIndex = ncur
dg_detail.PageSize = nsize
Call Me.binddata() 'dgShow.AllowPaging = true;
'dgShow.CurrentPageIndex = nCur;
'dgShow.PageSize = nSize;
'BindData(); 'System.IO.StringWriter sw = new System.IO.StringWriter();
' System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); ' dgShow.RenderControl(hw); Response.Write(sw.ToString())
Response.End()
不胜感激~!
解决方案 »
- 如何在框架中打开一个新页面的同时,刷新框架的新页面
- 请问静态页面(htm)如果嵌套.aspx页面进来
- SqlDataAdapter.SelectCommand ??问题请教
- 怎样在.cs中编写关闭当前aspx窗口的代码?
- 在线等!如何让windows services 在每天凌晨3点钟执行
- ???一个ajax.net的小问题,请各位指教,求了很长时间了
- 时间的正则,我想取他的反的怎么写呀?
- 找到DataList中<SelectedItemTemplate>中的控件
- 论坛里点击每个帖子前面的图标或是加号,就直接在下面列出所有的回复,这样的功能如何实现?
- 我在点击排序列时,出现错误!!
- C#向access插入数据时出错
- 这一段用Jmail发邮件的代码有什么问题,为什么不出错,但是邮件又收不到
Response.ContentType = "application/ms-excel";