SqlDataSource not loading on page load

[David Lozzi]

Howdy,

I have a gridview and a sqldatasource. i need to do a little processing
before I can let the GridView run and load from the SqlDataSource. I have
the query I need already in the SelectCommand of the SDS so it runs when the
page is first loaded. Is there a way to stop it from loading and let it load
programatically? My first guess is to remove the select command from the SDS
and populate it when I want it to load, then DataBind the GridView. What do
you think?

Thanks,

David Lozzi

 

[David Wier]

You could remove the select command, as you said, then, in the event of your
choice, put something like:
MyDataSource.SelectCommand="YourSQLGoesHere"
Gridview1.Databind

David Wier
MVP/AsPInsider
http://aspnet101.com
http://iwritepro.com