C# ASP:SqlDataSource - Repeater

[joehaxor]

My question is: How do I keep the page from auto querying on page load.

I have a ASP:SqlDataSource bound to a Repeater. This repeater replicates tables beneath a search form. The Search form is a postback. I want to page to load with no search results until they actively enter data into the search form and click the search button. There are so many results when the page loads, thousands :(
i dont think my users would like that much.

Thanks in advance to anyone that might be able to help with this

[nateraaaa]

You could turn the Visible property to false on page load. Then when the user clicks search turn the Visible property to true to show the results of the search.

Nathan

[joehaxor]

You could turn the Visible property to false on page load. Then when the user clicks search turn the Visible property to true to show the results of the search.

Nathan

True, but does hiding the results keep the results from processing and being rendered on the page? That is the performance issue I am having. There are thousands of records processing when the page loads instead of waiting for a search form to post back. I do not know if this makes any sense :-D i hope.

[joehaxor]

Okay, I guess I could have tried to do it before I asked. I tried the visible thing and it solved the problem perfectly! Thanks for your great idea.

[Plater]

It may still execute the query
You should be looking at the IsPostBack value and possibly whether or not the correct event has been fired

[joehaxor]

It may still execute the query
You should be looking at the IsPostBack value and possibly whether or not the correct event has been fired

it might be executing the query, but that's okay as long as it doesn't hold the page up from loading, which it is not. As long as the page loads fast for my customers i think i will be fine. thanks for the input.

[nateraaaa]

You could execute your search query in the button click event if the page starts getting slow while loading. That is what I do on some of my forms. I let the user enter items to customize the search then pass what they entered as parameters to a search proc in the button click event. The proc returns results that are then shown to the user in a datagrid.

Nathan