Advertisement
Guest User

Untitled

a guest
Jan 25th, 2016
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.74 KB | None | 0 0
  1. StreamReader sr = new StreamReader(txthelye.Text);
  2. while (!sr.EndOfStream)
  3. {
  4. string sor2 = sr.ReadLine();
  5. String[] reszek2 = sor2.Split('\t');
  6. MySqlConnection kapcsolat3 = new MySqlConnection("server=127.0.0.1; user=root; password=; database=" + melyadatbazis2.Text + ";");
  7. kapcsolat3.Open();
  8. MySqlCommand parancs2 = new MySqlCommand("SHOW COLUMNS FROM " + tablanev2.Text + ";", kapcsolat3);
  9. if (nincshiba3 == true)
  10. {
  11. MySqlDataReader olvaso2 = parancs2.ExecuteReader();
  12. while (olvaso2.Read())
  13. {
  14. mezonevek.Add(olvaso2[0].ToString());
  15. }
  16. olvaso2.Close();
  17. }
  18. MySqlCommand parancs3 = new MySqlCommand("INSERT INTO " + tablanev2.Text + " (" + mezonevek[0] + ") VALUES ('" + reszek2[0] + "');", kapcsolat3);
  19. parancs3.ExecuteNonQuery();
  20. for (int k = 1; k <= mezonevek.Count() - 1; k++)
  21. {
  22. MySqlCommand parancs4 = new MySqlCommand("UPDATE " + tablanev2.Text + " SET " + mezonevek[k] + "='" + reszek2[k] + "' WHERE " + mezonevek[0] + "='" + reszek2[0] + "';", kapcsolat3);
  23. parancs4.ExecuteNonQuery();
  24. }
  25. kapcsolat3.Close();
  26. mezonevek.RemoveRange(0, mezonevek.Count());
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement