3
Reply

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

Ian Kennedy

Ian Kennedy

Dec 9 2008 7:23 AM
2.9k
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)