string str = "";
string sql ="";
if (this.DropDownList1.SelectedItem.Text.Trim() != "请选择")
{
str += " and ";
str += "zname=" + "'" + this.DropDownList1.SelectedItem.Text.Trim() + "'";
}
if (this.DropDownList2.SelectedItem.Text.Trim() != "请选择")
{
str += " and ";
str += "zqs=" + "'" + this.DropDownList2.SelectedItem.Text.Trim() + "'";
}
if (this.DropDownList3.SelectedItem.Text.Trim() != "请选择")
{
str += " and ";
str += "zyear=" + "'" + this.DropDownList3.SelectedItem.Text.Trim() + "'";
}
string str1 = "";
if (str.StartsWith(" and"))
{
str1 = str.Substring(5);
}
if (str1 == "")
{
sql = "select * from zztable";
}
else
{
sql = "select * from zztable where " + str1.ToString().Trim();
}
DataTable dt = obj.GetTable(sql);
GridView1.DataSource = dt;
GridView1.DataBind();