Hi

In ASP many years ago if I had an SQL query where I had multiple parameters not all of which may be filled in I created the SQL in code.

In the same situation in ASP .NET what are my options. I don't seem to be able to find anything where I may have a flexible number of query parameters. Am I still having to build up my query in code.

Any thoughts / examples.

Thanks