book

ASP.NET 2.0 Unleashed

by Stephen Walther

June 2006

Intermediate to advanced

1992 pages

36h 23m

English

Sams

Read now

Unlock full access

Dedication
Who Should Read This Book?What Do You Need to Know Before You Read This Book?Changes to This BookHow This Book Is OrganizedViewing the Code Samples
ASP.NET and the .NET FrameworkUnderstanding the Framework Class LibraryUnderstanding NamespacesUnderstanding AssembliesUnderstanding the Common Language RuntimeUnderstanding ASP.NET ControlsOverview of ASP.NET ControlsUnderstanding HTML ControlsUnderstanding and Handling Control EventsUnderstanding View StateUnderstanding ASP.NET PagesUnderstanding Dynamic CompilationUnderstanding Control TreesUsing Code-Behind PagesHow Code-Behind Works: The Ugly DetailsDeciding Between Single-File and Code-Behind PagesHandling Page EventsUsing the Page.IsPostBack PropertyDebugging and Tracing ASP.NET PagesDebugging ASP.NET PagesDebugging Pages with Visual Web DeveloperTracing Page ExecutionInstalling the ASP.NET FrameworkSummary
Displaying InformationUsing the Label ControlUsing the Literal ControlAccepting User InputUsing the TextBox ControlUsing the CheckBox ControlUsing the RadioButton ControlSubmitting Form DataUsing the Button ControlUsing the LinkButton ControlUsing the ImageButton ControlUsing Client Scripts with Button ControlsPerforming Cross-Page PostsSpecifying a Default ButtonHandling the Command EventDisplaying ImagesUsing the Image ControlUsing the ImageMap ControlUsing the Panel ControlUsing the HyperLink ControlSummary
Overview of the Validation ControlsValidation Controls and JavaScriptUsing Page.IsValidSetting the Display PropertyHighlighting Validation ErrorsUsing Validation GroupsDisabling ValidationUsing the RequiredFieldValidator ControlUsing the RangeValidator ControlUsing the CompareValidator ControlUsing the RegularExpressionValidator ControlUsing the CustomValidator ControlUsing the ValidationSummary ControlCreating Custom Validation ControlsCreating a LengthValidator ControlCreating an AjaxValidator ControlSummary
Accepting File UploadsSaving Files to the File SystemSaving Files to a DatabaseUploading Large FilesDisplaying a CalendarCreating a Pop-up Date PickerRendering a Calendar from a Database TableDisplaying AdvertisementsStoring Advertisements in an XML FileStoring Advertisements in a Database TableTracking Impressions and TransfersDisplaying Different Page ViewsDisplaying a Tabbed Page ViewDisplaying a Multi-Part FormDisplaying a WizardSummary

