Of Stored Procs, the 2005 DataSet designer, and blood on your forehead...
Here's the issue. It involves using the dataset designer in vs 2005, which is supposedly [ahem] better than it used to be, bouncing off of very explicitly-written stored procedures. And using ObjectDataSources to bind to asp.net controls (gridview). Want to help me? There's blood all over my desk, monitor, and keyboard from being banged by my head for over 3 days. Help. Please.
Read more here. http://forums.asp.net/thread/1410329.aspx