gridView3.Columns[0].FieldName = "pis_ExpireDate"; var EXdates = DB0201.purchases_item_seriels.Where(u => (u.stitems_ID == ItemID && u.ss_StoreID == StoreID && u.pis_Statues == 0) || (u.stitems_ID == ItemID && u.ss_StoreID == StoreID && u.pis_Statues == 5) || (u.stitems_ID == ItemID && u.ss_StoreID == StoreID && u.pis_Statues == 6)) .OrderBy(o => o.pis_ExpireDate).Select(u => u.pis_ExpireDate).Distinct(); gridControl3.DataSource = EXdates.ToList();
gridView3.Columns[0].FieldName = "pis_ExpireDate"; var EXdates = DB0201.purchases_item_seriels.Where(u => (u.stitems_ID == ItemID && u.ss_StoreID == StoreID && u.pis_Statues == 0) || (u.stitems_ID == ItemID && u.ss_StoreID == StoreID && u.pis_Statues == 5) || (u.stitems_ID == ItemID && u.ss_StoreID == StoreID && u.pis_Statues == 6)) .OrderBy(o => o.pis_ExpiraeDate); gridControl3.DataSource = EXdates.ToList();
Where
var EXdates = DB0201.purchases_item_seriels.Where(u => u.stitems_ID == ItemID && u.ss_StoreID == StoreID && (u.pis_Statues == 0 || u.pis_Statues == 5 || u.pis_Statues == 6)) ...
int[] expiredStatuses = { 0, 5, 6 }; var EXdates = DB0201.purchases_item_seriels.Where(u => u.stitems_ID == ItemID && u.ss_StoreID == StoreID && expiredStatuses.Contains(u.pis_Statues)) ...
.Select(u => new { u.pis_ExpireDate })
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)