MySqlConnection Mysql_Connect(MySqlConnection connect) { Connection_user connect_to_db = new Connection_user(); connect = new MySqlConnection(connect_to_db.Connect_to_DB()); try { connect.Open(); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } return(connect); }
void executeSQLcommend_Insert_University() { Connection_user connect_to_db = new Connection_user(); connection = new MySqlConnection(connect_to_db.Connect_to_DB()); try { connection.Open(); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } MySqlCommand cmd; string University_fileName = @"C:\Users\KylHA\Documents\GitHub\VeriTOdevi\VeriTabaniOdevi\Üniversiteler.txt"; string bolumler_fileName = @"C:\Users\KylHA\Documents\GitHub\VeriTOdevi\VeriTabaniOdevi\bolumler_edited.txt"; string[] University_file = File.ReadAllLines(University_fileName); string[] Dep_file = File.ReadAllLines(bolumler_fileName); int k = 0; foreach (string item in University_file) { University_file[k] = item.Split('\t')[0]; k++; } for (int i = 0; i < Dep_file.Length; i++) { if (i < University_file.Length) { cmd = new MySqlCommand(connect_to_db.Insert_University_name_and_dep_NN_Query(University_file[i], Dep_file[i]), connection); } else { cmd = new MySqlCommand(connect_to_db.Insert_University_name_and_dep_NN_Query(null, Dep_file[i]), connection); } cmd.ExecuteNonQuery(); } connection.Close(); }