private void btnPassUpdate_Click(object sender, EventArgs e)
{
MySQLRunner.ConnectionString = clsDBStrings.maindbcon;
MySqlConnection conAdd = new MySqlConnection(MySQLRunner.ConnectionString);
string sSQL = "";
string ID = lsvAccounts.SelectedItems[0].Tag.ToString();
sSQL = "UPDATE account SET " +
"password=SHA1('" + txtUpdatePass.Text + "') " +
"WHERE account_id=" + ID.ToString();
if (MySQLRunner.ExecuteNonQuery(sSQL, conAdd) == false)
MessageBox.Show("Error creating Account.");
else
MessageBox.Show("Account Creation Successful.");
if (conAdd.State == ConnectionState.Open)
{
conAdd.Close();
}
}