{"id":43,"date":"2014-08-22T15:11:00","date_gmt":"2014-08-22T20:11:00","guid":{"rendered":"https:\/\/www.chrystalsander.com\/blog\/?p=43"},"modified":"2014-08-22T15:11:00","modified_gmt":"2014-08-22T20:11:00","slug":"net-create-datatable-from-csv-file","status":"publish","type":"post","link":"https:\/\/www.chrystalsander.com\/blog\/?p=43","title":{"rendered":"NET : Create DataTable From CSV File"},"content":{"rendered":"
\nDataTable<\/span> dt = new<\/span>
\nDataTable<\/span>();<\/o:p><\/span><\/div>\n
\nstring<\/span> line = String<\/span>.Empty;<\/o:p><\/span><\/div>\n
\nint<\/span> i = 0;<\/o:p><\/span><\/div>\n
\n<\/div>\n
\nusing<\/span> (StreamReader<\/span> sr = File<\/span>.OpenText(@path))<\/o:p><\/span><\/div>\n
\n{<\/o:p><\/span><\/div>\n
\n    while<\/span> ((line = sr.ReadLine()) != null<\/span>)<\/o:p><\/span><\/div>\n
\n    {<\/o:p><\/span><\/div>\n
\n        string<\/span>[] data = line.Split(‘,’<\/span>);<\/o:p><\/span><\/div>\n
\n        if<\/span> (data.Length > 0)<\/o:p><\/span><\/div>\n
\n        {<\/o:p><\/span><\/div>\n
\n            if<\/span> (i == 0)<\/o:p><\/span><\/div>\n
\n            {<\/o:p><\/span><\/div>\n
\n               
\nint<\/span> j = 0;<\/o:p><\/span><\/div>\n
\n               
\nforeach<\/span> (var<\/span>
\ns in<\/span> data)<\/o:p><\/span><\/div>\n
\n                {<\/o:p><\/span><\/div>\n
\n                   
\n\/\/create column<\/span><\/o:p><\/span><\/div>\n
\n                   
\ndt.Columns.Add(new<\/span> DataColumn<\/span>());<\/o:p><\/span><\/div>\n
\n                   
\n\/\/add column name from first row<\/span><\/o:p><\/span><\/div>\n
\n                   
\ndt.Columns[j].ColumnName = data[j].ToString();<\/o:p><\/span><\/div>\n
\n                   
\nj++;<\/o:p><\/span><\/div>\n
\n               
\n}<\/o:p><\/span><\/div>\n
\n               
\ni++;<\/o:p><\/span><\/div>\n
\n            }<\/o:p><\/span><\/div>\n
\n            if<\/span> (i > 1)<\/o:p><\/span><\/div>\n
\n            {<\/o:p><\/span><\/div>\n
\n               
\n\/\/if not first row (column name) then create
\ndata row<\/span><\/o:p><\/span><\/div>\n
\n               
\nDataRow<\/span> row = dt.NewRow();<\/o:p><\/span><\/div>\n
\n               
\nrow.ItemArray = data;<\/o:p><\/span><\/div>\n
\n              
\n dt.Rows.Add(row);<\/o:p><\/span><\/div>\n
\n            }<\/o:p><\/span><\/div>\n
\n           
\ni++;<\/o:p><\/span><\/div>\n
\n        }<\/o:p><\/span><\/div>\n
\n    }<\/o:p><\/span><\/div>\n
\n}<\/o:p><\/span><\/div>\n
\nreturn<\/span> dt;<\/o:p><\/span><\/div>\n
\n<\/div>\n
\n<\/div>\n","protected":false},"excerpt":{"rendered":"

DataTable dt = new DataTable(); string line = String.Empty; int i = 0; using (StreamReader sr = File.OpenText(@path)) {     while ((line = sr.ReadLine()) != null)     {         string[] data = line.Split(‘,’);         if (data.Length > 0)         {             if (i == 0)             {                 int j = 0;                 foreach (var … Continue reading “NET : Create DataTable From CSV File”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/43"}],"collection":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=43"}],"version-history":[{"count":0,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/43\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=43"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=43"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=43"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}