ADO Command and Stored Procedures

Connection members

Below are details of the properties and methods of the ADO Connection object

Property Name Description
ActiveConnection The associated Connection Object
CommandText The query String
ComandTimeout The amout of time before the execution is aborted. Default is 30 seconds
CommandType A hint at the type of query string
adCmdText 1
adCmdTable 2
adCmdStoredProc 4
adCmdUnknown 8
Prepared Indicate whether the command should be precompiled

Method Parameters
CreateParameter(n,t,d,s,v)

n = Name of the parameter
t = Type of Parameter
d= The direction of the parameter

adParamInput 1 adParamOutput 2 adParamInputOut 3 adParamReturnValue 4

s= The Maximum size of the parameter
v= The value of the parameter

Execute(count, parameters, options)  

A parameter object also has a AppendChunk method, and a GetChunk method. These add/retrieve data from the parameter.

You might also like...

Comments

David Nishimoto NishiSoft provides Part I of the Information Technology Project collaboration. Sign up and list your IT project tasks, assign task too friends, and get percent complete task. Part will include a wo...

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“A computer lets you make more mistakes faster than any other invention in human history, with the possible exceptions of handguns and tequila” - Mitch Ratcliffe