Looking for code examples (C#) for ASP 2.0 that provides a model to create dynamic sql strings from user defined "arguments" supplied by text box, drop down list (single and multi select), radial buttons on an input form. Looking for best practices in persisting this input data to database that assists in the implementation of the "search" engine/SQL query generation. I'm not looking for optimizing browser search engines like "google" etc.

Appreciate it... thanks

One of the most important best practices is to search MSDN for examples of "SQL parameters", you capture user data and store them in parameters and then incorporate the parameters into the SQL query. Parameters protect your database from hackers looking to get into your database records. Another important security related feature to check on is to look up "stored procedures". Again, it keeps your database queries better protected, so that your code behind simply makes a reference to a stored procedure for your application instead of having SQL in the actual C# code.

-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.