OleDbCommand cmd = new OleDbCommand("select * from Salary where GPFCPF=? AND NameOfUnit=? AND GPFcategory=? AND SDATE BETWEEN @date1 and @date2 AND PoNo1 <> ? OR PoNo2 <> ? OR PoNo3 <> ? OR PoNo4 <> ? OR PoNo5 <> ? OR PoNo6 <> ? OR PoNo7 <> ? OR PoNo8 <> ? ORDER BY SlipNo ASC", con);
OleDbCommand cmd = new OleDbCommand("select * from Salary where (GPFCPF=? AND NameOfUnit=? AND GPFcategory=? AND PoNo1 <> ? OR PoNo2 <> ? OR PoNo3 <> ? OR PoNo4 <> ? OR PoNo5 <> ? OR PoNo6 <> ? OR PoNo7 <> ? OR PoNo8 <> ? ) AND (SDATE BETWEEN @date1 and @date2) ORDER BY SlipNo ASC", con);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)