I'm trying to set up a simple program in Visual Studio to help out a friend improve their data setup; the kind of thing where they can effectively go 'Show me all employees with Employee ID = textbox1.text AND Salary = textbox2.text.' They sent me an Excel file which I set up as a MS Access OLEDB; I linked that to a VS solution and can display and edit the data, but so far I can only query the data with ONE textbox input at a time. They're going to be running this on older computers, and I'm trying to make the transition from Excel painless. So far, I'm working in Visual Basic though considering transferring to C#.

Does anyone have any advice or leads for getting something like this done? The only solution I can think of (which I can't get working) is concatenating textbox input to a query string, but that would require additional injection-prevention. Almost positive there's a more effective way to handle this whole thing but turned up empty-handed after a day of Googling. 😰