I need to be able to search a sql table on one of three fields. and display the contents in one Grid. I have been looking around to see if this has already been done but haven't found anything.
I have a RadioList with the three items the user could search against. How would I change the controlid and Parameters in code?
I have the same problem and until I find a true answer I've added three web grids and bind them to three separate sqldatasource with each specifying the criteria. Upon button click, I test which criteria and hide the datagrids not being used. Sloppy but works for me.