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;
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;