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 Program Codes Get nth Bit of a Number - Program to input any number from user and check whether nth bit of the given number is set (1) or not (0). How to check whether nth bit of a given number is set or unset using...

C++ language Declare a Variable as Static - In the C++ Programming, The static keyword allows a variable to maintain its value among different function calls. If the value of a static variable changes when the variable has been

C Calculate the Sum of the Array Elements - C Program code calculates the sum of array elements using pointer. The program uses the pointer to traverse the array and adds up the element values there. C program to read

Codes Convert Binary Number to Decimal - C Programming code take a binary number and store it in the variable j. And initialize the variable decimal_val to zero, variable base to 1. Obtain the remainder and quotient of the...

Program to Create a Random Graph Using - This algorithm randomly assigns a number of vertexes and edges of the graph. It connects vertexes randomly & generates cyclic, acyclic or disconnected undirected graphs. Generate

C Code using of &(ampersand) *(asterisk) - C We have already seen in the first example that we can display the address of a variable using ampersand sign. I have used &num to access the address of variable num. The &...

Find the two Elements such that their Sum - Initialize the array named array[] with the random values. Call function minabsvaluepair and pass array and its size as parameters. In the function definition receive parameters...

C++ Finding Median of Two Sorted Arrays - Program find the 'median' of elements where elements are stored in 2 'different arrays'. We need to find 'combined' median of 2 different 'data set'. So it includes sorting of both arrays