K
KeesBlunder
Guest
Hello,
Use Union on 2 tabels in a sqlce database , oke that works.
But the filter is not working , there is no error but not oke.
Only an error when i don't fill in a number in Reisnr.text but that is normal i think, you can't search on a empty textbox
cmd = New SqlCeCommand("Select Reisnr, Subnr, Ladenoflossen, Bestemming, Kgladen As KG From Laden
UNION
Select Reisnr, Subnr, Ladenoflossen, Naamzeeboot, Kgbdn From Lossen WHERE Reisnr = '" & Reisnr.Text & "'", con)
I want to filter here on Reisnr 1 , but it is showing all of the database ?
The number in Reisnr.textbox was 1
This is the outcome , there is also Reisnr 2.
That is not what i want
I only want to see Reisnr 1
Continue reading...
Use Union on 2 tabels in a sqlce database , oke that works.
But the filter is not working , there is no error but not oke.
Only an error when i don't fill in a number in Reisnr.text but that is normal i think, you can't search on a empty textbox
cmd = New SqlCeCommand("Select Reisnr, Subnr, Ladenoflossen, Bestemming, Kgladen As KG From Laden
UNION
Select Reisnr, Subnr, Ladenoflossen, Naamzeeboot, Kgbdn From Lossen WHERE Reisnr = '" & Reisnr.Text & "'", con)
I want to filter here on Reisnr 1 , but it is showing all of the database ?
The number in Reisnr.textbox was 1
This is the outcome , there is also Reisnr 2.
That is not what i want
I only want to see Reisnr 1
Continue reading...