Beginning ASP.NET 4.5.1

Beginning ASP.NET 4.5.1

Foreword. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxv

Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxvii

Chapt er 1 Getting started with ASP.NET 4.5.1. . . . . . . . . . . . . . . . . . . . . . . . . . . 1

Chapt er 2 Building an ASP.NET Website. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33

Chapt er 3 Designing Your Web Pages. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63

Chapt er 4 Working with ASP.NET Server Controls. . . . . . . . . . . . . . . . . . . . . . . 101

Chapt er 5 Programming Your ASP.NET Web Pages. . . . . . . . . . . . . . . . . . . . . . 135

Chapt er 6 Creating Consistent Looking Websites. . . . . . . . . . . . . . . . . . . . . . . 195

Chapt er 7 Navigation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 239

Chapt er 8 User Controls. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 273

Chapt er 9 Validating User Input. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 299

Chapt er 10 ASP.NET AJAX. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 337

Chapt er 11 jQuery. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 369

Chapt er 12 Introducing Databases. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 407

Chapt er 13 Displaying and Updating Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 439

Chapt er 14 LINQ and the ADO.NET Entity Framework. . . . . . . . . . . . . . . . . . . . 485

Chapt er 15 Working with Data — Advanced Topics. . . . . . . . . . . . . . . . . . . . . . 539

Chapt er 16 Security in Your ASP.NET Website. . . . . . . . . . . . . . . . . . . . . . . . . . . 589

Chapt er 17 Personalizing Websites. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 629

Chapt er 18 Exception Handling, Debugging, and Tracing. . . . . . . . . . . . . . . . . 663

Chapt er 19 Deploying Your Website. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 715

App endix A Exercise Answers. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 757

App endix B Configuring SQL Server 2012. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 781

Index. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 795

ffirs.indd 1 25-02-2014 10:44:30

ffirs.indd 2 25-02-2014 10:44:30

Beginning

ASP.NE T 4.5.1

ffirs.indd 3 25-02-2014 10:44:30

ffirs.indd 4 25-02-2014 10:44:30

Beginning

ASP.NE T 4.5.1

in C# and VB

Imar Spaanjaars

ffirs.indd 5 25-02-2014 10:44:36

Beginning ASP.NE T 4.5.1: in C# and VB

Published by

John Wiley & Sons, Inc.

10475 Crosspoint Boulevard

Indianapolis, IN 46256

www.wiley.com

Copyright © 2014 by John Wiley & Sons, Inc., Indianapolis, Indiana

Published simultaneously in Canada

ISBN: 978-1-118-84677-3

ISBN: 978-1-118-84690-2 (ebk)

ISBN: 978-1-118-84696-4 (ebk)

Manufactured in the United States of America

10 9 8 7 6 5 4 3 2 1

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means,

electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108

of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization

through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers,

MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the

Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011,

fax (201) 748-6008, or online at http://www.wiley.com/go/permissions.

Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties with

respect to the accuracy or completeness of the contents of this work and specifically disclaim all warranties, including

without limitation warranties of fitness for a particular purpose. No warranty may be created or extended by sales or

promotional materials. The advice and strategies contained herein may not be suitable for every situation. This work

is sold with the understanding that the publisher is not engaged in rendering legal, accounting, or other professional

services. If professional assistance is required, the services of a competent professional person should be sought. Neither

the publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Web site is

referred to in this work as a citation and/or a potential source of further information does not mean that the author or the

publisher endorses the information the organization or Web site may provide or recommendations it may make. Further,

readers should be aware that Internet Web sites listed in this work may have changed or disappeared between when this

work was written and when it is read.

For general information on our other products and services please contact our Customer Care Department within the

United States at (877) 762-2974, outside the United States at (317) 572-3993 or fax (317) 572-4002.

Wiley publishes in a variety of print and electronic formats and by print-on-demand. Some material included with standard

print versions of this book may not be included in e-books or in print-on-demand. If this book refers to media such as a CD

or DVD that is not included in the version you purchased, you may download this material at http://booksupport

.wiley.com. For more information about Wiley products, visit www.wiley.com.

Library of Congress Control Number: 2013958296

Trademarks: Wiley, the Wiley logo, Wrox, the Wrox logo, Programmer to Programmer, and related trade dress are

trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates, in the United States and other

countries, and may not be used without written permission. All other trademarks are the property of their respective

