Monday, March 19, 2012

Cant see added columns in ASPNETDB.mdf

In developing a VWDE project I added 2 columns to the User table in the ASPNETDB.mdf database. I can see the columns in the Data Definition and I can see the values I added when I Show Table Data but I cannot access them with a SQLDataSource control? The SQLDataSource shows all of the columns in that table except the ones I added. Any suggestions? Thanks.Have you saved the changes to the table before you want to see them in the SqlDataSource?|||

Thank you for responding!

I have saved it, gone in and out of the application over several days and every time, when I look at it in the database explorer window, it shows the added columns and the added data but the SqlDataSource only shows the original columns. I deleted the first SqlDataSource and put in a new one and that didn't help. I know you can add tables to ASPNETDB.mdf but is there something that won't let you add columns to the tables used in the Membership tables (like users)?

No comments:

Post a Comment