Beginning ASP. NET 2. 0 Databases : Beta Preview

by John Kauffman; With: Thiru Thangarathinam

• ISBN13: 9780764570810
• ISBN10: 0764570811
• Format: Paperback
• Copyright: 2005-03-01
• Publisher: Wrox

Summary

What is this book about? With help from Microsoft ASP.NET insider Bradley Millington, John Kaufman covers both VB.NET and C# coding for ASP.NET databases so you don't have to decide up front which language you want more and retailers no longer have to manage inventory on separate language versions. What does this book cover? This edition is completely written from scratch on the ASP.NET "Whidbey" Beta to ensure the coverage is most appropriate for this greatly changed version. The book focuses on solving business problems in a logical progression, from connecting to displaying to changing the data. Additional chapters cover enhancements to the presentation and alternate types of data. The book follows the practice of going beyond the basic techniques to discuss the permutations, pitfalls, and best practices that occur in real business scenarios.

Author Biography

John Kauffman has written numerous books about ASP and the incorporation of data into ASP pages. Born in Philadelphia and educated at Penn State, he has lived, taught, and programmed on three continents as he follows his wife’s diplomatic assignments.
When not writing, he spends his time sailing, teaching electronics to high school groups, and chauffeuring his kids to hockey and music practices.

Table of Contents

