This article covers two advanced ADO topics: creating hierarchical Recordsets (via data shaping) and creating custom Recordsets. Specifically, this article looks at how to create custom hierarchical Recordsets. The reader is required to have a fluid under
Tutorial Details:
Creating Custom Hierarchical Recordsets With ASP Database
This article examines how to create custom hierarchical Recordsets. Starting in ADO 2.1, Microsoft introduced the concept of "data shaping," which is the process of reshaping data. The typical Recordset object can be thought of as a two-dimensional matrix, with the columns explaining the attributes of a piece of data, and each row representing a distinct piece of data. While this abstration works well when dealing with scalar data, it quickly falls apart when working with relational data.
For example, if you wish to represent an Employee in a data model, you would create a table named, perhaps, tblEmployee , with a column for each descriptive attribute of the employee: FirstName , LastName , BirthDate , Title , etc. While this scalar information could be easily stored in a conventional Recordset, imagine that you wanted to also store a list of projects each Employee was working on (assuming that there was a table containing information on each project, tblProject ). Clearly, a Recordset, in its classical form, could not convey such information. To accomodate this, you would have to use a many-to-many table, linking multiple employees to multiple projects.
Read
Tutorial at: Click here to view the tutorial
Rate Tutorial: ASP Database Related Creating Custom Hierarchical Recordsets Tutorial
View Tutorial: ASP Database Related Creating Custom Hierarchical Recordsets Tutorial
Related
Tutorials:
 Pattern your way
to automated regression testing
Pattern your way
to automated regression testing
|
Publish
Publish event-driven Web content with JSP custom tags
|
A first look at JavaServer Faces, Part I
A first look at JavaServer Faces, Part Learn how to implement Web-based user interfaces with JSF
|
The Java Web Services Tutorial
This tutorial is a beginner\'s guide to developing Web services and Web applications using the Java Web Services Developer Pack (Java WSDP).
|
Excellent
tutorial on Struts and Tiles
Excellent tutorial on Struts and Tiles
This tutorial assumes knowledge of Java, JDBC, Servlets, J2EE (with regards to Web applications) and JSP Struts in a holistic manner, minus the beads and crystals.
The Tiles framework makes creating reusable pages
|
SQL Database Access with DBTags
SQL Database Access with DBTags
In a J2SE or J2EE application, Java Database Connectivity (JDBC) can be used to create a connection with a SQL database, create database tables, retrieve result sets, and update the database. To use a database from a Jav
|
Documenting Projects with Apache Forrest
Documenting Projects with Apache Forrest
This article will give you a very basic introduction to Forrest -- just enough to get you started and give you a taste of what's possible -- to see if Forrest's for you; you can find out much more from Forrest's
|
Annotations in Tiger, Part 2: Custom annotations
Write your own annotations in Java 5
Part 1 of this series introduced annotations, the new metadata facility in J2SE 5.0, and focused on Tiger's basic built-in annotations. A more powerful related feature is support for writing your own annotations. In t
|
An Introduction to Java Object Persistence with EJB
The 'impedance mismatch' between relational databases' tabular orientation and object-oriented Java's hierarchical one is a perennial problem for which the Java world has several good solution offerings. This article, the first in a three-part series, wil
|
Accessing the Database from Servlet
This article shows you how to access database from servlets. Here I am assuming that you are using win95/98/2000 and running Java Web Server.
|
Jeff Schmitt's JDBC Page
This tutorial assumes you are using the MySQL database and the GWE JDBC drivers. The host computer is triton.towson.edu.
|
This tutorial shows how to Creating Custom JSP Tag Libraries
JSP 1.1 introduced an extremely valuable new capability: the ability to define you own JSP tags. You Define how the tag, its attributes, and its body are interpreted, then group your tags into collections called tag libraries that can be used in any numbe
|
Backing Up and Restoring A MySQL Database
Backing Up and Restoring A MySQL Database
Backing Up and Restoring A MySQL Database
This tutorial explains the how to backup and restore the MySQL Database. Databases are used to store large amount of precious data and it becomes very important to
|
Welcome to Java Developers paradise!
Welcome to Java Developers paradise!
T his site contains many quality Java, JSP, RMI, MySQL downloads, tutorials, source codes and links to other java resources. We have large number of links to the tutorials on java which will help you learn java
|
Introduction to the JSP Java Server Pages
Introduction to the JSP Java Server Pages
Welcome to JSP Section
Introduction To JSP
Java Server Pages or JSP for short is Sun's solution for developing dynamic web sites. JSP provide excellent server side scripting support for creating database
|
JSP FUNDAMENTALS
JSP FUNDAMENTALS
JSP FUNDAMENTALS
By: Hrishikesh Deshpande
Introduction :
JSP termed as Java Server Pages is a technology introduced by Sun Microsystems Inc. to develop the web application in more efficient way than Servlets. It has got many
|
Using MYSQL Database with JSP & Servlets.
Using MYSQL Database with JSP & Servlets.
Using MYSQL Database with JSP & Servlets.
MY SQL is a powerful RDBMS, which can handle large amount of data. And more interestingly it is free to use, except for some commercial use. you can download it
|
Connecting to MySQL database and retrieving and displaying data in JSP
page
Connecting to MySQL database and retrieving and displaying data in JSP page
Connecting to MySQL database and retrieving and displaying data in JSP page
This tutorial shows you how to connect to MySQL database and retrieve the data from the
|
Techniques used for Generating Dynamic Content Using Java Servlets.
Techniques used for Generating Dynamic Content Using Java Servlets.
Techniques used for Generating Dynamic Content
Common Gateway Interface (CGI)
For any web application high performance and timely delivery are key ingredients to competitive
|
Struts Guide
Struts Guide
Struts Guide
This tutorial is extensive guide to the Struts Framework. In this tutorial you will learn how to develop robust application using Jakarta Struts Framework. This tutorial assumes that the reader is familiar with the web
|
|
|
|
