private void FrmEnemy_Load(object sender, EventArgs e)
{
this.DataGridViewEnemy.DataSource = list;
this.DataGridViewEnemy.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
var connection = Conection.ConnectDB();
var cmd = new MySqlCommand("select * from enemy;", connection);
var reader = cmd.ExecuteReader();
list.Clear();
while (reader.Read())
{
var enemy = new EnemyParam();
enemy.Id = DBNull.Value != reader["Id"] ? Convert.ToInt32(reader.GetString("Id")) : 0;
enemy.Name = DBNull.Value != reader["name"] ? reader.GetString("name") : "";
enemy.IsBoss = DBNull.Value != reader["isBoss"] ? Convert.ToBoolean(reader.GetString("isBoss")) : false;
enemy.Hp = DBNull.Value != reader["Hp"] ? Convert.ToInt32(reader.GetString("Hp")) : 0;
enemy.Mp = DBNull.Value != reader["Mp"] ? Convert.ToInt32(reader.GetString("Mp")) : 0;
enemy.Atk = DBNull.Value != reader["Atk"] ? Convert.ToInt32(reader.GetString("Atk")) : 0;
enemy.Def = DBNull.Value != reader["Def"] ? Convert.ToInt32(reader.GetString("Def")) : 0;
enemy.Int = DBNull.Value != reader["Int"] ? Convert.ToInt32(reader.GetString("Int")) : 0;
enemy.Mnd = DBNull.Value != reader["Mnd"] ? Convert.ToInt32(reader.GetString("Mnd")) : 0;
enemy.Spd = DBNull.Value != reader["Spd"] ? Convert.ToInt32(reader.GetString("Spd")) : 0;
enemy.Lvl = DBNull.Value != reader["Lvl"] ? Convert.ToInt32(reader.GetString("Lvl")) : 0;
enemy.Exp = DBNull.Value != reader["Exp"] ? Convert.ToInt32(reader.GetString("Exp")) : 0;
list.Add(enemy);
}
Conection.DisConnectDB();
}
