CODEWITHSUNDEEP
csvdatatableoledb
장선민
장선민

Reputation: 821

Reading csv file into DataTable

I'm Korean and I have a problem regards with importing csv file into DataTable.

I used this code to import csv file.

    public static DataTable ParseCSV(string path)
    {
        string filePath = Path.GetDirectoryName(path);

        string oledbConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties=\"text;HDR=Yes;FMT=Delimited\"";

        string csvFileName = Path.GetFileName(path);

        string sQuery = string.Format(" SELECT * FROM [{0}] ", csvFileName); 
        DataTable ds = null;

        OleDbDataAdapter adt = null;

        using (OleDbConnection con = new OleDbConnection(oledbConnectionString))
        {
            ds = new DataTable();
            adt = new OleDbDataAdapter(sQuery, con);
            adt.Fill(ds);
        }

        return ds;
    }

It works very well when there is no Korean language in csv file.

However, if csv file contains korean word, it transfers korean word into some strange word.

I need your help.

Thank you~~~

Upvotes: 0

Views: 2651

Answers (3)

YAYAYAYA
YAYAYAYA

Reputation: 414

It happens to me. and i find that file that saved into utf-8 is the problem. you need to save the file as ANSI using notpad or what ever. then if you still have problem you need to add this row depand on the lenguage you need.

dataTable.Locale = CultureInfo.CurrentCulture;

or

dataTable.Locale = CultureInfo.GetCultureInfo(your culture);

here is the codes for the culture info.

http://msdn.microsoft.com/en-us/library/system.globalization.cultureinfo%28v=vs.71%29.aspx

Upvotes: 0

sudheshna
sudheshna

Reputation: 1150

Please try the following parser,

http://www.codeproject.com/KB/database/CsvReader.aspx

Upvotes: 1

Edgar Velasquez Lim
Edgar Velasquez Lim

Reputation: 2446

Save your csv file with UTF-8 encoding. This will more than likely solve your problem. You can use notepad++ to quickly convert your already saved file to UTF-8, run the import and see if that is working.

Upvotes: 0

Related Questions