Designing a Database

Understanding database design concepts Learning to normalize database tables Learning the basics of Structured Query Language he key to developing an active Web site is data. Data is basically unstructured information such as a name, address, or user preference (a favorite color, for example). When I you think about it, as Information Technologists, all we do is move data from one place 30 Min. to another and present it in different formats. There are many different types of data, To Go...

What Is Data Shaping

Data shaping is simply the process of reflecting the parent-child relationships that exist between data objects. For instance, let's look at demonstrating the parent-child relationship between two data objects a set of stores and a set of titles sold by the stores. Figure 25-1 illustrates this relationship. In ASP you could store these relationships in a hierarchical recordset by using the Shape Provider, and then produce a structured output representing the hierarchy to the user. The shaping...

Webconfig and Security

There are two types of XML configuration files used by ASP.NET, they are called machine.config and Web.config. The format of these files and elements that they can contain are the same, however the machine.config file provides the default configuration for all applications and directories, while the Web.config file allows you to modify these defaults for a specific application or virtual directory. The machine.config is a located at and there is only one copy of this file per Webserver, whereas...

Web Service Description Language WSDL

The Services Description Language provides developers of Web Service client applications the detailed information needed to create proxies for accessing the Web service. The WSDL will describe the public functions provided by the Web Service, the required and optional parameters, the ordering of those parameters, as well as the data types. The WSDL also will specify the format, type, and structure of the returned data so that the consumer can appropriately handle the response. Let's look at a...

Info

Understanding transaction management with ADO.NET Before you can access any part of a database, you need to establish a connection to it. You can use either the OleDbConnection or SqlConnection object to represent that connection. Throughout our discussion of ADO.NET, we are going to use a simple analogy to try and relate ADO.NET objects to something most people use everyday a telephone. This will help you visualize what is actually happening when you use the ADO.NET objects. In the telephone...

Introducing Data Sets Part II

Learning to construct a DataSet without a DataAdapter object Learning to navigate the DataSet's object model Understanding the relationship between DataSet, DataTable, DataRow, and DataColumn objects In the previous session, we began our discussion of DataSet objects, the cornerstone of ADO.NET. You learned that a dataset is effectively a disconnected copy of a database and that you can populate a DataSet using a DataAdapter object. In this session, you're going to attack some of the DataSet...

ASP and Aspnet Compatibility

After installing the .NET Framework in your existing ASP environment, you will find that you are able to continue running your ASP pages without modification. Additionally, as you begin to write your own ASP.NET pages you will find that they operate nicely side by side with your existing ASP pages. However, as you begin to migrate code from your ASP pages to ASP.NET you will find that there are at least four major areas of differences in how you coded in ASP versus how you will code in ASP.NET...

The PageOnLoad event

Listing 8-4 demonstrates how you can handle HTML control events with the Page_OnLoad event. Listing 8-4 Using HTML control events with the Page_OnLoad event lt script runat server language VB gt Sub Page_Load Sender As Object, E As EventArgs If Page.IsPostBack Then Select cmbPeople.value Case Bill Gates Case Larry Ellison Response.Redirect http www.oracle.com Case Steve Case Response.Redirect http www.aol.com Case Else End Select End If End Sub lt script gt lt html gt lt body gt form id...

Consuming a Web Service

There are basically two ways to use a Web Service. You can either call the Web Service directly from your browser, as you just did, or you can use some application to programmat-ically call the service. Making a direct browser request is easy, but programmatically accessing a Web Service can be a little more difficult especially if you don't know anything about the particular Web Service you'd like to use. In order to communicate with a Web Service, you need to know what methods it supports,...

Master Detail Relationships with the Data Grid Control

When implementing user interfaces, a very common technique for navigating through sets of data is to utilize Master Detail controls to facilitate data searching. For example, Figure 23-2 shows the data relationships that exist between the Authors table and the Titles Table in the Pubs database. Figure 23-2 Diagram of authors and titles relationship Figure 23-2 Diagram of authors and titles relationship In Figure 23-2, there is a many-to-many relationship between authors and titles. The...