Guest User

Untitled

a guest
Aug 13th, 2018
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. var domain = new List<string>();
  2. // MYSQL
  3. string serverName = "";
  4. string userName = "s";
  5. string dbName = "";
  6. string port = "";
  7. string password = "";
  8. string connStr = "server=" + serverName + ";user=" + userName + ";database=" + dbName + ";port=" + port + ";password=" + password + ";SslMode=none;";
  9. MySqlConnection conn = new MySqlConnection(connStr);
  10. string sql = "SELECT * FROM domain";
  11. MySqlCommand myCommand = new MySqlCommand(sql, conn);
  12. conn.Open();
  13. MySqlDataReader reader = myCommand.ExecuteReader();
  14. while (reader.Read())
  15. domain.Add(reader.GetString(0));
  16. conn.Close();
  17.  
  18.  
  19. string[] allLines = File.ReadAllLines(pathFile, Encoding.GetEncoding(1251));
  20. for (int i = 0; i < countline; i++ )
  21. {
  22. var re = File.ReadAllLines(pathFile, Encoding.Default).Where(s => !s.Contains(domain[i]));
  23. File.WriteAllLines("file.txt", re, Encoding.Default);
  24. }
  25.  
  26. var pathFile = @"D:ВЛАДtest.txt";//Тут Ваш путь
  27. var domain = new List<string>(); //Список с строками которых быть не должно
  28. string[] allLines = File.ReadAllLines(pathFile);//Файл изначально
  29. domain.Add("get");//Добавил для примера
  30. domain.Add("try");
  31. for (int i = 0; i < domain.Count; i++)
  32. {
  33. var re = File.ReadAllLines(pathFile, Encoding.Default).Where(s => !s.Contains(domain[i]));
  34. File.WriteAllLines(pathFile, re, Encoding.Default);
  35. }
Add Comment
Please, Sign In to add comment