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

Program Convert Binary Decimal Number - To improve "readability of program" make a separate function and function should return the "resultant number". In main function user enters input number. Calls the function, pass

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++ Codings Simple Class Template Array - Templates are a feature of the C++ Language that allows functions and classes to "operate" with generic types. A class template provides a "specification" for generating classes based

Code Convert a Number Decimal to Binary - Find a Binary equivalent of a decimal number entered by the user, using recursion. The user has to enter a 'decimal' which has a base 10 & this program evaluates the binary equivalent

BoyerMoore & Algorithm String Matching - Whenever the 'character' does not match, we slide the pattern in such a way that aligns the bad character with the last occurrence of it in pattern. We preprocess the pattern and store

Display largest element of an input Matrix - C language code to pick & display the largest element of an input matrix. How many rows in the matrix? How many columns in the matrix? The largest element of the matrix is

Encoding a Message Matrix Multiplication - This C++ Program perform 'encoding matrix' using a hidden-key. "Encoding" is performed using "matrix multiplication" between given matrix and 'key matrix'. Enter the number of

C++ Implements Fermat's Little Theorem - Program demonstrates the implementation of Fermat's Little Theorem. For the modular "multiplicative inverse" to exist, the number and 'Modular' must be 'Coprime'. Calculates