Programming Data-Driven Web Applications with ASP.NET

by Mack, Donny; Seven, Doug

• ISBN13: 9780672321061
• ISBN10: 0672321068
• Edition: 1st
• Format: Paperback
• Copyright: 2001-09-20
• Publisher: Sams Publishing

Summary

Programming Data-Driven Web Applications with ASP.NETprovides readers with a solid understanding of ASP.NET and how to effectively integrate databases with their Web sites. The key to making information instantly available on the Web is integrating the Web site and the database to work as one piece. The authors teach this using ASP.NET, server-side controls, ADO+, XML, and SOAP. The authors will teach readers how to manage data by using ASP.NET forms, exposing data through ASP+ Web Services, working with BLOBs, and using cookies and other features to secure their data.

Author Biography

Programming Data-Driven Web Applications with ASP.NET Author Bio

Donny Mack, native of Washington State, is one of the co-founders of DotNetJunkies.com, the training company solely dedicated to ASP.NET and ADO.NET. DotNetJunkies.com is also a free online centralized resource Website used by .NET developers to feed their .NET passion. Prior to founding DotNetJunkies.com with Doug Seven, Mack worked at Microsoft Corporation as a Visual InterDev/ASP Support Professional. MackÕs need for bleeding edge technology is such that he spends his waking hours, (and some of his non-waking hours), writing code and developing content for DotNetJunkies.com. MackÕs real enjoyment comes from watching attendants of DotNetJunkies.comÕs training courses walk away as obsessed as he is with .NET.

Doug Seven, born and raised in Seattle, WA, is one of the co-founders of the .NET training company, DotNetJunkies.com. Doug comes to DotNetJunkies.com by way of technical roles _at Nordstrom, Microsoft, and GiftCertificates.com; and as a Training Specialist at Seattle Coffee Company. As the son of a programmer, Doug was destined to become a developer. Growing up around computers, his career began at the tender age of 11 writing "Choose Your Own Adventure" games in BASIC on a TRS-80, (unfortunately none of his groundbreaking work from this period survived). His first professional IT job was as a lead for the long-term data storage and disaster recovery group in a dual-IBM Mainframe environment at Nordstrom. After a seven-year sojourn as a rock star (seriously!) Doug took on the role of Technical Lead in MicrosoftÕs Developer Support group. After leaving Microsoft, Doug worked as a developer in digital certificate enablement technology for GiftCertificates.com before leaving to pursue life running his own company. DotNetJunkies.com provides hands-on training in ASP.NET and ADO.NET data access.

Table of Contents

