‘ 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
‘ 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
‘ 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
‘ 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
‘ 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
‘ 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
If you’re building a project with multiple similar forms, it’s nice to be able to cut-and-paste controls from one form to another. However, in VB6, you can’t do this for
‘ get the text enclosed between two Delimiters” it advances Index after the close delimiter’ Returns “” and Index = -1 if not found’ search is case sensitive’ ‘ For
Here’s a quick-and-dirty method to determine whether a string contains only uppercase characters ‘ the string to test is in the SOURCE variableIf System.Text.RegularExpressions.Regex.IsMatch(source, “^[A-Z]+$”) Then Console.WriteLine(“Uppercase string”)End If If