owners. John Wiley & Sons, Inc., is not associated with any product or vendor mentioned in this book.

ffirs.indd 6 25-02-2014 10:44:36

To Niek

ffirs.indd 7 25-02-2014 10:44:36

ffirs.indd 8 25-02-2014 10:44:36

About the Author

Imar Spaa njaa rs  graduated in Leisure Management at the Leisure Management School in the

Netherlands, but he quickly changed his career path to the Internet world.

After working in the Internet business at various web agencies for over twelve years, he now runs

his own company called De Vier Koeden (http://devierkoeden.com), a small Internet agency

specializing in consultancy and development of Internet and intranet applications with Microsoft

technologies such as ASP.NET 4.5.1. He’s also the CTO of Dynamicweb North America, the U.S.

branch of the popular Danish content management, e-commerce, and online marketing platform.

Imar has written books on ASP.NET and Macromedia Dreamweaver, all published under the Wrox

brand. He is also one of the top contributors to the Wrox Community Forum at p2p.wrox.com,

where he shares his knowledge with fellow programmers.

Imar has received Microsoft’s Most Valuable Professional (MVP) award each year since 2008 for

his contributions to the ASP.NET community. In early 2012, Imar joined the ASPInsiders, a small

group of international professionals that provide feedback and direction on new features for future

versions of ASP.NET.

Imar lives in Utrecht, the Netherlands, with his girlfriend Fleur and his son Niek. You can contact

him through his personal website at http://imar.spaanjaars.com or by e-mail at

[email protected].

ffirs.indd 9 25-02-2014 10:44:36

ffirs.indd 10 25-02-2014 10:44:36

Acquisitions Editor

Mary James

Project Editor

Brian Herrmann

Technical Editor

Jason Gaylord

Production Editor

Daniel Scribner

Editorial Manager

Mary Beth Wakefield

Associate Director of Marketing

David Mayhew

Marketing Manager

Ashley Zurcher

Business Manager

Amy Knies

Vice President and Executive Group

Publisher

Richard Swadley

Associate Publisher

Jim Minatel

Project Coordinator, Cover

Katie Crocker

Proofreaders

Josh Chase, Louise Watson, Sarah Kaikini,

Word One

Indexer

Robert Swanson

Cover Designer

Ryan Sneed

Cover Image

© Nevin Giesbrecht / iStockPhoto

Credits

ffirs.indd 11 25-02-2014 10:44:36

ffirs.indd 12 25-02-2014 10:44:36

Acknowledgments

Although the jump  in version number by only 0.1 seems to suggest that there’s not much new

in ASP.NET 4.5.1 or Visual Studio 2013, you’d be surprised at the number of changes — small

and large — that made their way into these products. I spent the past couple of months working

on updating this book from the .NET 4.5 release to the new .NET 4.5.1 release. I discovered new

features and functionality every day. Some of those changes are really small, but could mean a

boost in productivity on a day-to-day basis. Others are much bigger and affect the way you build

or deploy your websites. I tried to incorporate all the new features found in ASP.NET and Visual

Studio that will make sense for you, someone with no or limited experience with ASP.NET.

I have also made a lot of changes to the book based on reader feedback. Just as with the previous

versions of the book, I went over all the errata that have been submitted as well as over the hundreds

of forum posts that were made, identifying areas in the book that readers had difficulties with,

and finding ways to improve it. If you have the previous edition and posted a question in the Wrox

forums: thanks for your valuable feedback; you’ve really helped to make this book better.

Besides my readers, I owe a lot to other people who helped me write this book.

First of all, a big thanks goes out to Brian Herrmann for his editorial work. Once again, it was a

pleasure to work with you! I also want to thank Jason Gaylord for his many useful suggestions he

provided as a technical editor. Both of you really helped shape this book. Many thanks also to the

people from Wrox for their support and contributions to this book.

Another person I owe a lot to is my friend Anne Ward from Blue Violet, a UK-based web and

graphic design company. Anne has done most of the designs used in this book and I highly

appreciate her input. Thanks again, Anne! The concert pictures you see in this book come from

Nigel D. Nudds, who kindly let me use pictures from his collection.

Finally, I would like to thank my lovely girlfriend Fleur for her support during this project.

I couldn’t have done it without you!

ffirs.indd 13 25-02-2014 10:44:36