I want to change the result set of my gridview on the click of a button.

Anyone have any sample code to do this?

I've already got a gridview set up which can insert,update,edit etc.

Just not sure how to change the select statement within the gridview setup. I've seen selectcommandtype="Text" or "storeprocedure" I guess it's along those lines?

Thanks.