select * from [表名] where 工号 like '%'" + textbox1.Text + "'%' or 姓名 like '%'" + textbox1.Text + "'%'
if (is int) { selectid=textbox1.text; } else { selectname=textbox1.text; } select * from [表名] where 工号 like '%'" + selectid + "'%' or 姓名 like '%'" + selectname + "'%'
{
selectid=textbox1.text;
}
else
{
selectname=textbox1.text;
}
select * from [表名] where 工号 like '%'" + selectid + "'%' or 姓名 like '%'" + selectname + "'%'