book

ASP.NET 2.0 All-In-One Desk Reference For Dummies®

Name: ASP.NET 2.0 All-In-One Desk Reference For Dummies®
ISBN: 9780471785989

by Doug Lowe, Jeff Cogswell, Ken Cox - Microsoft MVP

July 2006

Beginner

910 pages

20h 14m

English

Wiley

Read now

Unlock full access

Copyright
Dedication
About the Author
Author’s Acknowledgments
Publisher’s Acknowledgments
Introduction
About This BookHow to Use This BookHow This Book Is OrganizedBook I: ASP.NET BasicsBook II: Web ControlsBook III: HTMLBook IV: C#Book V: Visual BasicBook VI: Database ProgrammingBook VII: Using the .NET FrameworkBook VIII: Advanced ASP.NET ProgrammingIcons Used in This BookWhere to Go from Here
I. ASP.NET Basics
1. Welcome to ASP.NET Programming
What Is ASP.NET, and Why Is It So Great?Windows and IIS dependenceObject orientationChoice of languagesVisual StudioUnderstanding Web Servers and BrowsersUnderstanding Static Web PagesUnderstanding Dynamic Web PagesLooking at a Simple ASP.NET ApplicationThe .aspx (Markup) File for the Simple Calculator ApplicationThe Code-Behind File of the Simple Calculator Application
2. Installing Visual Studio Web Developer 2005 Express Edition or Visual Studio 2005
Looking at Visual Studio 2005 EditionsConsidering Visual Web Developer 2005 Express EditionInstalling Visual Web Developer 2005 Express EditionRegistering Visual Web Developer 2005 Express EditionInstalling Visual Studio 2005
3. Creating Your First ASP.NET 2.0 Application
Understanding Visual Studio ProjectsCreating a New Web SiteUsing the Solution ExplorerWorking with ControlsSetting PropertiesSetting the Page TitleLooking at the Source CodeAdding Some CodeRunning the Application
4. Understanding Postback, Events, and Code-Behind
Understanding PostbackUsing the IsPostBack VariableUnderstanding EventsUsing the Handles Clause in Visual BasicDesignating an Event Handler in C#Using C#’s Auto Event WireupUnderstanding Code-BehindUsing Single-File Pages

