‘ 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 SqlConnection’ and initialize its delete, insert, and update commands” CN is the SqlConnection object’ SQL is the SQL Select statement to
‘ 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
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
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
Here’s a quick-and-dirty method to determine whether a string contains only lowercase characters ‘ the string to test is in the SOURCE variableIf System.Text.RegularExpressions.Regex.IsMatch(source, “^[a-z]+$”) Then Console.WriteLine(“Lowercase string”)End If If
‘ 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