Understanding Connections and Data Readers
To establish a connection to a database, you need to create an instance of the
SqlConnection class passing the connection string as an argument. Then you invoke the
Open method to open the connection so that you can perform your data operations. Finally, you invoke
Close to close the connection. The following code, which requires an
Imports System.Data.SqlClient directive, demonstrates how you establish a connection to the Northwind database:
Using..End Using block ensures that the connection will be correctly released without the need of invoking
To perform an insert ...
Get Visual Basic® 2010 Unleashed 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.