C# (CSharp) ItemDB.Dispose示例

示例#1

        private void btnAdditem_Click(object sender, EventArgs e)
        {
            if (txtPrice.Text.Length < 1)
            {
                MessageBox.Show("가격을 입력해주세요");
                return;
            }

            Item item;

            item.ItemID    = Convert.ToInt32(txtItemID.Text);
            item.ItemName  = txtName.Text;
            item.ItemCare  = txtCare.Text;
            item.ItemPrice = Convert.ToInt32(txtPrice.Text);
            item.ItemType  = txtCare.Text;

            ItemDB idb = new ItemDB();

            idb.Insert(item);
            idb.Dispose();

            MessageBox.Show("등록완료");
        }

示例#2

        private void btnDelete_Click(object sender, EventArgs e)
        {
            string name = dgvItem[1, dgvItem.CurrentRow.Index].Value.ToString();

            if (MessageBox.Show($"{name} 상품을 삭제하시겠습니까?", "삭제확인", MessageBoxButtons.YesNo) == DialogResult.Yes)
            {
                //DB에서 데이터 삭제
                int itemid = (int)dgvItem[0, dgvItem.CurrentRow.Index].Value;

                ItemDB db     = new ItemDB();
                bool   result = db.Delete(itemid);
                db.Dispose();

                if (result)
                {
                    MessageBox.Show("삭제되었습니다.");
                    //LoadData();
                }
                else
                {
                    MessageBox.Show("다시 삭제를 시도하여 주십시오.");
                }
            }
        }