private void TxbSearch_TextChanged(object sender, TextChangedEventArgs e) { string keyword = txbSearch.Text; SpellDAL tDAL = new SpellDAL(); DataTable dt = tDAL.Search(keyword); dgvSpells.ItemsSource = dt.DefaultView; }
public WarhammerSpellSearchPage() { InitializeComponent(); SpellDAL tDAL = new SpellDAL(); DataTable dt = tDAL.Select(); dgvSpells.ItemsSource = dt.DefaultView; }
private void GetItem(int id) { SpellDAL tDAL = new SpellDAL(); DataTable dt = tDAL.SelectById(id); txbSpellName.Content = dt.Rows[0]["name"].ToString(); txbCastingTime.Content = dt.Rows[0]["castingtime"].ToString(); txbCastingNumber.Content = dt.Rows[0]["castingnumber"].ToString(); txbIngredient.Content = dt.Rows[0]["ingredient"].ToString(); txbDescription.Content = dt.Rows[0]["spelldescription"].ToString(); }