CODEWITHSUNDEEP
c#datagridviewcsvdatatablechar
Blackguardian
Blackguardian

Reputation: 21

Problem with csv special characters

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

Upvotes: 1

Views: 7838

Answers (1)

Aliostad
Aliostad

Reputation: 81700

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.

Upvotes: 7

Related Questions