Hi,

i defined a sqldatasource in VWD. The table involved in the select is vw_aspnet_Roles. No problem so far, but when i try to take the advanced option (insert, delete ..), the option is not available (can't check it), even when i take all fields (with primary keys).

Why is that and can it be solved in VWD?

Thanks

H.

This isn't a VWD question it is a SQL question. I am going to assume that you do not understand how SQL works as that is the logical reason for your query.

Simply put a view isn't a table it is a view of some arbitary data; in your specific case the view is composed of this code:

SELECT ApplicationId, RoleId, RoleName, LoweredRoleName, Description
FROM dbo.aspnet_Roles

This is a very basic view and, in reality, there is no difference between doing
SELECT * from vw_aspnet_Roles and
SELECT * from aspnet_roles

It yeilds the same data. The reason you are having this problem, as i said, is because a View is a representation of data from 1 or many tables, it isn't actually a table in and of itself thus it can't be inserted, updated, or deleted from. To actually alter the view you need to make changes to the table the view references, in this case aspnet_Roles.

To correct this, alter your select statement to be something like:

SELECT ApplicationId, RoleId, RoleName, LoweredRoleName, Description
FROM dbo.aspnet_Roles

the datasource should then allow you to provide insert, update, and delete commands.

hth.


================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

I didn't know that 'vw' meant view.
Thanks

'vw' doesn't necessarily mean view but it is a logical prefix. In any event you will notice that this particular data element exsits underneath the 'Views' folder as opposed to the Tables folder in your Database Explorer in VWD.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

In fact, i have still the same question:
why does VWD show in the dropdownlist a view of aspnet_roles instead of simply the table itself, like for all my own created tables?
Because they are 'special' tables created by aspnet during creating users?
Thanks

VWD might be blocking them, sure. You can override the wizard and do something like this:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:AppString1%>"
SelectCommand="SELECT RoleId, RoleName FROM
aspnet_Roles"
UpdateCommand="UPDATE aspnet_Roles SET [RoleName]=@RoleName,
WHERE RoleId = @RoleID">
</asp:SqlDataSource>

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========