예제 #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            string    name      = textBox1.Text.Trim();
            string    tablename = "goods";
            string    cmd       = string.Format("select * from {0} where goods_id like '%{1}%'", tablename, name);
            DataTable dt        = SystemDBhelper.getTableBySql(cmd, tablename);

            dataGridView1.DataSource = dt;
            if (dt.Rows.Count == 0)
            {
                MessageBox.Show("数据库中无匹配结果");
            }
        }
예제 #2
0
 private void Form4_Load(object sender, EventArgs e)
 {
     dataGridView1.DataSource = SystemDBhelper.getTable("goods");
     dataGridView1.ReadOnly   = true;
 }