Question

C#中select from where

where后面可以加多个条件么 具体语句应该怎么写呢 下面是一个条件的 如果要加其他or条件怎么加呢
string sql = "select * from WeldingDB where 母材='" + textBox12.Text.Trim() + "'";

Answer 1

条件后面如果需要都满足 就加 where 条件1=‘’ and 条件2=‘’ //条件1和条件2都满足才通过；
如果只满足其中一条 where 条件1=‘’ or 条件2=‘’ //条件1和条件2满足其中一条就通过

Answer 2

select * from XX where ID in(1,19);
select * from XX where ID=1 or ID=19;

string sql = "select * from WeldingDB where 母材 in('" + textBox12.Text.Trim() +"','"+ textBox12.Text.Trim() "')";