3
Answers

SQL Query with varying number of parameters on Access DB using C# Express

Ian Kennedy

Ian Kennedy

15y
2.9k
1
I am writing a small departmental DB using Access and C# Express as a front end.

I am looking for some sample code to produce a query form with three parameter fields (similar to the following).  The resulting query should filter all the values entered:

Analyst: [              ]       Client [              ]     Status  [              ]

There does not seem to be a way to use LINQ for querying Access databases with SQL.  Can anyone point me to a tutorial/sample code to do this using ADO.NET (or better method)?

Thanks :-)

Ian
Answers (3)