How Do You Execute SQL Script From Visual Basic?
The latest version of Visual Basic provides a rich data access layer that allows for object-oriented abstraction of the data used in an application. Sometimes however, it is more efficient, quicker or more practical to simply execute a SQL script against the underlying database directly. A SQL script may contain multiple statements that need to be executed together or it may have dynamic SQL that is generated by the application. Regardless of the reason, executing SQL scripts from within Visual Basic is not very difficult. Create a new Visual Basic Windows Forms project in Visual Studio by selecting New Project from the File menu and selecting the appropriate project type. In the default form that is created, form1, place a button control named Button1. Double click on the control to create a Button1_click event handler. At the top of the code listing for Form1 (above the line “Public Class Form1”), add an imports statement to import the .NET data access library. The statement should l
