Encoding issue..

[elangovan.cse]

Hi all,
I'm exporting a datagrid to an excel file.
I'm using the following source code to export
DataTable dt = new DataTable();

DataAccess.StoredProcedure sproc = new
DataAccess.StoredProcedure("sproc_getdata");
sproc.Run(dt);
DataGrid1.DataSource = dt;
DataGrid1.DataBind();
DataGrid1.EnableViewState = false;
DataGrid1.Visible = true;
DataGrid1.GridLines = GridLines.Both;
Response.Clear();
Response.Buffer = true;
Response.AddHeader( "Content-Disposition", "filename=File1.xls");

StringWriter stringWriter = new StringWriter();
HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter);
DataGrid1.RenderControl(htmlWriter);
Response.Write(stringWriter.ToString());
Response.ContentType="application/vnd.ms-excel";
Response.End();

Its working fine.
but there is an isuue datagrid contains extended language
strings(like chinese, japanese).These stringsare not getting exported
into excel.
DataGrid is getting data from SQLServer2005 database. I know that
sqlserver is using utf-16 encoding for unicode character. So i've tried
to change Response.ContentEncoding to utf-16. But it is also not
working.

Can anyone help me.

 

[Jon Skeet [C# MVP]]

Its working fine.
but there is an isuue datagrid contains extended language
strings(like chinese, japanese).These stringsare not getting exported
into excel.
DataGrid is getting data from SQLServer2005 database. I know that
sqlserver is using utf-16 encoding for unicode character. So i've tried
to change Response.ContentEncoding to utf-16. But it is also not
working.

Can anyone help me.

See http://www.pobox.com/~skeet/csharp/debuggingunicode.html for a
short guide to solving this kind of issue.