export dataset to excel

[=?Utf-8?B?TGFtaXM=?=]

Hello,

I have a dataset that has information written in Swedish language, that
means alot of stranch chars like 'Å, Ä, Ö' etc and my code
void Export(datagrid myDataGrid){
Response.Clear();

Response.AddHeader("content-disposition","attachment;filename=FileName.xls");
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.No Cache);
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
myDataGrid.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();}
this exports a file and replaces the swedish chars to something else like
ö.. Do you have any code sample or idea how to fix that???
--
LZ

[Mark Rae [MVP]]

"Lamis" <La***@discussions.microsoft.comwrote in message
news:77**********************************@microsof t.com...

Response.Charset = "";

Is that not the problem...? Don't you have to specify a value for Charset
here...?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[=?Utf-8?B?TGFtaXM=?=]

hi mark
what should it be???
Response.charst = "ASCII" is not helping?
--
LZ
"Mark Rae [MVP]" wrote:

"Lamis" <La***@discussions.microsoft.comwrote in message
news:77**********************************@microsof t.com...

Response.Charset = "";

Is that not the problem...? Don't you have to specify a value for Charset
here...?
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Alexey Smirnov]

On Aug 29, 2:32 pm, Lamis <[e-mail]:

hi mark
what should it be???
Response.charst = "ASCII" is not helping?
--
LZ

"Mark Rae [MVP]" wrote:

"Lamis" <[e-mail] in message
news:77**********************************@microsof t.com...

Response.Charset = "";

Is that not the problem...? Don't you have to specify a value for Charset
here...?

--
Mark Rae
ASP.NET MVP
http://www.markrae.net- Hide quoted text -

- Show quoted text -

Hej Lamis

try to set encoding

Response.ContentEncoding = System.Text.Encoding.GetEncoding(1252)

[Mark Rae [MVP]]

"Lamis" <La***@discussions.microsoft.comwrote in message
news:31**********************************@microsof t.com...

hi mark
what should it be???
Response.charst = "ASCII" is not helping?

First, I would try:

Response.Charset = "iso-8859-1";

If that doesn't work, then try adding a ResponseEncoding tag to the @Page
directive e.g.

<%@ Page ContentType="text/html" ResponseEncoding="iso-8859-1">

See here:
http://www.experts-exchange.com/Prog..._21551614.html
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[=?Utf-8?B?TGFtaXM=?=]

hi,

Response.ContentEncoding = System.Text.Encoding.GetEncoding(1252) worked
perfectly.. thank's ALOT for your help
--
LZ
"Alexey Smirnov" wrote:

On Aug 29, 2:32 pm, Lamis <[e-mail]:

hi mark
what should it be???
Response.charst = "ASCII" is not helping?
--
LZ

"Mark Rae [MVP]" wrote:

"Lamis" <[e-mail] in message
>news:77**********************************@microso ft.com...

Response.Charset = "";

Is that not the problem...? Don't you have to specify a value for Charset
here...?

--
Mark Rae
ASP.NET MVP
>http://www.markrae.net- Hide quoted text -

- Show quoted text -

Hej Lamis

try to set encoding

Response.ContentEncoding = System.Text.Encoding.GetEncoding(1252)