deleteadmin.cs

这是一个图书馆管理用的简化系统

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

namespace BMS
{
    public partial class DeleteAdmin : Form
    {
        public DeleteAdmin()
        {
            InitializeComponent();
        }
        private void ad_data()
        {
            string sead = "select *from Admin";
            if (Operator.Datafill(sead).Rows.Count > 0)
                dataGridView1.DataSource = Operator.Datafill(sead);
        }
        private void DeleteOperator_Load(object sender, EventArgs e)
        {
            ad_data();
            
        }
        //在dataGridView1显示要删除的管理员信息
        private void button1_Click(object sender, EventArgs e)
        {
            string sxs = "select * from ADmin where Ad_id='" + textBox1.Text + "'";
            if (Operator.Datafill(sxs).Rows.Count > 0)
                dataGridView1.DataSource = Operator.Datafill(sxs);
            else
            {
                MessageBox.Show("没有此编号操作员信息");
                textBox1.Text = "";
                textBox1.Focus();
            }
        }


        private void dataGridView1_MouseDown(object sender, MouseEventArgs e)
        {
            textBox1.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString();
        }
        
        //执行删除操作
        private void button2_Click(object sender, EventArgs e)
        {
            string scad = "select * from Admin where Ad_id='" + textBox1.Text + "'";
            if (Operator.Datafill(scad).Rows.Count == 0)
            {
                MessageBox.Show("没有此编号操作员信息");
            }
            string delstr = "delete from Admin where Ad_id='" + textBox1.Text + "'";
            if (Operator.ExecuteSql(delstr) > 0)
            {
                MessageBox.Show("删除成功。");
                textBox1.Text = "";
                ad_data();
            }
        }

        private void DeleteAdmin_Load(object sender, EventArgs e)
        {
            // TODO: 这行代码将数据加载到表“book_manageDataSet.Admin”中。您可以根据需要移动或移除它。
            this.adminTableAdapter.Fill(this.book_manageDataSet.Admin);

        }

        
        
    }
}