ODS + GridView -- how to prevent databinding when control parameters not yet set

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hello

I'm displaying report on a gridview through object data source which
gets some parameters from ddl controls. Using sql profiler I've found
out that even when controls are not yet set (by default they are set to
empty string value, so I guess they should be interpreted as nulls)
query (with empty parameters) is sent to sql server (it doesn't return
anything). It causes unnecessary server load and slows down each
postback, until all controls are set and gridview can display data.

Isn't there any way to prevent the databinding and sending query to sql
server until all object data source parameters are set (i.e. not null)?
I know something like that is possible with sql datasource.

I mean of course declarative way without adding additional biz. layer,
but if it's not possible then I'd be glad to see any elegant solutions
with small amount of additional code.

thanks

.

Relevant Pages

  • Re: Question about Class Helpers
    ... This was "inspired" by my previous life as a Gupta SQL Windows developer ... The "containers" could be variables or GUI controls!! ... really viable to support only a specific set of classes, ... I implemented a set of binder classes (a binder class being truly ...
    (borland.public.delphi.non-technical)
  • Re: Setting form properties
    ... I call a SQL function I wrote in SQL ... > subform control, down to the form on the subform..... ... > determines what update rights a user has on the form. ... 10 subform *controls* on the tab pages, which may or may not be the ...
    (microsoft.public.access.formscoding)
  • Re: Question about Class Helpers
    ... Instead of trying to think how you can add DB awareness to an existing control, instead try thinking about how you might make a DB framework aware of those controls. ... This was "inspired" by my previous life as a Gupta SQL Windows developer where you could write this sort of thing in your application SQL code: ... Now of course, I couldn't possibly anticipate ALL the classes of controls that might ever be referenced in runtime SQL, and it wasn't really viable to support only a specific set of classes, so I implemented an abstract "binder" class with the sole responsibility for "Get"ting and "Set"ting data from a specific control class on request from the SQL API framework. ... Of course, any controls that inherited from a class for which a binder class was registered would be supported by that binder, OR you could implement an even more specialised binder for that specific sub-class. ...
    (borland.public.delphi.non-technical)
  • Re: Give a man a fish?
    ... You can actually learn much about SQL just by switching your queries to SQL view. ... Next, you will be learning about forms, and the various controls you can put on them The controls and the form both have events that fire when something happens. ... Functions such as the Spacein your example are part of the VBA code, but you can use them in contexts outside of code. ...
    (microsoft.public.access.reports)
  • Re: Selecting multiple checkboxes inside a GridView control
    ... Walk through all of the rows in the GridView and construct a comma-delimited string of the IDs of those which are checked. ... Create a stored procedure like below and pass the above string to it: ... DECLARE @strSQL nvarchar ... Rem in the PRINT line and rem out the last two lines if you want to see what the dynamic SQL looks like first for testing purposes. ...
    (microsoft.public.dotnet.framework.aspnet)