frmadmin.cs

数据库课程设计

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Bussiness;
namespace UI
{
    public partial class managementUser : Form
    {
        SelectInfo objSelectInfo = new SelectInfo();
        DataTable objDataTable;
        AdminInfo objAdminInfo = new AdminInfo();
        public managementUser()
        {
            InitializeComponent();
        }
        public DataTable jieshou()
        {
            objDataTable = objSelectInfo.SelectAdminuserInfo();
            return objDataTable;
        }
        public void xian()
        {
            this.datAdmin.DataSource = null;
            this.datAdmin.DataSource = jieshou();
           
        }
        private void button5_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void managementUser_Load(object sender, EventArgs e)
        {
            xian();
        }

        private void button1_Click(object sender, EventArgs e)
        {
           frmAddNewUser objfrmAddNewUser=new frmAddNewUser(this);

           objfrmAddNewUser.Show();

        }

        private void button3_Click(object sender, EventArgs e)
        {
            try
            {
                if (!datAdmin.IsSelected(datAdmin.CurrentRowIndex))
                {
                    MessageBox.Show("请选中要修改的行！");
                    return;
                }
                DataRow objUpdateRows = objDataTable.Rows[this.datAdmin.CurrentRowIndex];
                frmAmendInfo objfrmAmendInfo = new frmAmendInfo(objUpdateRows);
                objfrmAmendInfo.Show();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
           
        }

        private void button2_Click(object sender, EventArgs e)
        {try
                {
            if (!datAdmin.IsSelected(datAdmin.CurrentRowIndex))
            {
                MessageBox.Show("请选中要修改的行！");
                return;
            }
            if (MessageBox.Show("确认删除数据码？", "数据删除",
               MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
            {
                //首先删除数据集当中的数据.
                string a = objDataTable.Rows[this.datAdmin.CurrentRowIndex][1].ToString();
                
                    objAdminInfo.delAdmin(a);
                    xian();
                    MessageBox.Show("数据删除" + a + "数据成功！！！");
             
            }   }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.ToString());
                }
        }

        private void button4_Click(object sender, EventArgs e)
        {
            xian();
        }

  
    }
}