Encoding issue..

  • Thread starter Thread starter elangovan.cse
  • Start date Start date
E

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.
 
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.
Click to expand...

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