There is, however, a view named vw_aspnet_MembershipUsers already (Medical web site)
There is, however, a view named vw_aspnet_MembershipUsers already defined under Views in Database Explorer. You can use that view in place of the aspnet_Users table to create a query that includes users e-mail addresses. Creating another view named DetailedUsersItemsView illustrates the point: 1. Right-click the Views folder and choose Add New View. 2. In the Add Tables dialog box, click the Views tab, click vw_aspnet_MemberhsipUsers, then click the Add button. 3. In the Add Tables dialog box, click the Tables tab. 4. Click the Transactions table, then click Add. 5. Click the Items table, then click Add. 6. Click Close in the Add Tables dialog box. 7. In the diagram pane, drag the UserId field in the vw_aspnet_ MembershipUsers field list to the UserId field name in the Transactions table. The two fields will then be connected by a line as shown in Figure 11-30. In Figure 11-30, I sized and arranged things so you can see all the field lists and the lines joining the tables by their key fields. The query can return any fields from any table you see. In Figure 11-30, I chose some fields that might come in handy in the future. However, you can choose any fields you like. Executing the query returns a set of records similar to those from the lessdetailed query exactly one record per transaction shows up in the query Figure 11-30: The Detailed Users Items View s tables and selected fields. 252 Part III: Personalization and Databases
If you are looking for affordable and reliable webhost to host and run your business application visit our ftp web hosting services.