O'Reilly logo

Visual Basic® .NET Database Programming by Rod Stephens

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Program ExploreRelations

Example program ExploreRelations uses SQL Server’s stored procedures to study the relations between tables in a database. Select the File menu’s Server command to pick a server and database to examine. The program loads information about the database’s tables and displays it in a DataGrid control. Initially the grid is collapsed. Click on the plus sign to see a list of tables similar to the one shown in Figure 13.5.

Figure 13.5. Program ExploreRelations lists the tables in a database.

When you click on one of the tables, the DataGrid displays information about the table’s columns. Figure 13.6 shows the results for the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required