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;
        }