Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- StreamReader sr = new StreamReader(txthelye.Text);
- while (!sr.EndOfStream)
- {
- string sor2 = sr.ReadLine();
- String[] reszek2 = sor2.Split('\t');
- MySqlConnection kapcsolat3 = new MySqlConnection("server=127.0.0.1; user=root; password=; database=" + melyadatbazis2.Text + ";");
- kapcsolat3.Open();
- MySqlCommand parancs2 = new MySqlCommand("SHOW COLUMNS FROM " + tablanev2.Text + ";", kapcsolat3);
- if (nincshiba3 == true)
- {
- MySqlDataReader olvaso2 = parancs2.ExecuteReader();
- while (olvaso2.Read())
- {
- mezonevek.Add(olvaso2[0].ToString());
- }
- olvaso2.Close();
- }
- MySqlCommand parancs3 = new MySqlCommand("INSERT INTO " + tablanev2.Text + " (" + mezonevek[0] + ") VALUES ('" + reszek2[0] + "');", kapcsolat3);
- parancs3.ExecuteNonQuery();
- for (int k = 1; k <= mezonevek.Count() - 1; k++)
- {
- MySqlCommand parancs4 = new MySqlCommand("UPDATE " + tablanev2.Text + " SET " + mezonevek[k] + "='" + reszek2[k] + "' WHERE " + mezonevek[0] + "='" + reszek2[0] + "';", kapcsolat3);
- parancs4.ExecuteNonQuery();
- }
- kapcsolat3.Close();
- mezonevek.RemoveRange(0, mezonevek.Count());
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement