private static void ProcessCSVFiles(string theconnectionstring, DirectoryInfo dir) { thedata Kisdata = new thedata(); gpsdata thegpsdata = new gpsdata(); Kisdata.ConnectionString = theconnectionstring; thegpsdata.ConnectionString = theconnectionstring; int count = 0; double timestamp = 1161883162; DateTime dateTime = new DateTime(1970, 1, 1, 0, 0, 0, 0); // Add the number of seconds in UNIX timestamp to be converted. dateTime = dateTime.AddSeconds(timestamp); // The dateTime now contains the right date/time so to format the string, // use the standard formatting methods of the DateTime object. // string printDate = dateTime.ToShortDateString() + " " + dateTime.ToShortTimeString(); // Print the date and time Console.WriteLine(dateTime); thegpsdata.LoadAll(); do { if (!Kisdata.LoadByPrimaryKey(thegpsdata.Bssid)) { count++; //Console.WriteLine(thegpsdata.Bssid); } } while (thegpsdata.MoveNext()); Console.WriteLine(count); foreach (FileInfo f in dir.GetFiles("Kismet*.csv")) { StreamReader sr = File.OpenText(Application.StartupPath + "\\logs\\" + f.Name); string input; Console.WriteLine(f.Name); //string aoui = ""; //string[] theoui; //string thecompany = ""; sr.ReadLine(); while ((input = sr.ReadLine()) != null) { if (input.Length != 0) { //Console.WriteLine(input); string[] thestrings; thestrings = input.Split(new char[] { ';' }); //Console.WriteLine(thestrings.Length); if(!Kisdata.LoadByPrimaryKey(thestrings[3])) { Console.WriteLine(thestrings[2]); Console.WriteLine(thestrings[3]); } } } } }