ANHAdmin.frmAccounts.lsvAccounts_DoubleClick C# (CSharp) Method

lsvAccounts_DoubleClick() private method

private lsvAccounts_DoubleClick ( object sender, EventArgs e ) : void
sender object
e System.EventArgs
return void
        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();
            }
        }