(思归大哥帮忙) Export to Excel问题
下面是我的转换方法:
Public Shared Sub Convert(ByVal ds As System.Data.DataSet, ByVal response As System.Web.HttpResponse)
response.Clear()
response.Charset = ""
response.ContentEncoding = System.Text.Encoding.Default
response.ContentType = "application/vnd.ms-excel"
Dim stringWrite As New System.IO.StringWriter()
Dim htmlWrite As New System.Web.UI.HtmlTextWriter(stringWrite)
Dim dg As New System.Web.UI.WebControls.DataGrid()
dg.DataSource = ds.Tables(0)
dg.DataBind()
dg.RenderControl(htmlWrite)
response.Write(stringWrite.ToString)
response.End()
End Sub
response.ContentEncoding =
这一句我用了各种
System.Text.Encoding.Default
System.Text.Encoding.GetEncoding("UTF-8")
System.Text.Encoding.UTF8
都是繁体行,可简体不行,乱码。
简体行了,繁体又不行。
我不知该如何解决?
我的数据库中数据绝对没问题,因为我用DataGrid都能正常显示,急呀!
还有哪位高手解决得了这个问题,望告知!!!