deletebok.cs

一个简单的管理系统

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace 图书管理系统
{
    public partial class Deletebok : Form
    {
        public Deletebok()
        {
            InitializeComponent();
        }
        Bokbase bb = new Bokbase();
        private void Deletebok_Load(object sender, EventArgs e)
        {
            DataSet delds = bb.getds("select ISBN,Bookname as 书名,Bookclass as 类别,Bookin as 库存,BookWr as 作者 from BookIn","BookIn");
            dgvdel.DataSource=delds.Tables[0];
        }

        private void dgvdel_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void dgvdel_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            txtbokin.Text = Convert.ToString(dgvdel[3, dgvdel.CurrentCell.RowIndex].Value);
            txtbokisbn.Text = Convert.ToString(dgvdel[0, dgvdel.CurrentCell.RowIndex].Value);
            txtbokname.Text = Convert.ToString(dgvdel[1, dgvdel.CurrentCell.RowIndex].Value);
        }

        private void btncancle_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void btndel_Click(object sender, EventArgs e)
        {
            try
            {
                bb.getcom("delete from BookIn where Bookname=" + Convert.ToString(dgvdel[1, dgvdel.CurrentCell.RowIndex].Value) + "");
                Deletebok_Load(sender,e);
                MessageBox.Show("删除图书成功!");
            }
            catch (Exception del) { MessageBox.Show(del.Message); }

        }
    }
}