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

Example Program RunScript

Example Program RunScript, shown in Figure 6.7, ties together several of the objects described in this chapter to execute SQL scripts. Use the File menu’s commands to open an Access or SQL Server database. Use the Open Script command to load a text file containing a SQL script or type one in yourself. When you click the Execute button, the program executes the commands in the script and displays the results. The program displays the records returned by queries. For non-query commands, the program displays a success or failure message.

Figure 6.7. Example program RunScript executes SQL scripts.

The script should contain ...

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