Пример #1
0
        private void CBChangedPlayer(object sender, EventArgs e)
        {
            int playerId = PlayerData.OptionsListIds[Player.SelectedIndex];

            using (var conn = Database.AccessDB.Connect())
            {
                conn.Open();
                using (var reader = SQLDB.Read(conn, "SELECT Image FROM Player JOIN BaseObject WHERE BaseObject_ID = BaseObjectID AND Player_ID = " + playerId + ";"))
                {
                    reader.Read();
                    try { PlayerImage.Image = Conversion.BytesToImage(reader, 0); }
                    catch (Exception) { PlayerImage.Image = null; }
                }
                conn.Close();
            }
            string where     = "BaseObject_ID = BaseObjectID AND BattlerClass_ID = BattlerClassID AND PlayerID = " + playerId;
            BattlerClassData = new ComboBoxInputData("BattlerClassID", "Name", "Player_To_BattlerClass JOIN BaseObject JOIN BattlerClass", where, "BattlerClass_ID");
            Class.Items.Clear();
            Class.Items.AddRange(BattlerClassData.OptionsListNames.ToArray());
            Class.SelectedIndex = 0;
        }