- •Preface
- •Who Should Read This Book
- •Organization and Presentation
- •Contacting the Authors
- •Acknowledgments
- •Contents
- •Introduction
- •Why Microsoft .NET?
- •The Microsoft .NET Architecture
- •Internet Standards
- •The Evolution of ASP
- •The Benefits of ASP.NET
- •What Is .NET?
- •.NET Experiences
- •.NET Clients
- •.NET Services
- •.NET Servers
- •Review
- •Quiz Yourself
- •Installation Requirements
- •Installing ASP.NET and ADO.NET
- •Installing the .NET Framework SDK
- •Testing Your Installation
- •Support for .NET
- •Review
- •Quiz Yourself
- •Designing a Database
- •Normalization of Data
- •Security Considerations
- •Review
- •Quiz Yourself
- •Creating a Database
- •Creating SQL Server Tables
- •Creating a View
- •Creating a Stored Procedure
- •Creating a Trigger
- •Review
- •Quiz Yourself
- •INSERT Statements
- •DELETE Statements
- •UPDATE Statements
- •SELECT Statements
- •Review
- •Quiz Yourself
- •The XML Design Specs
- •The Structure of XML Documents
- •XML Syntax
- •XML and the .NET Framework
- •Review
- •Quiz Yourself
- •ASP.NET Events
- •Page Directives
- •Namespaces
- •Choosing a Language
- •Review
- •Quiz Yourself
- •Introducing HTML Controls
- •Using HTML controls
- •How HTML controls work
- •Intrinsic HTML controls
- •HTML Control Events
- •The Page_OnLoad event
- •Custom event handlers
- •Review
- •Quiz Yourself
- •Intrinsic Controls
- •Using intrinsic controls
- •Handling intrinsic Web control events
- •List Controls
- •Rich Controls
- •Review
- •Quiz Yourself
- •Creating a User Control
- •Adding User Control Properties
- •Writing Custom Control Methods
- •Implementing User Control Events
- •Review
- •Quiz Yourself
- •Common Aspects of Validation Controls
- •Display property
- •Type Property
- •Operator Property
- •Using Validation Controls
- •RequiredFieldValidator
- •RegularExpressionValidator
- •CompareValidator
- •RangeValidator
- •CustomValidator
- •ValidationSummaryx
- •Review
- •Quiz Yourself
- •Maintaining State Out of Process for Scalability
- •No More Cookies but Plenty of Milk!
- •Out of Process State Management
- •Review
- •Quiz Yourself
- •Introducing the Key Security Mechanisms
- •Web.config and Security
- •Special identities
- •Using request types to limit access
- •New Tricks for Forms-based Authentication
- •Using the Passport Authentication Provider
- •Review
- •Quiz Yourself
- •ASP.NET Updates to the ASP Response Model
- •Caching with ASP.NET
- •Page Output Caching
- •Absolute cache expiration
- •Sliding cache expiration
- •Fragment Caching
- •Page Data Caching
- •Expiration
- •File and Key Dependency and Scavenging
- •Review
- •Quiz Yourself
- •A Brief History of Microsoft Data Access
- •Differences between ADO and ADO.NET
- •Transmission formats
- •Connected versus disconnected datasets
- •COM marshaling versus text-based data transmission
- •Variant versus strongly typed data
- •Data schema
- •ADO.NET Managed Provider Versus SQL Managed Provider
- •Review
- •Quiz Yourself
- •Review
- •Quiz Yourself
- •Creating a Connection
- •Opening a Connection
- •Using Transactions
- •Review
- •Quiz Yourself
- •Building a Command
- •Connection property
- •CommandText property
- •CommandType property
- •CommandTimeout property
- •Appending parameters
- •Executing a Command
- •ExecuteNonQuery method
- •Prepare method
- •ExecuteReader method
- •Review
- •Quiz Yourself
- •Introducing DataReaders
- •Using DataReader Properties
- •Item property
- •FieldCount property
- •IsClosed property
- •RecordsAffected property
- •Using DataReader Methods
- •Read method
- •GetValue method
- •Get[Data Type] methods
- •GetOrdinal method
- •GetName method
- •Close method
- •Review
- •Quiz Yourself
- •Constructing a DataAdapter Object
- •SelectCommand property
- •UpdateCommand, DeleteCommand, and InsertCommand properties
- •Fill method
- •Update method
- •Dispose method
- •Using DataSet Objects
- •DataSetName property
- •CaseSensitive property
- •Review
- •Quiz Yourself
- •Constructing a DataSet
- •Tables property
- •TablesCollection Object
- •Count property
- •Item property
- •Contains method
- •CanRemove method
- •Remove method
- •Add method
- •DataTable Objects
- •CaseSensitive property
- •ChildRelations property
- •Columns property
- •Constraints property
- •DataSet property
- •DefaultView property
- •ParentRelations property
- •PrimaryKey property
- •Rows property
- •Dispose method
- •NewRow method
- •Review
- •Quiz Yourself
- •What Is Data Binding?
- •Binding to Arrays and Extended Object Types
- •Binding to Database Data
- •Binding to XML
- •TreeView Control
- •Implement the TreeView server control
- •Review
- •Quiz Yourself
- •DataGrid Control Basics
- •Binding a set of data to a DataGrid control
- •Formatting the output of a DataGrid control
- •Master/Detail Relationships with the DataGrid Control
- •Populating the Master control
- •Filtering the detail listing
- •Review
- •QUIZ YOURSELF
- •Updating Your Data
- •Handling the OnEditCommand Event
- •Handling the OnCancelCommand Event
- •Handling the OnUpdateCommand Event
- •Checking that the user input has been validated
- •Executing the update process
- •Deleting Data with the OnDeleteCommand Event
- •Sorting Columns with the DataGrid Control
- •Review
- •Quiz Yourself
- •What Is Data Shaping?
- •Why Shape Your Data?
- •DataSet Object
- •Shaping Data with the Relations Method
- •Review
- •Quiz Yourself
- •OLEDBError Object Description
- •OLEDBError Object Properties
- •OLEDBError Object Methods
- •OLEDBException Properties
- •Writing Errors to the Event Log
- •Review
- •Quiz Yourself
- •Introducing SOAP
- •Accessing Remote Data with SOAP
- •SOAP Discovery (DISCO)
- •Web Service Description Language (WSDL)
- •Using SOAP with ASP.NET
- •Review
- •Quiz Yourself
- •Developing a Web Service
- •Consuming a Web Service
- •Review
- •Quiz Yourself
- •ASP and ASP.NET Compatibility
- •Scripting language limitations
- •Rendering HTML page elements
- •Using script blocks
- •Syntax differences and language modifications
- •Running ASP Pages under Microsoft.NET
- •Using VB6 Components with ASP.NET
- •Review
- •Quiz Yourself
- •Preparing a Migration Path
- •ADO and ADO.NET Compatibility
- •Running ADO under ASP.NET
- •Early Binding ADO COM Objects in ASP.NET
- •Review
- •Quiz Yourself
- •Answers to Part Reviews
- •Friday Evening Review Answers
- •Saturday Morning Review Answers
- •Saturday Afternoon Review Answers
- •Saturday Evening Review Answers
- •Sunday Morning Review Answers
- •Sunday Afternoon Review Answers
- •What’s on the CD-ROM
- •System Requirements
- •Using the CD with Windows
- •What’s on the CD
- •The Software Directory
- •Troubleshooting
- •ADO.NET Class Descriptions
- •Coding Differences in ASP and ASP.NET
- •Retrieving a Table from a Database
- •Displaying a Table from a Database
- •Variable Declarations
- •Statements
- •Comments
- •Indexed Property Access
- •Using Arrays
- •Initializing Variables
- •If Statements
- •Case Statements
- •For Loops
- •While Loops
- •String Concatenation
- •Error Handling
- •Conversion of Variable Types
- •Index
240 |
Sunday Morning |
Return dataview1
Catch myException as Exception
Message.Text = (“Exception: “ + myException.ToString())
End Try
End Function
Next, we bind the DataGrid control with the filtered DataView object. This is done with the final two statements of the BindData() function:
titleGrid.DataSource = TitlesDataView titleGrid.DataBind()
First, you set the DataSource property of the titleGrid to the Default View of the TitlesDataView, and then you execute the titleGrid.DataBind() method to populate the DataGrid object. Figure 23-3 shows the results of your work.
Figure 23-3 Example of using the DataGrid control for master/detail relationships
REVIEW
At this point you should be able to implement master/detail user interfaces in your applications. While the use of the DataGrid control has made your job much easier, the core part of the work continues to be understanding the use of ADO.NET objects in getting and filtering data.
Session 23—Using the DataGrid Control with Bound Data |
241 |
QUIZ YOURSELF
1.How do you control the formatted display of values in a BoundColumn? (See “Formatting the output of a DataGrid control.”)
2.How can you control the ordering of values into columns of a DataGrid? (See Master/Detail Relationships with the DataGrid Control.”)
3.Is a master/detail user interface more useful for a many-to-many relationship or a one-to-many relationship? (See “Master/Detail Relationships with the DataGrid Control.”)
S E S S I O N
24
Beating the CRUD out of the
DataGrid Control
Session Checklist
Using the DataGrid control as a user interface for modifying data
Using validation controls with template columns for data validation
Sorting the columns of a DataGrid control
In Session 23, we illustrated how you can use the DataGrid control to support the display of data. However, just showing the data is useless if you can’t provide updates or deletes. In this session we will build upon the examples used in Session 23 to illustrate how the DataGrid control can be used to update data. The DataGrid control comes with a
whole host of built-in functionality that can be exposed to provide a highly customizable approach to building user interfaces to your database.
This session assumes you have SQL Server Installed and have access to the Pubs database.
Note
Updating Your Data
The DataGrid control provides the capability to support editing of bound data by using the EditCommandColumn. The EditCommandColumn handles the automatic generation of “Edit”, “OK”, and “Cancel” hyperlinks or images to facilitate the user interface elements of editing a DataGrid control. When the “Edit” hyperlink or alternatively an image is selected, the EditCommandColumn control will replace a DataGrid control read-only cell with an editable textbox. Figure 24-1 illustrates the resulting output of using the EditCommandColumn to build the “Edit” hyperlink.
244 |
Sunday Morning |
Figure 24-1 Output of using the EditCommandColumn for editing a DataGrid control
The property value that generates the EditCommandColumn is shown in the following code:
<asp:EditCommandColumn
EditText=”Edit”
CancelText=”Cancel”
UpdateText=”OK” > </asp:EditCommandColumn>
Figure 24-2 illustrates the results of selecting the “Edit” hyperlink to edit a selected column.
Figure 24-2 Example of a data row being edited
Session 24—Beating the CRUD out of the DataGrid Control |
245 |
The DataGrid control will automatically display the appropriate hyperlinks — an “Edit” hyperlink when in standard mode, a “Cancel” and “Submit” hyperlink when in Edit mode. While the EditCommandColumn handles the generation of the GUI, you still have to provide all of the code to actually perform the edit, cancel and update functions. You attach the code modules to call when each of these events happen through the OnEditCommand, OnUpdateCommand, and OnCancel properties of the DataGrid control. For each of these properties you implement an appropriate function to handle the mechanics of the operation. Listing 24-1 illustrates the full HTML required to generate the DataGrid control and
EditCommandColumn as discussed.
Listing 24-1 HTML required to generate the DataGrid and EditCommandColumn
<ASP:DATAGRID ID=”titleGrid” RUNAT=”SERVER” FORECOLOR=”Black” AUTOGENERATECOLUMNS=”false” DATAKEYFIELD=”title_id”
ONPAGEINDEXCHANGED=”OnPageIndexChanged”
ONEDITCOMMAND=”OnEdit”
ONCANCELCOMMAND=”OnCancel”
ONUPDATECOMMAND=”OnUpdate”
ONDELETECOMMAND=”OnDelete”
ONSORTCOMMAND=”OnSorted”
ALLOWSORTING=”True”
ALLOWPAGING=”True”
PAGESIZE=”5” PAGERSTYLE-MODE=”NextPrev” PAGERSTYLE-HORIZONTALALIGN=”Center”>
<ALTERNATINGITEMSTYLE BACKCOLOR=”Gainsboro” /> <FOOTERSTYLE BACKCOLOR=”Silver” FORECOLOR=”White” /> <ITEMSTYLE BACKCOLOR=”White” />
<HEADERSTYLE BACKCOLOR=”Navy” FORECOLOR=”White” FONT-BOLD=”True” />
<COLUMNS>
<ASP:BOUNDCOLUMN HEADERTEXT=”Title” DATAFIELD=”Title” SORTEXPRESSION=”Title”>
</ASP:BOUNDCOLUMN>
<ASP:TEMPLATECOLUMN HEADERTEXT=”Unit Price” SORTEXPRESSION=”Price”>
<ITEMTEMPLATE>
<ASP:LABEL id=”Label2” RUNAT=”server”
TEXT=’<%# String.Format(“{0:C}”,
Container.DataItem(“price”))%>’
WIDTH=”50”
AUTOSIZE=”True”>
</ASP:LABEL>
</ITEMTEMPLATE>
<EDITITEMTEMPLATE> <ASP:TEXTBOX id=”editprice”
RUNAT=”Server”
TEXT=’<%# Container.DataItem(“price”)%>’
Continued