‘ create and return a DataAdapter over an open SqlConnection’ and initialize its delete, insert, and update commands” CN is the SqlConnection object’ SQL is the SQL Select statement to be executed” any exception is thrown to the callerFunction CreateDataAdapter_Sql(ByVal cn As System.Data.SqlClient.SqlConnection, _ ByVal sql As String) As System.Data.SqlClient.SqlDataAdapter
‘ create and return a DataAdapter over an open OleDbConnection’ and initialize its delete, insert, and update commands” CN is the OleDbConnection object’ SQL is the SQL Select statement to be executed” any exception is thrown to the callerFunction CreateDataAdapter_OleDb(ByVal cn As System.Data.OleDb.OleDbConnection, _ ByVal sql As String) As System.Data.OleDb.OleDbDataAdapter
‘ return a DataReader over a SqlConnection” CONNSTRING is the connection string’ SQL is the SQL Select statement to be executed” the connection will be automatically closed when the DataReader is disposed’ any exception is returned to the callerFunction CreateDataReader_Sql(ByVal connString As String, _ ByVal sql As String) As System.Data.SqlClient.SqlDataReader
‘ update a data source through a DataAdapter’ ‘ DA is the OleDbDataAdapter or SqlDataAdapter object’ DT is the DataTable to be updated’ if USETRANSACTIONS is True, all rows are updated, or none” returns the number of affected records’ or -1 if the update failedFunction UpdateDataAdapter(ByVal da As System.Data.IDbDataAdapter, _
‘ return a DataReader over a generic Connection” CN is the OleDbConnect or SqlConnection object’ SQL is the SQL Select statement to be executed” if closed, the connection will be opened and then closed on exit’ any exception is returned to the callerFunction CreateDataReader(ByVal cn As System.Data.IDbConnection, _ ByVal sql
‘ return a DataReader over an OleDbConnection” CONNSTRING is the connection string’ SQL is the SQL Select statement to be executed” the connection will be automatically closed when the DataReader is disposed’ any exception is returned to the callerFunction CreateDataReader_OleDb(ByVal connString As String, _ ByVal sql As String) As System.Data.OleDb.OleDbDataReader