Hi all,

I built a stored procedure that needed to use dynamic sql for a search 
window. I used sp_executeSQL to accomplish this. I tried to create a dataset 
in the designer by dragging and dropping the stored procedure to it. The 
result is a 'QueriesTableAdapter' but no data set (The designer does not know 
the SELECT statement since it is a dynamic string... I would assume). I would 
like to attach a dataset to a gridview and simply call the Fill() method but 
the 'QueriesTableAdapter' only has one method which is my stored procedure 
name. 

How do I populate a grid view in this situation? If I can't use the 
'QueriesTableAdapter', what would be a suggestion on the easiest way to 
populate a gridview?

Thanks