ถามเกี่ยวกับการใช้ sql search ทีคับ ทำไมฟิวที่มี status OFF อยู่ ทำไมถึงโชว์อ่ะคับ มึนตึ๊บ

string sql = "SELECT Agent.*, Province.P_NAME FROM Agent INNER JOIN Province ON Agent.P_ID = Province.P_ID where A_NAMETH like'%" + textBox1.Text.Trim() + "%' ";
                sql += "OR A_NAMEEN like'%" + textBox1.Text.Trim() + "%' ";
                sql += "OR A_PERMIT like'%" + textBox1.Text.Trim() + "%' ";
                sql += "OR A_ADDRESS like'%" + textBox1.Text.Trim() + "%' ";
                sql += "OR A_ZIPCODE like'%" + textBox1.Text.Trim() + "%' ";
                sql += "OR A_TEL like'%" + textBox1.Text.Trim() + "%' ";
                sql += "OR A_FAX like'%" + textBox1.Text.Trim() + "%' ";
                sql += "OR A_Email like'%" + textBox1.Text.Trim() + "%' ";
                sql += "OR A_LANSELL like'%" + textBox1.Text.Trim() + "%' ";
                sql += "AND A_STATUS LIKE 'ON' order by A_NAMEEN ASC";
                DS_VIEW = new DataSet("VIEW");
                DA_VIEW = new SqlDataAdapter(sql, CN);
                CB = new SqlCommandBuilder(DA_VIEW);
                DA_VIEW.Fill(DS_VIEW, "VIEW");