private void lsvAccounts_DoubleClick(object sender, EventArgs e)
{
if (lsvAccounts.SelectedItems.Count <= 0)
{
return;
}
string ID = lsvAccounts.SelectedItems[0].Tag.ToString();
MySqlConnection conGet = new MySqlConnection(MySQLRunner.ConnectionString);
MySqlDataReader drGet = null;
string sSQL = "";
sSQL = "SELECT * FROM account where account_id = '" + ID.ToString() + "'";
if (MySQLRunner.ExecuteQuery(sSQL, conGet, ref drGet) == true)
{
drGet.Read();
if (drGet.HasRows == false)
{
txtUserName.Text = "";
txtEmail.Text = "";
txtCSR.Text = "";
txtBanned.Text = "";
txtChars.Text = "";
}
else
{
txtUserName.Text = drGet.GetString(drGet.GetOrdinal("username"));
txtEmail.Text = drGet.GetString(drGet.GetOrdinal("email"));
txtCSR.Text = drGet.GetString(drGet.GetOrdinal("csr"));
txtBanned.Text = drGet.GetString(drGet.GetOrdinal("banned"));
txtChars.Text = drGet.GetString(drGet.GetOrdinal("characters_allowed"));
}
}
if (conGet.State == ConnectionState.Open)
{
if (drGet != null)
drGet.Close();
conGet.Close();
}
}