Happy Codings - Programming Code Examples

Visual Basic Programming Code Examples

Visual Basic > ActiveX Controls Code Examples

Calling ODBC from ADO to connect to thirdparty driver

Calling ODBC from ADO to connect to thirdparty driver

Dim ADOCN As New ADODB.Connection
Dim ADORS As New ADODB.Recordset
Dim mysql  As String
With ADOCN
'here how to call odbc from ADO!
   .ConnectionString = "DSN=odbc namet;UID=YOURUSERID;PWD=YOURPASSWORD;"
.Mode = adModeReadOnly
   .Open
End With

With ADORS
   .CursorLocation = adUseClient
   .CursorType = adOpenKeyset
   .LockType = adLockOptimistic
   .ActiveConnection = ADOCN
    mysql = "select whatever from my table"
   .Source = mysql
   .Open
'for good preformance, I did store the record set in variant type variable so I can disconnect from host sooner

.ctiveConnection = Nothing
    myrows = .RecordCount
    mycola = .Fields.Count
    mydata = .GetRows()

'now I can loop through my result

C++ Programming Code for Selection Sort - Here, we use 'swapping' of the elements with the help of a Variable say temp of same type. That is, on found, start 'Swapping' with temp variable, place the first number in the temp &

Find the Length of the Linked List without - C Language program Find the Length of the linked list without using recursion. Program, using iteration, counts the number of nodes in a Linked List. A linked list is an ordered set

identical to scanf() example in C language - C programming code to Identical to scanf() except that data is from buf. The number of variables assigned. A value of zero means that no fields were assigned. EOF indicates

Program to calculate Average of array in C - This C program should give an insight of how to parse (read) array. We shall use a loop and Sum up all Values of the array. Then we shall divide the sum with the number of elements

C Language Continue Statement For Loop - The continue statement is used inside loops. When a continue statement is encountered inside a loop, control jumps to the beginning of the loop for next iteration, skipping the...

C++ Find the HCF and LCF of 2 Numbers - Enter the two number, to find the HCF and LCF of the given two number to display the value of the HCF and LCM of the 2 numbers on the output screen as shown here in code

C Program Print Number Pyramid Pattern - In Each Iteration we are moving downward so increment "y". For each new 'Iteration' we are starting from beginning but one 'co-ordinate' back so decrement x. 'Moves Cursor Position'

Counts Occurrences of Character in String - Program count all occurrences of a character in string using Loop. Input a string, store it in some variable "str". Input character to search occurrences and store it in some variable say