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();
}