private void EffectSearch_Load(object sender, EventArgs e) { m_Conn = DB.GetConnection(); // Pull down data DataTable dataTable = new DataTable(); String query = "SELECT `EffectID`,`item_effect_base`.`Description`,`item_effect_base`.`Tooltip` FROM `item_effect_base`"; MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter(query, m_Conn); mySqlDataAdapter.Fill(dataTable); EffectList.DataSource = dataTable; }
public Form1() { InitializeComponent(); ItemEditor = new EditItem(); DB.Connect(); m_conn = DB.GetConnection(); m_EffectID = 0; // Buffs EffectBuff.Items.AddRange(GetBuffList()); // Stats VarStat1.Items.AddRange(GetStatsList()); VarStat2.Items.AddRange(GetStatsList()); VarStat3.Items.AddRange(GetStatsList()); ConstStat1.Items.AddRange(GetStatsList()); ConstStat2.Items.AddRange(GetStatsList()); // Types VarType1.Items.AddRange(GetVarableType()); VarType2.Items.AddRange(GetVarableType()); VarType3.Items.AddRange(GetVarableType()); ConstType1.Items.AddRange(GetVarableType()); ConstType2.Items.AddRange(GetVarableType()); // Set defaults EffectType.SelectedIndex = 0; VarStat1.SelectedIndex = 0; VarStat2.SelectedIndex = 0; VarStat3.SelectedIndex = 0; VarType1.SelectedIndex = 0; VarType2.SelectedIndex = 0; VarType3.SelectedIndex = 0; ConstType1.SelectedIndex = 0; ConstType2.SelectedIndex = 0; ConstStat1.SelectedIndex = 0; ConstStat2.SelectedIndex = 0; }