Beispiel #1
0
        private void showAllFindedData()
        {
            String sql = "select * " +
                         "from BasicData " +
                         "where 性别='" + cmbSex.Text + "' and 胸围>" + txt1_Bust.Text + " and 胸围<" + txt2_Bust.Text + " " +
                         "and 腰围>" + txt1_Waist.Text + " and 腰围<" + txt2_Waist.Text + " " +
                         "and 臀围>" + txt1_ButtockGirth.Text + " and 臀围<" + txt2_ButtockGirth.Text + " " +
                         "and 年龄>" + txt1_Age.Text + " and 年龄<" + txt2_Age.Text +
                         "and 身高>" + txt1_BodyHigh.Text + " and 身高<" + txt2_BodyHigh.Text;

            BaseClass.DataBase myDataUtil = new BaseClass.DataBase();
            this.allFindedDataSet = myDataUtil.RunProcReturn(sql, "BasicData");
            this.dataGridViewFindResult.DataSource = allFindedDataSet.Tables[0];
        }