1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
DataTable table = new DataTable();
string requete= " SELECT 'ARTICLE', 'DESCRIPT1', 'DESCRIPT2', 'EMPLAC', 'BS', 'UM', 'QUANTITE', 'PU', 'MONTANT', 'DATE_MVT', 'DATE_GL', 'CPT_IMPUT', 'CC', 'SECTION', 'UTILISAT' FROM 'TEST'.'V_MVT_II_NAD' ";
DB2DataAdapter AdapTContact = new DB2DataAdapter(requete, connection);
AdapTContact.Fill(table);
DataView dv = new DataView();
///////filtrer selon les deux dates choisies
string newFilter = string.Empty;
if(!dateTimePicker1.Text.Equals(string.Empty)&& !dateTimePicker2.Text.Equals(string.Empty))
{
newFilter += "DATE_MVT < '%" + getFilterValue(this.dateTimePicker2.Text) + "%'";
newFilter += " AND ";
newFilter += "DATE_MVT > '%" + getFilterValue(this.dateTimePicker1.Text) + "%'";
}
dv.RowFilter = newFilter;
return dv; |
Partager