110,534
社区成员
发帖
与我相关
我的任务
分享
str sql = "select * from tb_student where 1=1";
if(checkbox1.checked)
sql += " and StuName like '%"+text1.Text+"%' ";
if(checkbox2.checked)
sql += " and StuID like '%"+text2.Text+"%' ";
if(checkbox3.checked)
sql += " and StuADD like '%"+text3.Text+"%' ";
sqldatasource1.selectcammand = sql;
private void GetSqlString()
{
string sql = @"SELECT * FROM tb_Server WHERE 1=1 ";
if(CheckBox1.Checked)
sql += @" and StuName like '%"+text1.Text+"%' ";
if(CheckBox2.Checked)
sql += @" and StuID like '%"+text2.Text+"%' ";
if(CheckBox3.Checked)
sql += @" and StuADD like '%"+text3.Text+"%' ";
SqlData1.SelectCommand = GetSqlString();
}