C#连接SQL多条件复杂查询

 

控件说明:

供应商 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;