Breaking News

Editors Picks

Saturday, December 31, 2011

read csv file using streamreader in c#


DataTable dt = new DataTable();
string line = null;
int i = 0; 
using (StreamReader sr = File.OpenText(@"c:\Data_file.csv"))
{  
      while ((line = sr.ReadLine()) != null)
      {
            string[] data = line.Split(',');
            if (data.Length > 0)
            {
                  if (i == 0)
                  {
                  foreach (var item in data)
                  {
                        dt.Columns.Add(new DataColumn());
                  }
                  i++;
             }
             DataRow row = dt.NewRow();
             row.ItemArray = data;
             dt.Rows.Add(row);
             }
      }
}

No comments :

Post a Comment

Contact Us

Name

Email *

Message *