private void button2_Click(object sender, EventArgs e) { this.Hide(); SupplierView sv = new SupplierView(); sv.Show(); }
private void button1_Click(object sender, EventArgs e) { String name = sname.Text; String pho = phone.Text; if (name == "" || pho == "") { MessageBox.Show("Every Field are Required"); } else { string connectionString = "datasource=127.0.0.1;port=3306;username=root;password=;database=debuggeddb;"; MySqlConnection databaseConnection = new MySqlConnection(connectionString); try { databaseConnection.Open(); MySqlCommand comm = databaseConnection.CreateCommand(); comm.CommandText = "INSERT INTO suppliertable (`SupplierName`,`PhoneNo`) VALUES (@sn,@ph);"; comm.Parameters.AddWithValue("@sn", name); comm.Parameters.AddWithValue("@ph", pho); comm.ExecuteNonQuery(); databaseConnection.Close(); //clear the text sname.Text = ""; phone.Text = ""; //message MessageBox.Show("Data Has been successfully inserted"); this.Hide(); SupplierView sv = new SupplierView(); sv.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }