void cc(List <string[]> parseddata) { DBRepository dbr = new DBRepository(); foreach (string[] row in parseddata) { dbr.InsertRecord(row); } }
void ReadandParseData(string path, char seperator) { var parsedData = new List <string[]>(); string[] test = File.ReadAllLines(path); int cnt = 0; int cnt2 = 0; using (var sr = new StreamReader(path)) { string line; while ((line = sr.ReadLine()) != null) { //cnt++; //string[] row = line.Split(seperator); //parsedData.Add(row); if (cnt > 2000) { foreach (string[] row in parsedData) { connection.InsertRecord(row); } parsedData.Clear(); cnt = 0; } else { cnt++; string[] row = line.Split(seperator); parsedData.Add(row); cnt2++; } } Toast.MakeText(this, "Amount of records added: in Fietsdiefstal" + cnt2.ToString(), ToastLength.Short).Show(); } }