private void DeleteUser_Load(object sender, EventArgs e) { comboBox1.Items.Clear(); try { MySqlAuth connectstring = new MySqlAuth(); string connectionString = connectstring.connectMysql(); MySqlConnection connection = new MySqlConnection(connectionString); connection.Open(); string query = "SELECT USERNAME FROM users"; MySqlCommand command = new MySqlCommand(query, connection); command.ExecuteNonQuery(); MySqlDataReader datareader = command.ExecuteReader(); while (datareader.Read()) { comboBox1.Items.Add(datareader["USERNAME"].ToString()); } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } }
private void Option_Load(object sender, EventArgs e) { MySqlAuth connectstring = new MySqlAuth(); string connectionString = connectstring.connectMysql(); try { DataTable datable = new DataTable(); MySqlConnection connection = new MySqlConnection(connectionString); connection.Open(); string query = "SELECT * FROM users "; MySqlCommand command = new MySqlCommand(query, connection); MySqlDataAdapter adapter = new MySqlDataAdapter(query, connection); command.ExecuteNonQuery(); adapter.Fill(datable); BindingSource bSource = new BindingSource(); bSource.DataSource = datable; dataGridView1.DataSource = bSource; } catch (MySqlException ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { try { MySqlAuth connectstring = new MySqlAuth(); string connectionString = connectstring.connectMysql(); MySqlConnection connection = new MySqlConnection(connectionString); connection.Open(); string query = "INSERT INTO users VALUES('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "')"; MySqlCommand command = new MySqlCommand(query, connection); command.ExecuteNonQuery(); MessageBox.Show("Registered Successfully!!"); textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); textBox4.Clear(); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { try { MySqlAuth connectstring = new MySqlAuth(); string connectionString = connectstring.connectMysql(); MySqlConnection connection = new MySqlConnection(connectionString); connection.Open(); string query = "UPDATE users SET PASSWORD='******' WHERE USERNAME='******'"; if (textBox1.Text == "" || textBox1.Text.Length < 6) { MessageBox.Show("Password cannot be less than 6 characters or empty!!"); } else { MySqlCommand command = new MySqlCommand(query, connection); command.ExecuteNonQuery(); MessageBox.Show("Successfully Updated"); textBox1.Clear(); textBox2.Clear(); } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { MySqlAuth connectstring = new MySqlAuth(); string connectionString = connectstring.connectMysql(); try { MySqlConnection connection = new MySqlConnection(connectionString); connection.Open(); string query = "SELECT USERNAME,PASSWORD FROM users WHERE USERNAME='******' AND PASSWORD='******'"; MySqlCommand command = new MySqlCommand(query, connection); command.ExecuteNonQuery(); MySqlDataReader datareader = command.ExecuteReader(); if (datareader.Read() == true) { MessageBox.Show("Connected!"); Menu form = new Menu(); this.Hide(); form.ShowDialog(); } else { MessageBox.Show("Username or Password is Incorrect!!!"); } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { try { MySqlAuth connectstring = new MySqlAuth(); string connectionString = connectstring.connectMysql(); MySqlConnection connection = new MySqlConnection(connectionString); connection.Open(); string query = "DELETE FROM users WHERE USERNAME='******'"; MySqlCommand command = new MySqlCommand(query, connection); command.ExecuteNonQuery(); connection.Close(); MessageBox.Show("Deleted Successfully"); connection.Open(); comboBox1.Items.Clear(); comboBox1.SelectedText = ""; textBox1.Clear(); string query1 = "SELECT USERNAME FROM users"; MySqlCommand command1 = new MySqlCommand(query1, connection); command.ExecuteNonQuery(); MySqlDataReader datareader = command1.ExecuteReader(); while (datareader.Read()) { comboBox1.Items.Add(datareader["USERNAME"].ToString()); } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } }