deleteoperator.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 DeleteOperator : Form
    {
        public DeleteOperator()
        {
            InitializeComponent();
        }
        private void data()
        {
            string select1 = "select *from Operate";
            if (Operator.Datafill(select1).Rows.Count > 0)
            dataGridView1.DataSource = Operator.Datafill(select1);
        }
        private void DeleteOperator_Load(object sender, EventArgs e)
        {
            data();
            // TODO: 这行代码将数据加载到表“book_manageDataSet.Operate”中。您可以根据需要移动或移除它。
            //this.operateTableAdapter.Fill(this.book_manageDataSet.Operate);

        }

        private void button1_Click(object sender, EventArgs e)
        {
            string cxs = "select * from Operate where id='" + textBox1.Text + "'";
            if (Operator.Datafill(cxs).Rows.Count > 0)
                dataGridView1.DataSource = Operator.Datafill(cxs);
            else
            {
                MessageBox.Show("没有此编号操作员信息");
                textBox1.Text = "";
                textBox1.Focus();
            }
        }
        private void dataGridView1_MouseClick(object sender, MouseEventArgs e)
        {
            textBox1.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString();
        }
        private void button2_Click(object sender, EventArgs e)
        {
            string sc = "select * from Operate where id='"+textBox1.Text+"'";
            if (Operator.Datafill(sc).Rows.Count == 0)
            {
                MessageBox.Show("没有此编号操作员信息");
            }
            string deletestr = "delete from Operate where id='" + textBox1.Text + "'";
            if (Operator.ExecuteSql(deletestr) > 0)
            {
                MessageBox.Show("删除成功。");
                textBox1.Text = "";
                data();
            }
        }

       

       
    }
}