To widen or narrow a column, click and (Free web hosting with ftp)
To widen or narrow a column, click and hold on the bar to the right of that column s name, and then drag left or right. I ll need some sample data in my Transactions table to illustrate upcoming concepts. So I opened that table and added the records below. It s imperative that the value in each record s UserId field exactly matches an actual user s GUID in the aspnet_Users table. So, to enter GUIDs into records, I copied and pasted actual GUIDs from the aspnet_Users table. The TransactionId values are entered automatically. So when you get to that field, just press the Tab key to move to the next record without typing a TransactionId number. Dummies beware! Typing the GUIDs shown in Figure 11-25 into your own table will not work. Every GUID you manually enter into your own Transactions table must exactly match an actual GUID from your own aspnet_Users table. At this point, I have all the tables that the membership system created, plus my Items and Transactions tables. There is a natural many-to-many link between users in the Membership table and items in my Items table. The Transactions table contains the fields necessary to link many users to many items, and also provides a record of who purchased what and when. At this moment, SQL Server is not aware that there are relationships among these tables. You have to describe the relationships by linking tables together in queries. Figure 11-25: Sample data in the Transactions table. Figure 11-24: Adding some records to my Items table. 246 Part III: Personalization and Databases
If you are in need for chaep and reliable webhost to host your website, our recommendation is http web server services.