Accessing data

The first step in creating a data application is to access information stored in the data source and create a copy so that the data can be manipulated locally by your application. In JBuilder, a subset of data is extracted from the data source into a JBuilder StorageDataSet subclass. The StorageDataSet subclass you use depends on the way in which you obtain the information. For example, when using queries (with or without parameters), use the QueryDataSet and for stored procedures, use the ProcedureDataSet. For these types of DataSet components, the data source is a SQL server database so you also need a Database component to handle the connection to the server.

When reading data from a text file, use the TableDataSet component but since a text file is not a SQL server, you do not need a Database component.

The following diagram describes the different ways to obtain and store data into a JBuilder component that is appropriate based on the data source:

This chapter includes basic tutorials on accessing data, as well as issues and features that affect or control accessing data.