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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.