基本信息

---

下载

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

---

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

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

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

using System.Data.OleDb;

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

        private void textBox1_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="   "price.mdb"   ";Persist Security Info=False");
                OleDbDataAdapter dap = new OleDbDataAdapter("select * from MerchandiseInfo where barcode='"   textBox1.Text   "'", con);
                DataSet ds = new DataSet();
                dap.Fill(ds);
                if (ds.Tables[0].Rows.Count == 0)
                {
                    MessageBox.Show("该商品不存在！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    return;
                }
                for (int i = 0; i < dataGridView1.RowCount; i  )
                {
                    if (Convert.ToString(dataGridView1[0, i].Value) == "")
                    {
                        dataGridView1[0, i].Value = ds.Tables[0].Rows[0][0].ToString();
                        dataGridView1[1, i].Value = ds.Tables[0].Rows[0][1].ToString();
                        dataGridView1[2, i].Value = ds.Tables[0].Rows[0][2].ToString();
                        dataGridView1[3, i].Value = ds.Tables[0].Rows[0][3].ToString();
                        return;
                    }
                }
            }
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            dataGridView1.RowCount = 20;
        }
    }
}