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