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();
        }