1,217
社区成员




SELECT PO_NO, Department, MaterialCode, Specification, Quantity, TermsOfTrade, StartDate, EndDate, Remarks
FROM T_PO
WHERE (Department LIKE '装配%') OR (PO_NO = 'txtPO_NO.[text]')
SQL="SELECT PO_NO, Department, MaterialCode, Specification, Quantity," & _ "TermsOfTrade, StartDate, EndDate, Remarks FROM T_PO WHERE " & _ "(Department LIKE '装配%') OR (PO_NO = '" & txtPO_NO.[text] & "')"
然后把SQL赋给T_POTableAdapter的数据源,再执行查询就行了。
SQL="SELECT PO_NO, Department, MaterialCode, Specification, Quantity," & _
"TermsOfTrade, StartDate, EndDate, Remarks FROM T_PO WHERE " & _
"(Department LIKE '装配%') OR (PO_NO = '" & txtPO_NO.[text] & "')'
然后把SQL赋给T_POTableAdapter的数据源,再执行查询就行了。