I created a dataset in the Dataset Designer by draging a database table into it, then I added a new select SQL query to the DataTable.
Check the pics I think it helps explain it better.
http://i43.tinypic.com/2qs7707.jpg"

Now the problem comes when I try to use an ObjectDataSource, it sees the Dataset just fine, but can not see the Query(method) I created.

http://i41.tinypic.com/29bc7wp.jpg

I have tried rebuilding the website, restarting Visual studio nothing works. Any ideas?

I'm using Visual Studio Team System 2008 with SP1.

So I solved the issue, apparently you cant use the "Select which returns a single value" option when creating the Query. Oops!