Multi Parameter Search
- From: "cfps.Christian" <ge0193387@xxxxxxx>
- Date: Thu, 3 Jan 2008 19:14:36 -0800 (PST)
I'm working on a program where I have a decent sized database with
almost every single value able to be searched for (there would
actually be a need for it). To make this easier on myself I've coded
views so that they're all in one central location and I don't have to
fully navigate the db structure to search. What I'm trying to
determine is a good preferably dynamic way to code my searches.
I have a potential of lets say 20 columns and any number from 1 to 20
can be search at any time (not necessarily any order but I'd like to
plan ahead). I'm trying to avoid writing individual SQL strings or
even passing in string of column/value since this even has a potential
of breaking.
Essentially I would love to have an object that directly represents
the column name and the datatype for use with intellisense. Again I
can't code for every column since they can easily change.
How have people done this in the past/present?
.
- Follow-Ups:
- Re: Multi Parameter Search
- From: Marc Gravell
- Re: Multi Parameter Search
- Prev by Date: Re: Using databinding to display settings
- Next by Date: TreeNode HasChildren()
- Previous by thread: Re: Using databinding to display settings
- Next by thread: Re: Multi Parameter Search
- Index(es):