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

C++ Language Print Strings on the Screen
Enter a string and receive the string using the function 'gets()'. C++ program ask to the user to "enter a string" like your first name, then it will display your first name after "Hello", print

Binary Search Algorithm in C++ Language
A program which takes some 'Elements' in an array and a 'Key' in variable then program use 'Binary Search' C++ Algorithm to find the key. One to sort array using 'Bubble Sort'. Second

C Sort Structures on the basis of Structure
Using cricket, declare an array player with 10 elements and write C program code read the information about all the 10 players and print a team wise list containing Names of Players

Code Parse the Command Line Arguments
C program is an example of how to parse the command line arguments. It sets up all the global variables for a real program and it just doesn't have any body. Loop for each option.

Read Two Integers and Swap their Values
C language program coding to take the two integers as input and store it in the variables m & n respectively. Call function swap. Pass addresses of variables to the function swap.

C Coding to find Sum of Two Matrices 3x3
C program to read elements in two matrices and add elements of both matrices. C code for addition of two matrix. Matrix addition program in C. Logic to add two matrix in C.

C Add two numbers and display their sum
C program code input two numbers from user and calculate their sum. C program to add 2 numbers and printing their sum as output. How to add two numbers in C programming.

C++ An Object can be Passed to Functions
An object can be passed to a function just like we pass structure to a function. Here in class A we have a "function disp()" in which we are passing the object of class A. Similarly we can

Romance707