Creating Master PagesCreating Default ContentNesting Master PagesUsing Images and Hyperlinks in Master PagesRegistering Master Pages in Web ConfigurationModifying Master Page ContentUsing the Title AttributeUsing the Page Header PropertyExposing Master Page PropertiesUsing FindControl with Master PagesLoading Master Pages DynamicallyLoading Master Pages Dynamically for Multiple Content PagesSummary
Creating ThemesAdding Skins to ThemesCreating Named SkinsThemes versus StyleSheetThemesDisabling ThemesRegistering Themes in the Web Configuration FileAdding Cascading Style Sheets to ThemesAdding Multiple Cascading Style Sheets to a ThemeChanging Page Layouts with Cascading Style SheetsCreating Global ThemesApplying Themes DynamicallyApplying Skins DynamicallySummary
Creating User ControlsRegistering User Controls in the Web Configuration FileExposing Properties from a User ControlExposing Events from a User ControlCreating an AddressForm ControlAJAX and User ControlsDynamically Loading User ControlsUsing the Reference DirectiveCreating a Multi-Page WizardSummary
Using DataBound ControlsWorking with List ControlsWorking with Tabular DataBound ControlsWorking with Hierarchical DataBound ControlsWorking with Other ControlsUsing DataSource ControlsUsing ASP.NET Parameters with DataSource ControlsUsing Programmatic DataBindingUnderstanding Templates and DataBinding ExpressionsUsing TemplatesUsing DataBinding ExpressionsUsing Two-Way DataBinding ExpressionsOverview of SQL Server 2005 ExpressFeatures of SQL Server ExpressSQL Server 2005 Express Management ToolsServer Databases versus Local DatabasesSample Database-Driven Web ApplicationSummary
Creating Database ConnectionsConnecting to Microsoft SQL ServerConnecting to Other DatabasesStoring Connection Strings in the Web Configuration FileEncrypting Connection StringsExecuting Database CommandsExecuting Inline SQL StatementsExecuting Stored ProceduresFiltering Database RowsChanging the Data Source ModeHandling SQL Command Execution ErrorsCanceling Command ExecutionUsing ASP.NET Parameters with the SqlDataSource ControlUsing the ASP.NET Parameter ObjectUsing the ASP.NET ControlParameter ObjectUsing the ASP.NET CookieParameter ObjectUsing the ASP.NET FormParameter ObjectUsing the ASP.NET ProfileParameter ObjectUsing the QueryStringParameter ObjectUsing the SessionParameter ObjectProgrammatically Executing SqlDataSource CommandsAdding ADO.NET ParametersExecuting Insert, Update, and Delete CommandsExecuting Select CommandsCaching Database Data with the SqlDataSource ControlSummary
Overview of the List ControlsDeclaring List ItemsBinding to a Data SourceDetermining the Selected List ItemAppending Data ItemsEnabling Automatic PostBacksUsing the Items CollectionWorking with the DropDownList ControlWorking with the RadioButtonList ControlWorking with the ListBox ControlWorking with the CheckBoxList ControlWorking with the BulletedList ControlCreating a Custom List ControlSummary
GridView Control FundamentalsDisplaying DataSelecting DataUsing Data KeysSorting DataSorting with AJAXCustomizing the Sorting InterfacePaging Through DataPaging with AJAXCustomizing the Paging InterfaceEditing DataHandling Concurrency IssuesDisplaying Empty DataFormatting the GridView ControlUsing View State with the GridView ControlUsing Fields with the GridView ControlUsing BoundFieldsUsing CheckBoxFieldsUsing CommandFieldsUsing Button FieldsUsing HyperLinkFieldUsing ImageFieldUsing TemplateFieldWorking with GridView Control EventsHighlighting GridView RowsDisplaying Column SummariesDisplaying Nested Master/Details FormsExtending the GridView ControlCreating a Long Text FieldCreating a Delete Button FieldCreating a Validated FieldSummary
Using the DetailsView ControlDisplaying Data with the DetailsView ControlUsing Fields with the DetailsView ControlDisplaying Empty Data with the DetailsView ControlPaging through Data with the DetailsView ControlPaging with AJAXCustomizing the Paging InterfaceUpdating Data with the DetailsView ControlUsing Templates when EditingHandling Concurrency IssuesInserting Data with the DetailsView ControlDeleting Data with the DetailsView ControlWorking with DetailsView Control EventsFormatting the DetailsView ControlUsing the FormView ControlDisplaying Data with the FormView ControlPaging Through Data with the FormView ControlEditing Data with the FormView ControlInserting Data with the FormView ControlDeleting Data with the FormView ControlSummary
Using the Repeater ControlDisplaying Data with the Repeater ControlUsing Templates with the Repeater ControlHandling Repeater Control EventsUsing the DataList ControlDisplaying Data with the DataList ControlDisplaying Data in Multiple ColumnsUsing Templates with the DataList ControlSelecting Data with the DataList ControlEditing Data with the DataList ControlFormatting the DataList ControlSummary
Building Basic ComponentsComponents and Dynamic CompilationMixing Different Language Components in the App_Code FolderDeclaring MethodsDeclaring Fields and PropertiesDeclaring ConstructorsOverloading Methods and ConstructorsDeclaring NamespacesCreating Partial ClassesInheritance and MustInherit ClassesDeclaring InterfacesUsing Access ModifiersIntellisense and ComponentsUsing ASP.NET Intrinsics in a ComponentBuilding Component LibrariesCompiling Component LibrariesUsing the Visual Basic .NET Command-Line CompilerUsing Visual Basic .NET ExpressUsing Visual Studio .NET 2005Adding a Reference to a Class LibraryAdding an Assembly to the Bin FolderAdding an Assembly to the Global Assembly CacheArchitectural ConsiderationsBuilding Multi-tier ApplicationsCreating the User Interface LayerCreating the Business Logic LayerCreating the Data Access LayerSummary
Representing Objects with the ObjectDataSource ControlBinding to a ComponentBinding to a DataReaderBinding to a DataSetBinding to a Web ServiceUsing Parameters with the ObjectDataSource ControlUsing Different Parameter TypesPassing Objects as ParametersPaging, Sorting, and Filtering Data with the ObjectDataSource ControlUser Interface PagingData Source PagingUser Interface SortingData Source SortingFiltering DataHandling ObjectDataSource Control EventsAdding and Modifying ParametersHandling Method ErrorsHandling the ObjectCreating EventConcurrency and the ObjectDataSource ControlExtending the ObjectDataSource ControlCreating a Custom ObjectDataSource ControlCreating Custom Parameter ObjectsCreating a Username ParameterCreating a Page Property ParameterSummary
Connected Data AccessUsing the Connection ObjectRetrieving Provider StatisticsImproving Performance with Connection PoolingUsing the Command ObjectExecuting a CommandExecuting a Command with ParametersExecuting a Command That Represents a Stored ProcedureReturning a Single ValueReturning a ResultsetUsing the DataReader ObjectReturning Multiple ResultsetsWorking with Multiple Active ResultsetsDisconnected Data AccessUsing the DataAdapter ObjectPerforming Batch UpdatesUsing the DataTable ObjectSelecting DataRowsDataRow States and DataRow VersionsUsing the DataView ObjectUsing the DataSet ObjectExecuting Asynchronous Database CommandsUsing Asynchronous ADO.NET MethodsUsing Asynchronous ASP.NET PagesBuilding Database Objects with the .NET FrameworkEnabling CLR IntegrationCreating User-Defined Types with the .NET FrameworkCreating the User-Defined Type AssemblyRegistering the User-Defined Type Assembly with SQL ServerCreating the User-Defined TypeBuilding a Data Access Layer with a User-Defined TypeCreating Stored Procedures with the .NET FrameworkCreating the Stored Procedure AssemblyRegistering the Stored Procedure Assembly with SQL ServerCreating the Stored ProceduresExecuting a .NET Stored Procedure from an ASP.NET PageSummary
Understanding Site MapsUsing the SiteMapPath ControlFormatting the SiteMapPath ControlUsing the Menu ControlDeclaratively Adding Menu ItemsUsing the Menu Control with the MultiView ControlBinding to a Site MapBinding to an XML FileBinding to Database DataFormatting the Menu ControlUsing Templates with the Menu ControlUsing the TreeView ControlDeclaratively Adding Tree NodesDisplaying Check Boxes with the TreeView ControlBinding to a Site MapBinding to an XML FileBinding to Database DataUsing Populate On Demand and AJAXFormatting the TreeView ControlBuilding a SQL Hierarchical Data Source ControlSummary
Using the SiteMapDataSource ControlSetting SiteMapDataSource PropertiesUsing the SiteMap ClassUsing the SiteMapNode ClassAdvanced Site Map ConfigurationUsing Security TrimmingMerging Multiple Site MapsCreating Custom Site Map AttributesCreating Custom Site Map ProvidersCreating the AutoSiteMapProviderCreating the SqlSiteMapProviderGenerating a Google SiteMap FileSummary
Remapping URLsCreating a Custom UrlRemapper ModuleUsing the VirtualPathProvider ClassLimitations of the VirtualPathProvider ClassUnderstanding the VirtualPathProvider ClassRegistering a VirtualPathProvider ClassStoring a Website in Microsoft SQL ServerSummary
Overview of the Login ControlsUsing the Login ControlAutomatically Redirecting a User to the Referring PageAutomatically Hiding the Login Control from Authenticated UsersUsing a Template with the Login ControlPerforming Custom Authentication with the Login ControlUsing the CreateUserWizard ControlConfiguring Create User Form FieldsSending a Create User Email MessageAutomatically Redirecting a User to the Referring PageAutomatically Generating a PasswordUsing Templates with the CreateUserWizard ControlAdding Steps to the CreateUserWizard ControlUsing the LoginStatus ControlUsing the LoginName ControlUsing the ChangePassword ControlSending a Change Password EmailUsing Templates with the ChangePassword ControlUsing the PasswordRecovery ControlSending the Original PasswordRequiring a Security Question and AnswerUsing Templates with the PasswordRecovery ControlUsing the LoginView ControlUsing Roles with the LoginView ControlSummary
Configuring AuthenticationConfiguring Forms AuthenticationUsing Cookieless Forms AuthenticationUsing Sliding Expiration with Forms AuthenticationUsing Forms Authentication Across ApplicationsUsing Forms Authentication Across DomainsUsing the FormsAuthentication ClassUsing the User ClassConfiguring AuthorizationAuthorizing by RoleAuthorizing Files by LocationUsing Authorization with Images and Other File TypesUsing Authorization with ASP Classic PagesUsing ASP.NET MembershipUsing the Membership Application Programming InterfaceEncrypting and Hashing User PasswordsModifying User Password RequirementsLocking Out Bad UsersConfiguring the SQLMembershipProviderConfiguring the ActiveDirectoryMembershipProviderConfiguring ADAMConfiguring the ActiveDirectoryMembershipProviderCreating a Custom Membership ProviderUsing the Role ManagerConfiguring the SqlRoleProviderUsing a Different Database with the SqlRoleProviderConfiguring the WindowsTokenRoleProviderConfiguring the AuthorizationStoreRoleProviderCaching Roles in a Browser CookieUsing the Roles Application Programming InterfaceSummary
Using Browser CookiesCookie Security RestrictionsCreating CookiesReading CookiesSetting Cookie PropertiesDeleting CookiesWorking with Multi-Valued CookiesUsing Session StateStoring Database Data in Session StateUsing the Session ObjectHandling Session EventsControlling When a Session Times OutUsing Cookieless Session StateConfiguring a Session State StoreConfiguring State Server Session StateConfiguring SQL Server Session StateUsing ProfilesCreating Profile GroupsSupporting Anonymous UsersMigrating Anonymous ProfilesInheriting a Profile from a Custom ClassCreating Complex Profile PropertiesSaving Profiles AutomaticallyAccessing Profiles from ComponentsUsing the Profile ManagerConfiguring the Profile ProviderCreating a Custom Profile ProviderSummary
Overview of CachingUsing Page Output CachingVarying the Output Cache by ParameterVarying the Output Cache by ControlVarying the Output Cache by HeaderVarying the Output Cache by BrowserVarying the Output Cache by a Custom FunctionSpecifying the Cache LocationCreating a Page Output Cache File DependencyExpiring the Page Output Cache ProgrammaticallyManipulating the Page Output Cache ProgrammaticallyCreating Page Output Cache ProfilesUsing Partial Page CachingUsing Post-Cache SubstitutionCaching with a User ControlSharing a User Control Output CacheManipulating a User Control Cache ProgrammaticallyCreating a User Control Cache File DependencyCaching Dynamically Loaded User ControlsUsing DataSource CachingUsing an Absolute Cache Expiration PolicyUsing a Sliding Cache Expiration PolicyCaching with the ObjectDataSource ControlCaching with the XmlDataSource ControlCreating a DataSource Control Key DependencyUsing Data CachingUsing the Cache Application Programming InterfaceAdding Items to the CacheAdding Items with an Absolute Expiration PolicyAdding Items with a Sliding Expiration PolicyAdding Items with DependenciesSpecifying Cache Item PrioritiesConfiguring the CacheUsing SQL Cache DependenciesUsing Polling SQL Cache DependenciesConfiguring Polling SQL Cache DependenciesConfiguring a Database for Polling SQL Cache DependenciesConfiguring an Application for Polling SQL Cache DependenciesUsing Polling SQL Cache Dependencies with Page Output CachingUsing Polling SQL Cache Dependencies with DataSource CachingUsing Polling SQL Cache Dependencies with Data CachingUsing Push SQL Cache DependenciesConfiguring Push SQL Cache DependenciesConfiguring a Database for Push SQL Cache DependenciesConfiguring an Application for Push SQL Cache DependenciesUsing Push SQL Cache Dependencies with Page Output CachingUsing Push SQL Cache Dependencies with DataSource CachingUsing Push SQL Cache Dependencies with Data CachingSummary
Setting the Current CultureSetting a Culture ManuallyAutomatically Detecting a CultureSetting the Culture in the Web Configuration FileCulture and ASP.NET ControlsUsing the CultureInfo ClassUsing the CultureInfo Class to Format String ValuesComparing and Sorting String ValuesCreating Local ResourcesExplicit Localization ExpressionsImplicit Localization ExpressionsUsing Local Resources with Page PropertiesRetrieving Local Resources ProgrammaticallyCreating Global ResourcesRetrieving Global Resources ProgrammaticallyUsing Strongly Typed Localization ExpressionsUsing the Localize ControlSummary
Creating a Custom BuildProviderCreating a Simple BuildProviderCreating a Data Access Component BuildProviderCreating a Custom ExpressionBuilderCreating a Lookup ExpressionBuilderCreating HTTP HandlersCreating a Generic HandlerImplementing the IHttpHandler InterfaceRegistering Extensions with Internet Information ServerCreating an Asynchronous HTTP HandlerWorking with HTTP Applications and HTTP ModulesCreating a Global.asax FileCreating Custom HTTP ModulesSummary
Overview of Website ConfigurationUsing the Web Site Administration ToolUsing the ASP.NET Microsoft Management Console Snap-InASP.NET Configuration SectionsApplying Configuration Settings to a Particular PathLocking Configuration SettingsAdding Custom Application SettingsPlacing Configuration Settings in an External FileUsing the Configuration APIReading Configuration Sections from the Current ApplicationOpening a Configuration FileOpening a Configuration File on a Remote ServerUsing the Configuration ClassModifying Configuration SectionsProvisioning a New WebsiteCreating Custom Configuration SectionsCreating a Configuration Element CollectionCreating Encrypted Configuration SectionsEncrypting Sections with the aspnet_regiis toolEncrypting Sections ProgrammaticallyDeploying Encrypted Web Configuration FilesSummary
Overview of the Web Part FrameworkWeb Part ZonesWeb Part Display ModesWeb Part PersonalizationCreating a Simple Web Part ApplicationUsing Catalog ZonesUsing a Declarative Catalog PartUsing a Page Catalog PartUsing the Import Catalog PartUsing Editor ZonesUsing the Appearance Editor PartUsing the Behavior Editor PartUsing the Layout Editor PartUsing the Property Grid EditorUsing Connections ZonesConnecting Web PartsConnecting Simple Web PartsConnecting Databound Web PartsDynamically Connecting Web PartsUsing Transformers with Connected Web PartsSummary
Creating Simple Web PartsThe Hello World Web PartStandard Web Part PropertiesCreating a User Control Web Part Base ClassUsing Extended Web Part PropertiesFiltering Web PartsFiltering by Authorization FilterFiltering by User Control PathFiltering by Custom Control TypeCreating Custom Web Part VerbsCreating Server-Side VerbsCreating Client-Side VerbsCreating Zone VerbsDisplaying Web Part HelpManaging Web Parts with the WebPartManager ControlSummary
Overview of PersonalizationUsing the WebPartPersonalization ClassCreating a Personalization ManagerConfiguring PersonalizationConfiguring User and Shared Scope PersonalizationConfiguring the Personalization DatabaseCreating Personalizable Web PartsWorking with Complex Personalizable PropertiesUsing the IPersonalizable InterfaceAdministrating PersonalizationCreating Custom Personalization ProvidersBuilding a Query String Personalization ProviderBuilding an Anonymous Personalization ProviderSummary
Creating Custom Web Part ZonesHow Web Part Zones WorkCreating a Photo Web Part ZoneCreating a Multi-Column Web Part ZoneCreating a Menu Web Part ZoneCreating Custom Catalog ZonesHow Catalog Zones WorkCreating a Reflection Catalog PartCreating a Drag-and-Drop Catalog ZoneCreating a Templated Catalog ZoneCreating Custom Editor ZonesHow Editor Zones WorkCreating a Simple Custom Editor PartCreating a Templated Editor PartCreating Custom Web Part Display ModesSummary
Overview of Custom Control BuildingBuilding Fully Rendered ControlsUnderstanding the HtmlTextWriter ClassSpecifying the Containing WebControl TagBuilding Composite ControlsBuilding Hybrid ControlsView State and Control StateSupporting View StateSupporting Control StateProcessing Postback Data and EventsHandling Postback DataHandling Postback EventsPassing Postback Event ArgumentsUsing Postback OptionsWorking with Control Property CollectionsUsing the ParseChildren AttributeUsing the AddParsedSubObject() MethodUsing a ControlBuilderCreating a Better Designer ExperienceApplying Design-Time Attributes to a ControlCreating Control DesignersCreating a Container ControlDesignerAdding Smart TasksSummary
Using the ClientScriptManager ClassDetecting Browser CapabilitiesBuilding JavaScript ControlsBuilding a NewWindowLink ControlBuilding a WebWindow ControlBuilding a ClientTabs ControlBuilding AJAX ControlsImplementing AJAXBuilding a ServerTimeButton ControlBuilding an AJAX Combobox ControlSummary
Creating Templated ControlsImplementing the ITemplate InterfaceCreating a Default TemplateSupporting Simplified DatabindingSupporting Two-Way DatabindingCreating Templated Databound ControlsCreating a DivView ControlCreating an AjaxDivView ControlCreating an AjaxFormView ControlSummary
Overview of the E-Commerce ApplicationUsing Master Pages, Themes, and User ControlsBuilding a Component LibraryCreating a Custom Site Map ProviderCreating a Shopping CartProtecting Credit Card NumbersHandling ImagesRetrieving Data with AJAXImproving Performance Through CachingConforming to StandardsSummary

Content preview from ASP.NET 2.0 Unleashed

Chapter 9. Using the `SqlDataSource` Control

<feature><title>In this Chapter</title> <objective>

Creating Database Connections

</objective> <objective>

Executing Database Commands

</objective> <objective>

Using ASP.NET Parameters with the SqlDataSource Control

</objective> <objective>

Programmatically Executing SqlDataSource Commands

</objective> <objective>

Caching Database Data with the SqlDataSource Control

</objective> <objective>

Summary

</objective> </feature>

The SqlDataSource control enables you to quickly and easily represent a SQL database in a web page. In many cases, you can take advantage of the SqlDataSource control to write a database-driven web page without writing a single line of code.

You use the SqlDataSource control to represent a connection ...