Export to excel.

[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.Stor edProcedure sproc = new
DataAccess.Stor edProcedure("sp roc_getdata");

sproc.Run(dt);

DataGrid1.DataS ource = dt;

DataGrid1.DataB ind();

DataGrid1.Enabl eViewState = false;

DataGrid1.Visib le = true;

DataGrid1.GridL ines = GridLines.Both;

Response.Clear( );

Response.Buffer = true;

Response.AddHea der( "Content-Disposition", "filename=File1 .xls");
StringWriter stringWriter = new StringWriter();

HtmlTextWriter htmlWriter = new HtmlTextWriter( stringWriter);

DataGrid1.Rende rControl(htmlWr iter);

Response.Write( stringWriter.To String());

Response.Conten tType="applicat ion/vnd.ms-excel";

Response.End();

Its working fine.

but there is an isuue datagrid dt contains extended language
strings (like chinese, japanese).These strings are not getting
exported to 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.Conten tEncoding to utf-16. But it is also not
working.

Can anyone help me.

[Code Monkey]

What datatypes are you database columns?
If they are not nvarchars (or similar) you haven't got a hope of
getting the unicode data out.
el***********@g mail.com wrote:

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.Stor edProcedure sproc = new
DataAccess.Stor edProcedure("sp roc_getdata");

sproc.Run(dt);

DataGrid1.DataS ource = dt;

DataGrid1.DataB ind();

DataGrid1.Enabl eViewState = false;

DataGrid1.Visib le = true;

DataGrid1.GridL ines = GridLines.Both;

Response.Clear( );

Response.Buffer = true;

Response.AddHea der( "Content-Disposition", "filename=File1 .xls");
StringWriter stringWriter = new StringWriter();

HtmlTextWriter htmlWriter = new HtmlTextWriter( stringWriter);

DataGrid1.Rende rControl(htmlWr iter);

Response.Write( stringWriter.To String());

Response.Conten tType="applicat ion/vnd.ms-excel";

Response.End();

Its working fine.

but there is an isuue datagrid dt contains extended language
strings (like chinese, japanese).These strings are not getting
exported to 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.Conten tEncoding to utf-16. But it is also not
working.

Can anyone help me.

[elangovan.cse]

Code Monkey wrote:

What datatypes are you database columns?
If they are not nvarchars (or similar) you haven't got a hope of
getting the unicode data out.

they are nvarchar only..
The datagrid is showing all the characters..
without the line Response.Conten tType="applicat ion/vnd.ms-excel"; i'm
getting correct output

[Code Monkey]

Just an idea....

I've got similar code in one of my web-apps, but I'm using
<code>
GridView1.DataS ource = myDataTable;
GridView1.DataB ind();
Response.Clear( );

Response.AddHea der("content-disposition",
"attachment;fil ename=myFileNam e.xls");
Response.Charse t = "";
Response.Conten tType = "applicatio n/vnd.xls";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter( stringWrite);
GridView1.Rende rControl(htmlWr ite);
Response.Write( stringWrite.ToS tring());
Response.End();

</code>

Works everytime for me!

el***********@g mail.com wrote:

Code Monkey wrote:

What datatypes are you database columns?
If they are not nvarchars (or similar) you haven't got a hope of
getting the unicode data out.

they are nvarchar only..
The datagrid is showing all the characters..
without the line Response.Conten tType="applicat ion/vnd.ms-excel"; i'm
getting correct output

[Code Monkey]

In case you haven't spotted it...look at the ContentType line!
Code Monkey wrote:

Just an idea....

I've got similar code in one of my web-apps, but I'm using
<code>
GridView1.DataS ource = myDataTable;
GridView1.DataB ind();
Response.Clear( );

Response.AddHea der("content-disposition",
"attachment;fil ename=myFileNam e.xls");
Response.Charse t = "";
Response.Conten tType = "applicatio n/vnd.xls";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter( stringWrite);
GridView1.Rende rControl(htmlWr ite);
Response.Write( stringWrite.ToS tring());
Response.End();

</code>

Works everytime for me!

el***********@g mail.com wrote:

Code Monkey wrote:

What datatypes are you database columns?
If they are not nvarchars (or similar) you haven't got a hope of
getting the unicode data out.
>
>

they are nvarchar only..
The datagrid is showing all the characters..
without the line Response.Conten tType="applicat ion/vnd.ms-excel"; i'm
getting correct output

[elangovan.cse]

I'm using visualstudio200 3..
GriedView is not available there..

[Code Monkey]

replace GridView with DataGrid!

el***********@g mail.com wrote:

I'm using visualstudio200 3..
GriedView is not available there..