form1.cs

来自「vs2005串口编程示例,好多例子,是学习串口编程方面不错的资料」· CS 代码 · 共 52 行

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;
        }
    }
}