Introduction	4	(3)
Part I What Is.NET?
What Is ASP.NET?	7	(18)
The Major Differences Between ASP and ASP.NET	9	(6)
Strong-Typed Languages	9	(1)
ADO vs. ADO.NET	10	(1)
Server Controls	11	(3)
XML and SOAP Support	14	(1)
Breaking Down the Parts of ASP.NET	15	(9)
Server Controls	15	(3)
Server-Side Event Handling	18	(3)
Multilanguage Support	21	(1)
Web Services	22	(1)
Session State Management	23	(1)
Caching	23	(1)
Summary	24	(1)
What Is ADO.NET?	25	(24)
ADO.NET Explained	26	(1)
The Benefits of ADO.NET	27	(3)
Interoperability	27	(1)
Maintainability	28	(1)
Programmability	28	(1)
Performance	29	(1)
Scalability	29	(1)
ADO.NET Document Object Model	30	(15)
DataTables	31	(4)
DataRelation	35	(3)
Constraints	38	(7)
Summary	45	(4)
Part II Reading and Displaying Data
ADO.NET Managed Providers	49	(34)
The Two Managed Providers	51	(1)
OleDb Managed Provider	51	(1)
SQL Managed Provider	51	(1)
Managed Connections	51	(4)
OleDbConnection	52	(2)
SqlConnection	54	(1)
Managed Commands	55	(4)
The DataReader	59	(5)
Managed Commands with Stored Procedures	64	(3)
The DataAdapter	67	(12)
DataAdapter.Fill() Method	71	(8)
Table and Column Mappings	79	(3)
Summary	82	(1)
Basic ANSI-SQL	83	(16)
Setting Up Your Workspace	84	(2)
Getting Data from a Database	86	(2)
The WHERE Clause	88	(2)
The SubQuery	90	(1)
SQL Joins	91	(1)
Sorting Data	91	(2)
The ORDER BY Clause	92	(1)
The GROUP BY Clause	92	(1)
Updating Existing Data	93	(2)
Inserting New Data	95	(2)
Deleting Existing Data	97	(1)
Summary	97	(2)
Using a Basic DataGrid	99	(22)
The ASP.NET DataGrid	100	(1)
Data Binding	101	(8)
Define a Data Source	102	(1)
Set the DataSource of the DataGrid	103	(1)
Call the DataBind() Method	104	(1)
Binding to a DataTable in a DataSet	105	(4)
Binding to Arrays	109	(3)
Binding to Collections	112	(2)
Binding to Properties	114	(2)
Binding to XML Files	116	(4)
Summary	120	(1)
Altering DataGrid Output	121	(42)
Understanding DataGrid Properties	122	(9)
Using Basic DataGrid Properties to Alter the Rendered Table	125	(2)
DataGrid Style Objects	127	(4)
Paging with the DataGrid	131	(19)
Built-In Paging	132	(8)
Custom Paging	140	(10)
Sorting Columns	150	(9)
BoundColumns	159	(2)
Summary	161	(2)
Working with ASP.NET Server Controls Templates	163	(34)
What Is a Template?	164	(1)
DataGrid .NET Server Control	165	(13)
The Basic DataGrid	166	(3)
Getting More Control Using Column Objects	169	(6)
The Ultimate Control: Template Columns	175	(3)
DataList .NET Server Control	178	(8)
Repeater .NET Server Control	186	(7)
Summary	193	(4)
Part III Updating and Inputting Data
Gathering Data with ASP.NET Web Forms	197	(60)
Button ASP.NET Server Control	199	(9)
Button	199	(1)
LinkButton	200	(1)
ImageButton	201	(1)
Handling Button Events	202	(4)
Binding a Button to a Data Source	206	(2)
TextBox ASP.NET Server Control	208	(7)
Single-Line TextBox	208	(1)
Multi-line TextBox	209	(1)
Password TextBox	210	(1)
Raising and Handling Events With the TextBox	211	(4)
Binding a TextBox to a Data Source	215	(1)
DropDownList ASP.NET Server Control	215	(10)
Raising and Handling Events and Determining Item Selection	218	(3)
Binding a DropDownList to a Data Source	221	(4)
ListBox ASP.NET Server Control	225	(10)
Raising and Handling Events and Determining Item Selection	229	(4)
Binding a ListBox to a Data Source	233	(2)
CheckBox ASP.NET Server Control	235	(4)
Raising and Handling Events and Determining Item Selection	236	(3)
Binding a CheckBox to a Data Source	239	(1)
CheckBoxList ASP.NET Server Control	239	(8)
Raising and Handling Events and Determining Item Selection	243	(4)
RadioButton ASP.NET Server Control	247	(5)
Raising and Handling Events and Determining Item Selection	249	(3)
RadioButtonList ASP.NET Server Control	252	(4)
Summary	256	(1)
Evaluating Data with ASP.NET Validation Controls	257	(32)
Validation Controls and How They Work	258	(1)
Shared Validator Attributes	259	(9)
What Controls Can Be Validated	260	(1)
Server-Side Validation	260	(5)
Client-Side Validation	265	(3)
The RequiredFieldValidator Control	268	(4)
The RegularExpressionValidator Control	272	(2)
The Compare Validator Control	274	(2)
The RangeValidator Control	276	(2)
The CustomValidator Control	278	(4)
The ValidationSummary Control	282	(2)
One Control, Multiple Validators	284	(3)
Summary	287	(2)
Inputting and Editing Data Using the DataGrid and DataList	289	(44)
An Overview of Editing Functions	290	(1)
Enabling Editing Using the DataGrid	291	(10)
Putting the DataGrid into Edit Mode	298	(1)
Updating Data with the DataGrid	299	(1)
Cancelling Out of Edit Mode	300	(1)
Enabling Editing Using the DataList	301	(9)
Putting the DataList into Edit Mode	308	(1)
Updating Data with the DataList	309	(1)
Cancelling Out of Edit Mode	310	(1)
Changing Output with the ItemCreated Event Using the DataGrid and DataList	310	(9)
Enabling Item Selection Using the DataGrid and DataList	319	(9)
Tip---Using a DropDownList in a DataGrid	328	(5)
Summary	333	(1)
Editing and Filtering Data	333	(58)
The DataTable Versus DataView	334	(1)
DataRow and DataRowView	335	(1)
The DataColumn Object	335	(1)
The DataTable: Filtering, Adding, Editing, Sorting, and Deleting DataRows	335	(16)
Filtering Rows in a DataTable	339	(3)
Adding New Rows to a DataTable	342	(3)
Editing Rows in a DataTable	345	(3)
Sorting Rows in a DataTable	348	(1)
Deleting Rows in a DataTable	348	(3)
The DataView: Filtering, Adding, Editing, Sorting, and Deleting DataRow Views	351	(19)
Filtering Rows in a Data View	354	(4)
Adding a New Row to a Data View	358	(3)
Editing Rows in a Data View	361	(3)
Finding DataRow Views	364	(2)
Deleting DataRow Views	366	(4)
Using the SqlCommandBuilder to Save Changes Back to Your Database	370	(4)
Bringing It Together	374	(14)
Summary	388	(3)
Part IV Advanced Data Concepts
XML and SOAP	391	(34)
What Is XML? A Quick Refresher	392	(1)
Xml Server Control	393	(7)
XmlDocument and XslTransform	400	(11)
XmlDataDocument	404	(7)
Working with XML Elements	411	(4)
Reading and Writing XML Files with the DataSet	415	(7)
SOAP (Simple Object Access Protocol)	422	(1)
The Structure of SOAP	422	(1)
SOAP Abstraction in .NET	423	(1)
Summary	423	(2)
BLOB Uploading and Displaying	425	(28)
Uploading Files Using HtmlInputFile	427	(4)
Using the HttpPostedFile	431	(7)
Working with the In Memory File---Saving it to a Database	438	(5)
Retrieving and Showing an Image from a Database	443	(7)
Summary	450	(3)
Exposing Data Through Web Services	453	(48)
What Are Web Services?	454	(5)
Common Standards	455	(1)
Usable Protocols	456	(3)
Building Simple Output Web Services	459	(5)
WebMethod	459	(5)
Building Input/Output Web Services	464	(20)
Building the GetProducts() WebMethod	466	(6)
Building the PlaceOrder() WebMethod	472	(8)
Building the GetOrderDetail() WebMethod	480	(4)
Consuming Web Services	484	(14)
WSDL.exe	484	(3)
Building the Consumer Web Form	487	(11)
Summary	498	(3)
Authentication	501	(24)
Security Configuration	502	(2)
Types of Authentication	504	(2)
Windows Authentication	504	(1)
Passport Authentication	505	(1)
Forms Authentication	506	(1)
Using Forms Authentication	506	(11)
Creating an Authentication Ticket Cookie	509	(2)
Manually Creating a Forms Authentication Ticket	511	(6)
Role-based Forms Authentication	517	(6)
Summary	523	(2)
Data Caching	525	(152)
What Is Caching?	526	(3)
Using the Page Output Cache	529	(19)
Using the &commet;OutputCache Directive to Enable Caching	529	(19)
Using the HttpCachePolicy Class to Enable Output Caching	548	(2)
Using Fragment Caching	550	(6)
Using the Cache APIs	556	(15)
The Insert Method	561	(5)
The Get Method	566	(2)
The GetEnumerator Method	568	(2)
The Remove Method	570	(1)
Caching in Web Services	571	(3)
Summary	574	(3)
Part V Appendixes
A ASP.NET Server Controls Reference	577	(82)
ASP.NET Intrinsic Server Controls	578	(1)
Button	578	(3)
CheckBox	581	(4)
DropDownList	585	(4)
HyperLink	589	(4)
Image	593	(4)
ImageButton	597	(4)
Label	601	(3)
LinkButton	604	(4)
ListBox	608	(4)
Panel	612	(4)
PlaceHolder	616	(2)
RadioButton	618	(4)
RadioButtonList	622	(5)
Table	627	(4)
TableCell	631	(3)
TableRow	634	(4)
TextBox	638	(4)
ASP.NET Rich Server Controls	642	(1)
AdRotator	642	(4)
Calendar	646	(5)
ASP.NET Style Objects	651	(1)
TableItemStyle	651	(8)
B ADO.NET Object Model	659	(18)
The Major Components of an ADO.NET Solution	660	(1)
ADO.NET Object Model	661	(1)
ADO.NET DbTypes	662	(3)
ASP.NET DataSet	665	(2)
ASP.NET DataTable	667	(3)
RowStates of a DataRow	670	(1)
DataColumn ForeignKeyContraint	670	(1)
ASP.NET Managed Providers	670	(1)
ASP.NET Managed Connection	671	(1)
The Managed Command Object Model	672	(2)
The DataAdapter Object Model	674	(3)
Index	677