Hello,
I am attempting to work with the .Net 2.0 Roles api in an aspx page. I used the aspnet_regsql.exe command line utility to create a database to support application role management. I added a connection string to web.config. In Visual Studio 2005, I dropped a gridview onto a page and began using the smart tag to add and configure a data source. The only thing I am able to see at this point are the views. I spent a lot of time looking through permissions and creating a new, blank database and running InstallCommon.sql and InstallRoles.sql manually. Same result. Next, I tried added just a simple stored procedure of my own and re-ran the datasource wizard. That one stored procedure is visible. After some further experimentation, it seems that the configure data source wizard is ignoring anything with a name beginning with aspnet_. I can rename my test stored procedure to begin with aspnet_ and it disappears from the wizard. I can rename one of the existing stored procedures to begin with something else and it will appear in the wizard. Is there something hard coded into Visual Studio 2005 to ignore database objects prefixed with aspnet_?
Also, I do not see this behavior if I create a dataset in app_code. In that case, I select the option to use existing stored procedures and all of the stored procedures show up.
Thanks,