1.2. Generating a Quick-and-Dirty Tabular Display
Problem
You want to display data from a database in a table, and you’re not overly concerned about performance or your ability to control the arrangement of the data items within the display.
Solution
Use a DataGrid control and bind the data to it.
In the .aspx file, add the
DataGridcontrol responsible for displaying the
data.
In the code-behind class for the page, use the .NET language of your choice to:
Open a connection to the database.
Build a query string, and read the desired data from the database.
Assign the data source to the
DataGridcontrol and bind it.
Figure 1-1 shows the appearance of a typical
DataGrid in a browser. Example 1-1 through Example 1-3 show the
.aspx and VB and C# code-behind files for the
application that produces this result.

Figure 1-1. Quick-and-dirty DataGrid output
Discussion
Implementing a simple DataGrid requires very
little coding. You must first add a DataGrid tag
to the .aspx file for your application and set a
few of its attributes, as shown in Example 1-1. The
DataGrid tag has many attributes you can use to
control the creation of a DataGrid object, but
only three are required: the id,
runat, and AutoGenerateColumns
attributes. The id and runat
attributes are required by all server controls. When the
AutoGenerateColumns attribute is set to
True, it causes the DataGrid to automatically create the required ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access