控件说明:
供应商 CheckedBox ckbID 供应商 MasktextBox mtxtID
价格 CheckedBox ckPirce 价格 MasktextBox mtxtPrice 价格 ComboBox cmbPrice
产地 CheckedBox ckbProd 产地 ComboBox cmbProd
品名 CheckedBox ckbVariety 品名 ComboBox cmbVariety
DataGridView dataGridView1 toolStripStatusLabel toolStripStatusLabel1
查找按钮 Botton btnSearch 退出按钮 Botton btnExit
源代码
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.SqlClient;
namespace 利用选择控件来实现复杂查询
{
public partial class Form1 : Form
{
public string ID; //存储供应商ID
public string Prod; //存储产地
public string Price; //存储价格比较结果
public string Variety; //存储商品名称
public string strSQL; //储存完整SQL语句
public Form1()
{
InitializeComponent();
}
#region 自定义初始连接数据库方法
//该方法用来对2个ComboBox控件赋值;传递2个参数,1个为对象(那一个控件),1个为字符串(按数据表的那一列查询)
private void SQLconn(object comboxOBJ,string ROW)
{
SqlConnection conn = new SqlConnection("server = (local); uid = sa; database = 销售管理系统");
conn.Open();
string strSql = "select DISTINCT " + ROW + " FROM 商品信息";
SqlCommand cmd = new SqlCommand(strSql, conn);
SqlDataReader dr = cmd.ExecuteReader();
//此处判断该方法传入的对象参数是否为ComboBox控件
if (comboxOBJ.GetType().ToString() == "System.Windows.Forms.ComboBox")
{
//如果是,则实例化临时对象,用来把数据循环赋值给参数所指定的控件
ComboBox cbo = (ComboBox)comboxOBJ;