October 5, 2002

CreateDataAdapter_Sql – Create an initialized SQL DataAdapter

‘ 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

CreateDataAdapter_OleDb – Create an initialized OLEDB Data Adapter

‘ 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

CreateDataReader_Sql – Create a SqlClient Data Reader

‘ 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

UpdateDataAdapter – Update a data source through a DataAdapter

‘ 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, _

CreateDataReader – Create a DataReader over any connection

‘ 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

CreateDataReader_OleDb – Create an OLEDB Data Reader

‘ 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