private void frmMain_Load(object sender, EventArgs e) { mysql.constring = "Data Source= localhost;Database=;User ID=root;Password="******";charset=utf8"; mysql.tablename = "check"; mysql.cmdText = "SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'engineering_school'"; mysql.DataBind(); dst = mysql.dst; if (dst.Tables["check"].Rows.Count > 0) { mysql.constring = "Data Source= localhost;Database=engineering_school;User ID=root;Password="******";charset=utf8"; dgvMain.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Myanmar3", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0))); } else { //mysql.cmdText = "DROP DATABASE engineering_school"; //mysql.DataBind(); //mysql.constring = "Data Source= localhost;Database=;User ID=root;Password="******";charset=utf8"; mysql.cmdText = "CREATE DATABASE engineering_school COLLATE utf8_unicode_ci"; mysql.DataBind(); mysql.constring = "Data Source= localhost;Database=engineering_school;User ID=root;Password="******";charset=utf8"; using (MySqlConnection con = new MySqlConnection(mysql.constring)) { using (MySqlCommand cmd = new MySqlCommand()) { using (MySqlBackup backup = new MySqlBackup(cmd)) { cmd.Connection = con; con.Open(); // File.Create(fbdlBackup.SelectedPath + "\\MES.sql"); backup.ImportFromFile(Application.StartupPath + "\\NewDb.sql"); con.Close(); //DialogResult result = MessageBox.Show("Database အား restore ပြုလုပ်ပြီးဖြစ်ပါသည်။ Software အား restart ပြုလုပ်မည်ဖြစ်ပါသည်။", "သင်တန်းဆိုင်ရာ သတင်းပေးချက်", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } //Application.Restart(); } try { string uname = string.Empty; string pass = string.Empty; frmlogin login = new frmlogin(); login.ShowDialog(); string logName = login.txtUname.Text; this.WindowState = FormWindowState.Minimized; if (login.DialogResult == System.Windows.Forms.DialogResult.Cancel) { Environment.Exit(0); } else { mysql.tablename = "auth"; mysql.cmdText = "select * from auth where uname = '" + login.txtUname.Text + "'"; mysql.DataBind(); if (mysql.dst.Tables["auth"].Rows.Count > 0) { //string mm = mysql.dst.Tables["setting"].Rows[0]["log"].ToString(); pass = mysql.dst.Tables["auth"].Rows[0]["pass"].ToString(); if (pass == login.txtpass.Text) { this.WindowState = FormWindowState.Maximized; mysql.tablename = "logs"; mysql.AddParams("@uname", logName); mysql.AddParams("@log", DateTime.Now.ToString()); mysql.cmdText = "INSERT INTO logs(uname,status,dateTIme) VALUES ('" + logName + "','Successfully Login','" + DateTime.Now.ToString() + "')"; mysql.insert(); login.Dispose(); load_training_name(); } else { this.Hide(); WrongAuth(logName); } } else { this.Hide(); WrongAuth(logName); } } } catch { MessageBox.Show("Database Server ချိတ်ဆက်မှုမအောင်မြင်ပါ။ Server အားပြန်လည်စစ်ဆေးရန်။", "System ဆိုင်ရာသတိပေးချက်", MessageBoxButtons.OK, MessageBoxIcon.Information); Environment.Exit(0); } }