基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 1 元　

支付宝支付

微信支付

   源码介绍

---

【使用快捷键 操作数据库: 增、删、改、查】

 

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data.SqlClient;

namespace test
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // TODO:  这行代码将数据加载到表“hyckDataSet.Item”中。您可以根据需要移动或删除它。
            this.itemTableAdapter.Fill(this.hyckDataSet.Item);
            dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
            TxtNo.Focus();

        }

        private void button1_Click(object sender, EventArgs e)
        {
  
        }

        private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
        {
            UpdateData();
        }

        private void dataGridView1_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == 27)
            {
                this.Close();
            }
            


        }

        private void dataGridView1_DataError(object sender, DataGridViewDataErrorEventArgs e)
        {
            dataGridView1.CancelEdit();
            e.Cancel = true;
        }
       


        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void button2_Click(object sender, EventArgs e)

        {
           

        }

        private void Form1_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == 27)
            {
                this.Close();
            }
        }

        private void UpdateData()
        {
            try
            {
                itemTableAdapter.Update(hyckDataSet);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "出现错误");
            }

        }
        private void button3_Click(object sender, EventArgs e)
        {
            
        }

        private void dataGridView1_KeyUp(object sender, KeyEventArgs e)
        {
        
        }

        private void dataGridView1_KeyDown(object sender, KeyEventArgs e)
        {

        }

        private void dataGridView1_DefaultValuesNeeded(object sender, DataGridViewRowEventArgs e)
        {
   
        }

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

        private void BtnDel_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("确定要删除这行吗？", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
            {
                dataGridView1.Rows.Remove(dataGridView1.CurrentRow);
                UpdateData();

            }
        }

        private void BtnAdd_Click(object sender, EventArgs e)
        {
            try
            {

                OleDbConnection oleDb = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\hyck.mdb");
                oleDb.Open();
                string sql;
                if (TxtDesc.Text=="")
                {
                  sql = "insert into Item (ItemNo,ItemName,ItemDesc,QTY,Unit) values ('"   TxtNo.Text   "','"   TxtName.Text   "',null,"   TxtQty.Text   ",'"   CbUnit.Text   "')";
                }
                else
                {
                  sql = "insert into Item (ItemNo,ItemName,ItemDesc,QTY,Unit) values ('"   TxtNo.Text   "','"   TxtName.Text   "','"   TxtDesc.Text   "',"   TxtQty.Text   ",'"   CbUnit.Text   "')";
                }
                OleDbCommand oleDbCommand = new OleDbCommand(sql, oleDb);
                oleDbCommand.ExecuteNonQuery(); //返回被修改的数目
                oleDb.Close();

                MessageBox.Show("添加成功！");
                TxtNo.Text  = "";
                TxtName.Text  = "";
                TxtDesc.Text  = "";
                TxtQty.Text = "0";
                CbUnit.SelectedIndex = 0;
                TxtNo.Focus();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "出现错误");
            }

        }

        private void BtnEdit_Click(object sender, EventArgs e)
        {
            dataGridView1.ReadOnly = false;



        }

        private void TxtQty_Enter(object sender, EventArgs e)
        {
           
        }

        private void TxtQty_Click(object sender, EventArgs e)
        {
            TxtQty.SelectAll();
        }

        private void TxtQty_TextChanged(object sender, EventArgs e)
        {

        }

        private void Form1_KeyDown(object sender, KeyEventArgs e)
        {
            switch (e.KeyCode)
            {
                case Keys.F1:
                    BtnAdd_Click(this, EventArgs.Empty);
                    break;

                case Keys.F2:
                    BtnDel_Click(this, EventArgs.Empty);
                    break;
                case Keys.F3:
                    BtnEdit_Click(this, EventArgs.Empty);
                    break;
            }
        }

        private void TxtQty_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar != 8 && e.KeyChar != '.' && !Char.IsDigit(e.KeyChar))
            {
                e.Handled = true;
            } 
        }
    }
}