Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static DataTable ConvertCSVtoDataTable(string strFilePath)
- {
- StreamReader sr = new StreamReader(strFilePath);
- string[] headers = sr.ReadLine().Split(';');
- DataTable dt = new DataTable();
- foreach (string header in headers)
- {
- dt.Columns.Add(header);
- }
- while (!sr.EndOfStream)
- {
- string[] rows = sr.ReadLine().Split(';');
- //string[] rows = Test();
- DataRow dr = dt.NewRow();
- for (int i = 0; i < headers.Length; i++)
- {
- dr[i] = rows[i];
- }
- dt.Rows.Add(dr);
- }
- return dt;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement