Visual Basic .net: Datagridview multiple columns search from 4 tables using inner join-with code

[@buddhikaperera5716]

thanks sir... l always learn from you a lot..

[@programmingforeverybody]

thank you much

[@taufiqputra2791]

I write all code exactly but no one record showed up in data grid view. but when I marked comment on all line query1 &= then datagridview shows all the datas but I can't performs searching function. please your advise where am I wrong? 🙏

[@ferhatallel6822]

please, how to add a condition to this code to hide null or zero values, I have already asked the same question you have not answered me

[@ferhatallel6822]

help me please

[@anacletocorbeta3846]

open your tablename that you created in access database select "Design View" in the bottom area you can see menu strip - instead of General choose "Look Up" you can change value there

[@mthokozisi9328]

HELLOW SIR..THANKS FOR YOUR HELP, but I ALWAYS GET THE SAME ERROR WITH YOUR CODE .System.InvalidOperationException: 'The SelectCommand property has not been initialized before calling 'Fill'.' PLZ HELP