根据不同的dropdownlist选择值选择数据.txt

来自「学习积累的代码段」· 文本 代码 · 共 25 行

    DropDownList DropDownList1 = new DropDownList();
   
     DropDownList DropDownList2 = new DropDownList();
    
    string sqlstr1 = " SELECT * FROM Table1 ";
     
   string sqlstr2 = "";
        //客户
     
   if (DropDownList1.SelectedItem.Text != "")
     
   {
            sqlstr2 += " Custom_Name = '" + DropDownList1.SelectedItem.Text + "' ";
        }
        //项目
        if (DropDownList2.SelectedItem.Text != "")
    
    {
            sqlstr2 += " Xiangmu_Name = '" + DropDownList2.SelectedItem.Text + "' ";
        }
  
      if(sqlstr2 != "")
        {
            sqlstr1 += " WHERE " + sqlstr2;
        }