5. Creating Multipage Applications
Understanding the Basics of a Multipage ApplicationAdding PagesRedirecting to Another PageAdding ClassesUsing Session StateLooking into Data BindingUsing Master PagesCreating a Master PageCreating a content pageThe C# Version of the Shopping Cart ApplicationThe VB.NET Version of the Shopping Cart Application
6. Testing and Debugging Your ASP.NET Applications
Creating a Simple Calculator ApplicationRunning an ASP.NET ApplicationDealing with ErrorsWorking in Break ModeDisplaying Variable DataStepping Through a ProgramSetting BreakpointsUsing Response.Write for Debugging
II. Web Controls
1. Using Basic Web Server Controls
Using Label ControlsUsing TextBox ControlsUsing Button ControlsUsing CheckBox ControlsChecking the Checked propertyAnother way to check the Checked propertyUsing RadioButton ControlsUsing Image Controls
2. Using Validation Controls
Validating the Hard WayValidation Controls to the Rescue!Using the RequiredFieldValidator ControlUsing the CompareValidator ControlUsing the RangeValidator ControlUsing the RegularExpressionValidatorUsing a CustomValidator ControlUsing the ValidationSummary ControlUsing the CausesValidation and ValidationGroup Properties
3. Using List Controls
Using the CheckBoxList ControlCreating columnsAligning text with check boxesSpacing things outWorking with ListItem ElementsUsing the Text propertyUsing the Value propertyDetermining which items are selectedUsing the Collection Editor dialog boxToiling with the RadioButtonList ControlUtilizing ListBox ControlsEmploying DropDownList ControlsAccomplishing More with List Items in CodeAdding an item to a listClearing the listSelecting and deselecting itemsFinding an item
4. Using Advanced Web Server Controls
Using the MultiView ControlUtilizing the Wizard ControlCreating steps in Visual StudioUsing Wizard eventsLooking at the code for a Wizard controlWorking with the Calendar ControlMaking Use of the FileUpload Control
5. Working with User Controls
Introducing User ControlsCreating a User ControlAdding a User Control to a PageAdding Properties to a User ControlPutting User-Control Properties to Work
III. HTML
1. HTML Basics
XHTML Rulez!XHTML and the W3CThe strict upbringing of XHTMLMaking your HTML well-formedMore XHTML requirementsTaking characters as an entityVWDE’s Support for XHTMLA solemn DOCTYPE declarationValidity spyLetting VWDE fix old codeFixing a missing attributeCrossing the great div(ide)Slashing squiggly linesMagical chorded keystrokesYou can go your own wayEditing Code in Source ViewPreserving source codeCleaning up source codeUsing the Tag NavigatorCollapsing and outliningNo Comment!Editing Pages in Design ViewEstablishing a position in Design viewPositioning a Single ControlViewing an HTML document’s structureManipulating the DOMFormatting TextThe Formatting toolbarThe Format menuProperties pages
2. Creating Tables
Some Basic Table TalkAdding headers, a caption, and a summaryGrouping and spanning columns and rowsCreating Tables in the DesignersThe Toolbox tableThe table designerThe ASP.NET table toolCreating Tables ProgrammaticallyBuilding a table by using the Repeater controlBuilding an ASP.NET table from scratchCreating a Table-Based Framework
3. Working with Forms
Understanding FormsCreating a FormA call to action — sent by postStaying on targetYour special events formWorking with Text BoxesCreating text fields with <input>Creating a password text boxSuper-sizing a text fieldWorking with ButtonsCreating a submit buttonCreating a reset buttonCreating an ordinary buttonCreating an image buttonCreating submit, reset, and ordinary buttons another wayWorking with Check Boxes and Radio ButtonsCreating a check boxCreating a radio buttonUsing Drop-Down Lists and List BoxesCreating a drop-down listCreating a list boxCreating a hierarchical drop-down list and list boxChecking Form Submissions with ASP.NETSetting the Tab Order
4. Using Styles and Style Sheets
Understanding StylesCascading Style SheetsWill that be inline, embedded, or external?In case of a dispute, the closest winsStyle selectors and other syntaxWorking with Styles in Visual Studio 2005 and Visual Web DeveloperSetting the CSS validation schemaCreating inline styles in Design viewCreating inline styles in Source viewBuilding external style sheetsCreating a class with styleUsing Span and Div for Styles and PositionsHighlighting text with <span>Creating a layer with <div>Showing and hiding the <div>Creating and Applying Styles in CodeApplying inline styles in codeInserting embedded styles with codeLetting users choose their style sheet
5. Using Client-Side Script
Sampling Client-Side Script on Microsoft.comCompensating for browser differencesEmbedding multimedia contentTracking page views and statisticsMaking the page interactiveCreating random content and surveysEmbedding Script in an ASP.NET PageEmbedding a block of scriptInserting a hidden field into a pageEmbedding code so that it executes on startupEmbedding code to catch a page submitCapturing the hidden fieldReferencing external scriptsStoring an array of values in a pageUsing Client-Side Scripts in ASP.NETIdentifying page elements by using scriptUsing alert() to stop users coldconfirm() a drastic actionCreating a rollover effectClient-Side Script and Validation ControlsHow Auto-Postback Uses Client-Side ScriptUsing Client-Side CallbacksCreating the Web page interfacePreparing the JavaScriptBuilding the server-side algorithmImplementing ICallbackEventHandlerGenerating the callback codeMaking the callback callCallback source code
IV. C#
1. C# Programming Basics
Dealing with KeywordsWorking with StatementsTypes of statementsWhite spaceWorking with BlocksCreating IdentifiersCrafting CommentsSingle-line commentsDelimited commentsIntroducing Object-Oriented ProgrammingUnderstanding classes and objectsCoding a classCreating an object from a classUsing .NET Framework ClassesDeclaring VariablesDeclaring two or more variables in one statementDeclaring instance variablesDeclaring local variablesInitializing VariablesInitializing variables with assignment statementsInitializing variables with initializersWorking with Built-in Data TypesInteger (int) typesFloating-point typesThe decimal typeThe char typeThe boolean typeWorking with StringsDeclaring and initializing stringsCombining stringsConverting strings to primitivesWorking with Arithmetic OperatorsDividing IntegersCombining OperatorsUsing the Unary Plus and Minus OperatorsUsing Increment and Decrement OperatorsUsing the Assignment OperatorUsing Compound Assignment Operators
2. Doing Things Conditionally in C#
Using Simple boolean ExpressionsUsing if StatementsSimple if statementsif-else statementsNested if statementselse-if statementsMr. Spock’s Favorite Operators (the Logical Ones, of Course)Using the ! operatorUsing the & and && operatorsUsing the | and || operatorsPulling the Ol’ Switch-er-ooCreating else-if monstrositiesUsing the switch statementA better version of the Voter-Error-Code Decoder program
3. Going Around in Circles (Or, Looping in C#)
Your Basic while LoopThe while statementA counting loopBreaking Out of a LoopLooping ForeverUsing the continue StatementUnderstanding do-while LoopsThe Famous for LoopThe formal format of the for loopScoping out the counter-variableCounting even numbersCounting backwardfor loops without bodiesGanging up your expressionsOmitting expressionsBreaking and continuing your for loopsNesting Your Loops
4. Using Methods and Exceptions
The Basics of Making MethodsA Simple ExampleMethods that Return ValuesDeclaring the method’s return typeUsing the return statement to return the valueUsing Methods that Take ParametersDeclaring parametersUnderstanding pass-by-valueUnderstanding ExceptionsCatching ExceptionsCatching Different Exception TypesUsing the Exception MessageUsing a finally Block
5. Getting into Object-Oriented Programming
What Is Object-Oriented Programming?Understanding ObjectsObjects have identityObjects have typeObjects have stateObjects have behaviorThe Life Cycle of an ObjectWorking with Related ClassesInheritanceInterfacesDeclaring a ClassPicking class namesWhat goes in the class bodyUsing FieldsCreating PropertiesUsing MethodsCreating ConstructorsBasic constructorsDefault constructorsUsing thisWorking with Static MembersWorking with static fields or propertiesUsing static methods
6. Working with Inheritance
Understanding InheritanceA real-world explanationA fun explanationA business-world explanationInheritance hierarchiesCreating Derived ClassesOverriding MethodsProtecting Your MembersUsing this and base in Your Derived ClassesInheritance and ConstructorsCasting Up and DownDetermining an Object’s Type: The is OperatorPoly What?
V. Visual Basic
1. Mastering the Basics of Visual Basic
Looking at Classes, Structures, and ModulesWorking with Source FilesCreating Sub ProceduresWorking with StatementsCreating IdentifiersAdding Comments to Your CodeDeclaring VariablesWorking with Data TypesInteger typesFloating-point typesThe decimal typeThe char typeThe Boolean typeWorking with StringsDeclaring and initializing stringsCombining stringsConverting stringsWorking with Arithmetic OperatorsCombining OperatorsUsing Assignment StatementsUsing Assignment Operators
2. Controlling Your Programs
Using If StatementsThe basic If statementThe single-line IfThe Else clauseNesting If statementsThe ElseIf structureUsing Conditional ExpressionsGetting LogicalUsing the Not operatorWorking with the And operatorUtilizing the AndAlso operatorUsing the Or and OrElse operatorsUsing the Select Case StatementWorking with For/Next LoopsUsing While loopsUtilizing Do loopsExiting a loopNesting your loops
3. Working With Procedures, Exceptions, and Arrays
Using Sub ProceduresWorking with FunctionsGetting Finicky about ParametersUnderstanding ExceptionsCatching exceptionsUsing a Finally blockUsing ArraysCreating an arrayInitializing an arrayUsing For loops with arraysUsing two-dimensional arrays
4. Exploring Object-Oriented Programming
Introducing Object-Oriented ProgrammingObjects have identityObjects have typeObjects have stateObjects have behaviorCreating Objects from ClassesDeclaring ClassesUsing fieldsCreating propertiesUsing methodsCreating constructorsUsing Shared Members
5. Demystifying Inheritance in VB.NET
Understanding InheritanceUnderstanding Inheritance HierarchiesCreating a Derived ClassOverriding MethodsUsing Protected MembersUsing the MyBase KeywordUsing Casting with InheritanceDetermining an Object’s TypeConfronting Polymorphism
VI. Database Programming
1. Accessing Data with ADO.NET
Understanding the Basics of Relational DatabasesGathering data into tablesOrganizing with rows and columnsDistinguishing data with primary keys and foreign keysUnderstanding the primary keyUtilizing the foreign keyIndexing your data for fast retrievalWorking with Databases Using SQLCreating a table with CREATE TABLESpecifying a primary keyImplementing a foreign keyCreating an index with CREATE INDEXDeleting a table with DROP TABLEGetting data with SELECTSelecting only specific rows with the WHERE clauseAdding data with INSERTModifying data with UPDATERemoving data with DELETEPiecing Together SQL StatementsConnecting to Data with ADO.NETIssuing Database CommandsCalling statements that return no dataCalling a stored procedureCalling statements that return one data itemDisplaying Data on a Web PageRetrieving Data from a TableAdding Security to Your SQL Statements — Read This!
2. Displaying and Editing Data for the Web
Writing Data to a Page with a LabelBinding to DataCreating a data sourceUsing a data sourceRepeating Through a Result SetSetting server control properties in a Repeater controlAdding some style to the Repeater controlAltering the look of the Repeater control’s rowsCreating a Data-Entry Page
3. Displaying and Editing with the GridView Control
Setting Up the AdventureWorks DatabaseCreating a GridView ControlFormatting the DisplayEditing and Deleting Data with a GridViewSorting and Paging the Data in Your GridCustomizing the Columns in a GridSpecifying headersDisplaying formatted text with the BoundField typeDisplaying images from a URL with the ImageField type
4. Displaying and Editing Detail Data
Introducing the DetailsView and FormView ControlsDisplaying a Record with a DetailsView ControlMoving through data by pagingUsing GridView and DetailsView controls togetherEditing Data with a DetailsViewSearching and displaying detailsDisplaying Record Details with a FormView ControlUsing GridView and FormView controls togetherEditing data with a FormView
5. Advanced Data Retrieval
Ditching the Eval MethodBinding to Different Kinds of DataSkipping the SQLDataSourceBinding SqlDataAdapter results to controlsAttaching arrays to data-bound controlsAdvanced Usage of Repeater ControlsCreating a table around a RepeaterHandling Repeater events
6. Reading XML and Generic Data
Putting Together Some XMLTransforming XML into a Formatted TableDisplaying XML in a TreeView ControlAccessing Generic Data with an ObjectDataSource Control
VII. Using the .NET Framework
1. Handling Strings
Formatting StringsSupplying parameters other than stringsFormatting the numeric parametersFormatting dates and timesCustomizing data formatsHandling Special HTML Characters in StringsSplitting and Combining StringsSplitting stringsCombining stringsConverting to Strings with the ToString MethodConverting Strings to NumbersPiecing Together Strings with a StringBuilder
2. Manipulating Dates and Times
Getting the Current Date and TimeReading the Components of a DateTime StructureStreaming a DateTime StructureHandling Local Times Versus Universal TimesCalculating with DatesParsing a Date-Time String
3. Storing Objects in Specialized Collections
Iterating Through a CollectionUsing the ArrayList ClassSorting a listComparing different typesUsing the Hashtable ClassUsing the Stack ClassUsing the Queue ClassCollecting StringsUsing the StringCollection classUsing the StringDictionary classOrdering Associations with the OrderedDictionary
4. Building Strongly Typed Collections with Generic Classes
Understanding the Name GameUsing the Generic List ClassWorking with the Generic LinkedList ClassEmploying the Generic Dictionary ClassUsing the Generic SortedDictionary ClassUsing the Generic Stack ClassWorking with the Generic Queue Class
VIII. Advanced ASP.NET Programming
1. Security: Using Login Controls
Understanding Authentication and AuthorizationImplementing Forms AuthenticationCreating the Web siteAdding pages to the resto Web siteImplementing membership featuresCreating usersCreating access rules for the pagesAllowing anonymous users access to the rootDenying access for all usersAllowing access to one user — John OliverReviewing the access rulesUsing the Login controlAdding the Login control to the pageTesting the Login controlUsing the LoginName controlUsing the LoginStatus controlUsing the LoginView controlUsing the PasswordRecovery controlConfiguring the SMTP settingsAdding the PasswordRecovery control to a pageTesting the password recovery featureUsing the ChangePassword controlAssigning users to rolesGiving permissions to a rolePeering into the Application Programming Interface (API)Using the Membership and MembershipUser classesAdding members programmaticallyDeleting members programmaticallyUpdating members programmaticallyDisplaying all members programmaticallyUsing the Roles classAdding a role programmaticallyDeleting a role programmaticallyAdding users to a role programmaticallyListing all roles
2. Using Profiles
Understanding ProfilesEnabling Anonymous User ProfilesDeciding what data to storeEnabling profiles in the configuration fileGenerating the databaseExploring the profile databaseBuilding the Profile-Based Web PageAdding control markup to the pageAdding code to retrieve profile valuesDisplaying the date and time in the chosen languageStoring the language choice in the profileStoring the image choice in the profileStoring the background color in the profileTesting the profile propertiesUsing Profiles with Authenticated UsersViewing the list of profilesMaintaining the Profiles DatabaseDeleting inactive profilesDeleting a specific profileUsing a Custom Profile ProviderObtaining the Access providerBuilding the Access providerInstalling the starter kitCreating the Visual C# projectCompiling the Dynamic Link Library (DLL)Configuring the Web for the Access providerCreating a test page for the Access provider
3. Site Navigation
Understanding Site NavigationUsing a Web.sitemap FileCreating the Web.sitemap fileAdding data to the sitemap fileUsing the SiteMapDataSource controlUsing the TreeView ControlCreating a TreeView in Design viewAdding nodes in Design viewSetting TreeView styles in Design viewCreating a TreeView programmaticallyCreating a TreeNodeDefining the TreeViewDefining the Root nodeDefining the child nodes of the Root nodeAdding individual Leaf nodesAdding styles to nodesCreating a TreeView from a sitemapUsing the Menu ControlCreating a Menu in Design viewAdding items in Design viewSetting Menu styles in Design viewCreating a Menu programmaticallyCreating Menu itemsBuilding the base MenuBuilding the static itemsAdding child itemsConfiguring item stylesCreating a Menu from a sitemapUsing the SiteMapPath ControlCreating a SiteMapPath in Design viewCreating a SiteMapPath control programmaticallyBuilding the SiteMapPathAdding style to the SiteMapPathUsing an image as a path separator
4. Working with Themes
Understanding Site ThemesCreating an Opening ThemeAdding the App_Themes folderAdding a .skin fileCreating rough skinRefining the skin propertiesTesting the skinLetting Users Choose a ThemeThe Normal themeThe Accountant themeA theme for lawyersApplying a Theme ProgrammaticallyStoring the Theme in a ProfileDos and Don’ts for ThemesShifting Definitions to StylesOverriding Themes and Who’s the BossTheme vs StyleSheetThemeImplementing a global themeExempting a page from themingExempting a control from themingWhere to Get Themes
5. Building Portals with Web Parts
Understanding PortalsAn Example Web PortalSecurity for your custom pagePersonalization of your pageChoice of languageChoice of contentCustom layoutShow and hide contentThemesUnderstanding the Parts of Web PartsWeb parts infrastructure elementsPersonalization, logins, and Web partsCreating a Simple Web PartFaking a login for development purposesCreate a page and Web-part zonesAdd some Web-part contentTest the Web-part pageOops, I closed the Web part and it’s gone!Letting the User Move Web Parts AroundAdding code to support Web-part Design modePlaying with Web-part Design modeConnecting Web Parts TogetherCreating a data consumer Web partCreating a data provider Web partCreating a connectable data providerCreating a data exchange interfaceGetting Web parts on the same pageSetting up the pageAdding Web-part zones to the pageAdding Web parts to the zonesAdding a static connectionAdding visual appeal to the Web partTesting the connectionConnecting Web Parts DynamicallyWeb parts à la modeCreating a mode selectorAdding a ConnectionsZone interfaceMaking connectionsBreaking connectionsUsing the Editor ControlsAdding EditorZone and AppearanceEditorPart controlsChanging a Web part’s appearanceUsing other editor partsLetting Users Select Their Web PartsAdding CatalogZone and DeclarativeCatalogPart controlsSelecting a part from the catalog
6. Creating and Consuming Web Services
Understanding Web ServicesA supercomputer scenarioA super solutionThe black boxExposing an APINot just HTTPExpanding demandsIt can be doneCreating a Web ServiceAdd a Web service to your projectAnalyze this!Replace the default namespaceAdd the RomanNumerals functionA quick test of the Web serviceOther valuable informationProviding information to clientsConsuming a Web ServiceUsing the service in a Web page and projectSetting up the Web pageAdding the Web referenceConnecting the Web reference to the pageTrying the Web service from the pageUsing the service from Windows FormsUsing the service from VBScriptPick a platformServing a Larger Helping of DataPreparing the RockHits Web serviceCreating some dataMaking a Web serviceConsuming the DataSetSecuring a Web Service
ASP.NET 2.0 All-in-One Desk Reference For Dummies®
Standard ControlsPage DirectivesMaster Page ControlsValidation ControlsData Source ControlsData ControlsNavigation ControlsLogin Controls

Content preview from ASP.NET 2.0 All-In-One Desk Reference For Dummies®

Chapter 1. Accessing Data with ADO.NET

In This Chapter

✓	Relating to the basics of relational databases
✓	Using databases using SQL
✓	Manipulating your databases with SQL
✓	Issuing database commands with a .NET application
✓	Displaying data on a Web page
✓	Adding security to your SQL statements

If you’re creating software to run on the Web, chances are good that you’re also going to have to store data in a database. Thereby hangs a tale: Long before Microsoft’s .NET technology, Microsoft gave us the ADO (which originally stood for ActiveX Data Objects, although today the controls have little to do with ActiveX). The original ADO objects were controls you could use in programs built with Visual Basic 6.0 (or even C++); they provided easy access to your data.

Today, Microsoft has given us ADO.NET, the .NET version of data-access controls. Now, with the second version of .NET, we have ADO.NET 2.0.

ADO.NET 2.0 is a set of classes that you can use in your .NET programs. These classes allow you to access data stored in various places such as in SqlServer. But these classes do more than just access data. They are high-performance classes that Microsoft built with the Web in mind. If you have a high-volume Web server, you want to make sure that your data access is fast and efficient, and that the server won’t be brought to its knees trying to access too much data for too many users. Microsoft built the ADO.NET classes to conserve resources. When a Web session accesses the data using ADO.NET, the classes ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780471785989Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

ASP.NET 2.0 All-In-One Desk Reference For Dummies®

by Doug Lowe, Jeff Cogswell, Ken Cox - Microsoft MVP

Chapter 1. Accessing Data with ADO.NET

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.