Problem with csv special characters

2019-08-13 22:27发布

问题:

I have a problem: I have read a csv file and store the contents into a datatable, and everything is ok. But when I show the contents of the datatable in a datagridview, when I have the symbols "€" or "is, and ..." I only see a diamond with a question mark inside. How can I fix this? thanks

回答1:

You need to load the file with correct encoding.

Default is UTF8 but your file could be ASCII.

pass the encoding to the constructor of StreamReader :

StreamReader sw = new StreamReader (fileName, Encoding.ASCII);

Note

I do not know what encoding your file has but I just guess it is ASCII.