Happy Codings - Programming Code Examples

Html Css Web Design Sample Codes

CPlusPlus Programming Sample Codes

JavaScript Programming Sample Codes

C Programming Sample Codes

CSharp Programming Sample Codes

Java Programming Sample Codes

Php Programming Sample Codes

Visual Basic Programming Sample Codes

Visual Basic Programming Code Examples

Visual Basic > Database SQL Stuff Code Examples

Enumerate all the queries-stored procs in a Access-SQL Database



Enumerate all the queries-stored procs in a Access-SQL Database

To enumerate all the queries/stored procedures in an access/sql server database use the 
following routine (please read the procedure Notes). 

'Purpose   :    Returns all the queries in an Access database
'Inputs    :    cCN             An valid open ADO database connection
'Outputs   :    A collection of all query names
'Notes     :    Must reference MSADOX.DLL ("Microsoft ADO Ext. 2.5")
'               FOR SQL Server database use : Select * from sysObjects where type = "p"


Public Function QueryNames(cCN As ADODB.Connection) As Collection
    Dim oCatalog As New ADOX.Catalog, colQueryNames As New Collection
    Dim oProc As ADOX.Procedure, oView As ADOX.View
   
    On Error GoTo ExitSub
    Set oCatalog.ActiveConnection = cCN
    
    'Enumerate  CrossTab type queries
    For Each oProc In oCatalog.Procedures
        colQueryNames.Add oProc.Name
    Next
    
    'Enumerate Select type queries
    For Each oView In oCatalog.Views
        colQueryNames.Add oView.Name
    Next
    
    Set QueryNames = colQueryNames

ExitSub:
    Set oCatalog = Nothing
    Set oProc = Nothing
    Set oView = Nothing
End Function

Convert Octal Number Decimal Vice Versa
In the program, the octal number is stored in the variable octalNumber, passed to function octalToDecimal(). This function converts the octal number passed by user to its equivalent

Find ones complement of a binary number
C program to input binary number from user and find ones complement of binary number using loop. What is Ones complement? Ones complement of a binary number is defined as

Subtract Complex Number using Operator
In this c++ program example, three objects of type "Complex" are created and user is asked to enter the real and imaginary parts for two complex numbers which are stored in objects

C++ Program Implement Triply Linked list
Program sample implements the triply linked list which is a "Linked List" which consists of 3 "pointers" which points to the element at the next, previous to it in addition to the element

Top Down Triangle Printing in C Language
C Program code to print 'Top Down Triangle'. A triangle with one of its 'angle 90 degrees' is called right triangle. We shall now see how to print stars, in right triangle shape, but upside

Calculate Addition or Subtraction & Trace
Calculate the addition or subtraction & trace of 2 matrices. Here trace of the matrix is the sum of the elements on the main diagonal i.e the diagonal from the upper left to the lower

C++ Programming code Copy File Content
To copy the "content of a file" to the other file in C++ programming, you have to first ask to the user to enter the "source file" to open the source file and ask to enter the target source

C++ For Loop is Similar to While Loop but
Control statement itself has three parts: for ( "initialization"; test condition; run every time command ). "Initialization" part is performed only once at for loop start. We can initialize a