单表多字段查询

 string sqlText="select * from stuInfo where 1=1";
   SqlConnection con=new SqlConnection("server=.;database=text;uid=sa;pwd=;");
   SqlDataAdapter sda=new SqlDataAdapter(sqlText,con);
   if(this.txtName.Text.Trim()!="")
   {
    sqlText+=" and stuName=@stuName";
    sda.SelectCommand.Parameters.Add("@stuName",this.txtName.Text);
    sda.SelectCommand.CommandText=sqlText;
   }
   if(this.txtAge.Text.Trim()!="")
   {
    sqlText+=" and stuAge=@stuAge";
    sda.SelectCommand.Parameters.Add("@stuAge",int.Parse(this.txtAge.Text));
    sda.SelectCommand.CommandText=sqlText;
   }
   if(this.txtScore.Text.Trim()!="")
   {
    sqlText+=" and stuScore=@stuScore";
    sda.SelectCommand.Parameters.Add("@stuScore",double.Parse(this.txtScore.Text));
    sda.SelectCommand.CommandText=sqlText;
   }
   DataTable dt=new DataTable();
   sda.Fill(dt);
   this.dataGrid1.DataSource=dt;