frmmain.cs

commandBuilder应用数据库的使用

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using student.Business;
using student.DB;

namespace student
{
    public partial class frmMain : Form
    {
        Businesses bn = new Businesses();
        public frmMain()
        {
            InitializeComponent();
        }

        private void frmMain_Load(object sender, EventArgs e)
        {
            bn.getDataGridViewValue(dgv);
            rightMenu.Items[0].Enabled = false;
            rightMenu.Items[2].Enabled = false;
            dgv.Columns[0].ReadOnly = true;//编号列为只读
        }

        private void btnUpdata_Click(object sender, EventArgs e)
        {
            bn.updatData(dgv, bn.DataSetName);
            bn.getDataGridViewValue(dgv);
        }


        private void dgv_CellClick(object sender, DataGridViewCellEventArgs e)
        {
           //在有记录的行上显示上下文菜单
            if (dgv.CurrentRow.Index < dgv.RowCount - 1)
            {
                dgv.ContextMenuStrip = rightMenu;
            }
            else
            {
                dgv.ContextMenuStrip = null;
            }
        }

        private void 删除ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            bn.MenuOperation(dgv, rightMenu.Items[1].Text, bn.DataSetName);
            bn.getDataGridViewValue(dgv);
        }

        private void btnDelete_Click(object sender, EventArgs e)
        {
            if (dgv.CurrentRow.Index > 0)
            {
                bn.MenuOperation(dgv, rightMenu.Items[1].Text, bn.DataSetName);
                bn.getDataGridViewValue(dgv);
            }
        }

        private void btnSave_Click(object sender, EventArgs e)
        {
            bn.SavaData(bn.DataSetName);
        }

        private void btnExit_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }


    }
}