Advanced SQL Generation Options disabled

[ItHurtsWhenIThink]

VS2010 will not allow me to use the ASGO when confuguring a data source for a FormView. Not only that, but I only see table that I created. I do see views as well. I just spent a S--- load of time scouring the web for answers. Some say the problem that it reuires a key to be selected in the query (which I have done). Still no solution.


any thoughts?

 

[ItHurtsWhenIThink]

Oh...

What I meant about only being able to view tables that I created. I see table I created that are not those that belong to the membership ASPNETDB. The membership tables (users, roles etc.) are the onesthat only show up as views.