Waste of Time: Key not valid for use in specified state
Visual Studio was giving me this nice error in the dataset designer today. Refusing to allow me to edit my datasets. How dare it! What a waste of time. The fix was to remove the database connection from Data Connection in Server Explorer and then recreate it.