101 Microsoft® Visual Basic® .NET Applications

Application #23. Use T-SQL to Create Database Objects

This sample application shows you how to create database objects by executing T-SQL statements from ADO.NET. The emphasis will be on constructing T-SQL statements to create a database and then add various database objects to it, such as a table, stored procedure, and view. The table will then be populated, a DataSet object filled with its contents, and the results displayed in a DataGrid control. Figure 3-15 shows a screen shot of Application #23.

Figure 3-15. Application #23.

[View full size image]

Building Upon... Application #4: Try/Catch/Finally Application #12: Use a DataSet and DataView ...