Foreword	xvii
Introduction	xxi
Introduction to ASP.NET 2.0 and ADO.NET	1	(28)
Overview of the Technologies	2	(9)
Introduction to the .NET Framework	2	(2)
Introduction to ASP.NET	4	(1)
Introduction to ASP.NET 2.0	5	(2)
Introduction to ADO.NET	7	(1)
ASP.NET 2.0 and Data Access	8	(1)
Review of Terminology	9	(2)
Setup Requirements for This Book	11	(5)
Install a Web Server	12	(1)
Install the .NET Framework Version 2.0	12	(1)
Install an Editor to Create Web Pages	13	(1)
Visual Studio	13	(1)
Visual Web Developer Express	13	(1)
Notepad and Other Editors	14	(1)
Install a Database Management System	14	(1)
Microsoft Access	15	(1)
Microsoft SQL Server	15	(1)
Other Relational Databases	15	(1)
SQL Server Express	15	(1)
Setup	16	(2)
Install the Sample Databases	17	(1)
Demonstrations	18	(9)
Summary	27	(1)
Exercises	28	(1)
Connecting to an Access Database	29	(20)
Microsoft Access and the JET Database Engine	30	(1)
Connecting to a Microsoft Access Database in Visual Web Developer	30	(3)
The AccessDataSource Control	33	(8)
Variations in Select Statements	36	(4)
Variations in MDB File Location	40	(1)
Handling File Permissions	41	(1)
Handling Access Connection Failures	42	(3)
A Few Notes on Using Access in Web Applications	45	(1)
Common Mistakes with AccessDataSource Controls	46	(1)
Summary	47	(1)
Exercises	48	(1)
Connecting to SQL Server and SQL Server Express	49	(24)
Introduction to SQL Server and Connection Strings	50	(3)
Preparing to Use a SQL Server Database	51	(1)
Connection Strings	51	(2)
Using the SqlDataSource Control	53	(4)
Understanding Security in SQL Server	57	(2)
Storing the Connection String In the Web.Config File	59	(5)
Discovering the Structure of an Unfamiliar Database	64	(2)
Handling Connection Failures with the SqlDataSource	66	(3)
Common Mistakes	69	(1)
Summary	69	(2)
Exercises	71	(2)
Connecting to Other Relational Databases	73	(16)
Introduction to Connections with Providers	73	(5)
Relationship between Layers of Connectivity Software	74	(1)
Supported ADO.NET Providers	75	(1)
Using Providers in ASP.NET 2.0	76	(2)
Connecting to Access When a Password Is Used	78	(5)
Connecting to an MDB with a Security Scheme	79	(4)
Connecting to Oracle	83	(1)
Theory and Syntax	83	(1)
Connecting to MySQL	84	(2)
Theory of a Connection to MySQL	84	(1)
Syntax for an ODBC Connection to MySQL	84	(2)
Connecting to Other Databases	86	(1)
Common Mistakes	87	(1)
Summary	87	(1)
Exercises	88	(1)
Displaying Data in Tables	89	(28)
Displaying Data in ASP.NET 2.0	90	(1)
Review of Data-Bound and Data Source Controls	90	(1)
Types of Data-Bound Controls	90	(1)
Introduction to the GridView Control	91	(1)
Capabilities of the GridView Control	91	(1)
GridView Rendering Elements	92	(1)
Connecting a GridView to Data	92	(3)
Drag and Drop Fields from Data Explorer	93	(1)
Drag and Drop Controls from Toolbox	93	(2)
Customizing the GridView's Columns	95	(17)
Selecting Columns in the Edit Columns Dialog	95	(1)
Types of Column Fields	96	(1)
Bound Field	96	(1)
CheckBox Field	97	(2)
HyperLink Field	99	(3)
Image Field	102	(1)
Command Field	102	(2)
Button Field	104	(3)
Template Field	107	(3)
AutoGenerateColumns Property of the GridView	110	(1)
Handling Null Field Values	111	(1)
The DetailsView Control	112	(3)
DetailsView Rendering Elements	112	(1)
Connecting the DetailsView to Data	113	(2)
Common Mistakes	115	(1)
Summary	115	(2)
Customizing the Appearance of Tables	117	(26)
Customizing Appearance	118	(6)
BackColor and BackImageUrl	118	(1)
Font and ForeColor	119	(1)
Height and Width	119	(1)
CellSpacing and CellPadding	120	(1)
Borders and GridLines	120	(2)
HorizontalAlign	122	(1)
ShowHeader and ShowFooter	122	(1)
ToolTip	122	(2)
Customizing Individual Styles	124	(7)
GridView and DetailsView Styles	124	(2)
Empty Tables	126	(2)
DetailsView-Specific Styles	128	(1)
Column Styles and Field Styles	129	(2)
Using Cascading Style Sheets	131	(4)
Precedence of Styles	135	(3)
Themes and Skins	138	(2)
Using Auto Format in Visual Studio	140	(1)
Common Mistakes	140	(1)
Summary	141	(1)
Exercises	142	(1)
Paging and Sorting Data	143	(18)
Sorting	144	(7)
Requirements to Enable Sorting	145	(2)
Sort Expressions	147	(4)
Paging	151	(7)
Enabling Paging	152	(1)
Customizing Paging and the Pager	153	(5)
Paging Theory and Alternatives	158	(1)
Relationship of Sorting, Paging, and Selecting	158	(1)
Common Mistakes	159	(1)
Summary	160	(1)
Exercises	160	(1)
Displaying Data in Lists	161	(14)
Introduction	162	(1)
Transition from GridView to Other Formats	162	(1)
Types of List Controls	163	(1)
Concepts Common to List Controls	163	(2)
Text versus Value in List Items	164	(1)
Data-Binding List Controls	165	(2)
DataTextField and DataValueField	165	(2)
DropDownList Control	167	(2)
Handling Selection in a List	169	(4)
SelectedIndex and SelectedValue	169	(2)
Automatic Postback	171	(2)
Common Mistakes	173	(1)
Summary	174	(1)
Filtering and Master-Child Data	175	(30)
Filtering GridView Records Using a QueryString	177	(2)
Filtering GridView Records Using a TextBox	179	(2)
Using the SQL Like Operator	181	(1)
The Theory of Selection and ControlParameters	182	(2)
Filtering GridView Records Using a List Control	184	(7)
Master Control by DropDownList with Hard-Coded Items	184	(1)
Master Control by List Boxes with Data-Bound Items	185	(2)
Master Control by List Boxes with a Default Setting That Initially Hides the GridView	187	(4)
Displaying Details Using a GridView and DetailsView on the Same Page	191	(4)
Displaying Details Using a GridView and DetailsView on Different Pages	195	(5)
Cascading DropDownLists	200	(1)
Common Mistakes	201	(1)
Summary	201	(1)
Exercises	202	(3)
Displaying Data in Templated Controls	205	(24)
Using Templated Controls	209	(1)
Data Binding in Templates	209	(1)
Content Suitable for Addition to a Template	210	(1)
GridView and DetailsView Template Fields	211	(3)
DataList Control	214	(5)
Repeater Control	219	(1)
DetailsView Control	220	(1)
Navigation in Templated Controls	220	(1)
FormView Control	221	(2)
Comparing and Selecting the Templated Controls	223	(2)
Common Mistakes	225	(1)
Summary	226	(1)
Exercises	227	(2)
Updating and Deleting Data	229	(18)
Overview of Modifying	230	(1)
Command Fields	231	(2)
Simple Update	233	(3)
DataKeyNames and Updates	236	(2)
Update in a DetailsView	238	(1)
Parameters Collections	239	(1)
Handling NULLs In Updates	240	(2)
Delete to Remove Entire Records	242	(2)
Common Mistakes	244	(1)
Summary	245	(1)
Exercises	245	(2)
Inserting New Records	247	(20)
Support for Insert	248	(1)
What Happens under the Hood?	248	(1)
Setup for Insert	249	(1)
Insertion Mode	249	(1)
Action Performed by ASP.NET 2.0 on Insert	249	(1)
Database Considerations When Inserting	249	(1)
Basic Insert Using DetailsView	250	(2)
Enabling Insert in a Data Source Control	252	(2)
DetailsView INSERT Starting from GridView	254	(1)
GridView and DetailsView for Insert on Same Page	254	(1)
GridView on One Page with DetailsView on a Second Page	254	(1)
Insert Using Template Fields	255	(2)
Using the Bind Syntax in InsertltemTemplate	256	(1)
Data Entry with RadioButtonLists and DropDownLists	257	(3)
Data Entry with Check Boxes	260	(1)
Inserting with FormView	261	(4)
Common Mistakes	265	(1)
Summary	265	(2)
Business Objects as a Source of Data	267	(22)
Introduction	267	(2)
Layers of an N-Tier Application	268	(1)
Presentation Layer	268	(1)
Business Logic Layer	268	(1)
Data Access Layer	268	(1)
Advantages of N-Tier Architectures	269	(1)
Building a DataAccess Logic Layer Using VS DataSets	269	(4)
Creating a Data Access Logic Layer Using the VS DataSet Designer	269	(3)
Data-Binding to a DataSet	272	(1)
Implementing Master Details Capability	273	(4)
Implementing and Data-Binding to Custom Objects	277	(7)
Implementing Sorting in a Custom Object	284	(4)
Common Mistakes	288	(1)
Summary	288	(1)
XML and Other Hierarchical Data	289	(28)
What Is Hierarchical Data?	290	(1)
Types of Hierarchical Data	290	(1)
ASP.NET 2.0 Hierarchical Data Controls	290	(1)
XmlDataSource Control	291	(1)
TreeView Control to Display HierarchicalData	291	(3)
Display XML Data	294	(1)
XPath with XmlDataSource	294	(3)
Formatting the TreeView	297	(3)
XSL Transformation with XML	300	(3)
Handling Events in a TreeView Control	303	(2)
Hierarchical Data with Controls Other Than TreeView	305	(10)
XML and GridView	306	(2)
Use XML Source with DataList	308	(2)
Use XPath to Display Data in a DataList Control	310	(2)
XML and DataList with Nesting	312	(3)
Common Mistakes with XmlDataSource Controls	315	(1)
Summary	315	(2)
Caching Data	317	(22)
Caching and Its Benefits	317	(1)
When to Use Caching	318	(1)
Understanding State	319	(1)
Understanding State Stateness	319	(1)
Caching Options in ASP.NET 2.0	319	(18)
Displaying Data in ASP.NET	320	(3)
Time-Based Caching	323	(2)
Caching with Parameters	325	(2)
Implementing Filtering Capability	327	(3)
SQL Cache Invalidation	330	(4)
Caching Partial Pages	334	(3)
Common Mistakes	337	(1)
Summary	337	(2)
Handling Events for Data Controls	339	(24)
Execution Control When an Event Is Triggered	340	(1)
Types of Events	340	(1)
General Techniques for Writing Event Handlers	341	(9)
Transfer of Values When an Event Is Triggered	344	(1)
Object Sender	345	(1)
EventArgs	345	(1)
Location of Event Handlers	346	(4)
Command and Custom Button Events	350	(3)
Using Events Raised by Command Buttons (Command Fields)	351	(1)
Using Events Raised by Buttons with Custom Behavior	351	(2)
List Selection and Page Events	353	(3)
Data Control Binding Events	356	(2)
General Error Events	358	(3)
Common Mistakes	361	(1)
Summary	362	(1)
Exercises	362	(1)
Appendix A: A Short and Practical Introduction to SQL Statements	363	(12)
Appendix B: Exercise Answers	375	(16)
Index	391