I don't have a good solution for you, but one thing to keep in mind with that kind of query engine is that users think differently than we do. They say things like, "I want all customers in NY and NJ". We say, "A customer can't be in both, so it's NY or NJ".
>Hi everybody,
>
>I want to ask this question here as well.
>
>We have a People page which has a GridView list of all people, the search button and SQLWhereBuilder great free control from
http://www.codeproject.com/KB/custom-controls/SqlWhereBuilder.aspx>
>It also has several image buttons on the top such as View Communication Log, Create Excel List, Send Emails. Two of these buttons use JavaScript OnClick to open a new window with parameters and no code behind. The functionality of these buttons depends on having a dataset in the session.
>
>So, my colleague implemented it as always creating a dataset and storing it in the session.
>
>I believe it's too heavy on the resources to store such big object in a session just in case the user will press any of these buttons. There should be a better solution for this to create the dataset only after any of these buttons is pressed. However, since two of them use JavaScript code and no code-behind I don't see a way to solve this problem.
>
>Would you please suggest me some good solution?
>
>Thanks in advance.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer