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

Converting Binary Octal in C++ Language
To convert binary to octal in C++, you have to ask to the user to enter any number in binary to "convert it into octal" to display equivalent value in octal on the screen as shown in code

Program Find the Length of the Linked list
C Program to Find the length of the linked list using Recursion. This program uses Recursive Function and calculates the length of a string. The user enters a string to find it's length. List

C Language and Vertical Histogram Code
C program code Vertical Histogram. Define Maximum length of a word. Define Maximum No of words in a sentence. Excluding the space in the word length. Resetting the word

Find Nth Fibonacci Number Use Recursion
C Program to find the nth 'fibonacci number' using recursion. Program prints the fibonacci of a number. In fibonacci series, each number is the sum of the 2 preceding numbers. 0, 1, 1,

Reversing Numbers in C++ Programming
'C++ program' in which user enter a number, program reverse it and display the reversed number on the console. If the 'input number' is 12345 Then reversed number will be 54321

Returning a Reference to a Pointer In C++
To declare such a function, precede its name with * and &. In the body of the function, you can do whatever is appropriate. An important rule with this type of "function" is that it must

Most Significant Bit (MSB) of a number is
In C programming language we use bitwise AND & operator to check status of any bit. Bitwise AND operation evaluate each bit of resultant value as 1, if corresponding bit of...

C Code Counts Number of Words in String
C program to 'count total number' of words in a string using Loop. To count total number of 'Words in a String' we just need to count total number of white spaces. Includes single blank