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.

Building Upon...

Application #4: Try/Catch/Finally

Application #12: Use a DataSet and DataView ...

Get 101 Microsoft® Visual Basic® .NET Applications now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.