I have data already populated in a datagrid
I have three textbox txtCustomername, txtPartcode, txtinvo
I want the user to be able to input text into the txtcustomername text box which will result in the datagrid only showing the rows that relate to that customer. Then I want the user to be able to input a partcode into the txtPartcode which will result in that data being reduced even more.
now i can write diffrent SQL select codes but it gets complicated testing which textbox are empty theirfor which select query to use.
does anyone have any ideas How i can accomplish this?