I ask for vb net datagridview,
How do you fill in the "aging" column with status on or off ...
If SC01 has three POS, where one of the POS has ttl_stat OFF, the "aging" column will be filled OFF.
And if SC02 only has one POS and ttl_stat on then the "aging" column will also be ON
Thank you
You can do this in SQL:
SELECT *,
(SELECT CASE WHEN EXISTS(
(SELECT t2.kd_store FROM test_stack t2
WHERE t.kd_store = t2.kd_store
AND t2.ttl_stat = 'OFF'
)
) THEN 'OFF' ELSE 'ON' END
) AS Aging
FROM test_stack t
thank you for helping, so how do i input to vb net for that sql script?
Hm where is your data of the grid coming from? I thought you already load it from a database
so the datagridview comes from when I import master data using csv. This is the source when I import CSV.
Hi @Alex help me please .. :(
sorry I was not online last weekend. will respond later