Library code snippets
ADO Command and Stored Procedures
By David Nishimoto, published on 06 Jul 2002
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 ...
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 ...
Page 2 of 3
- Introduction
- Connection members
- Refreshing Parameters
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
s= The Maximum size 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.
Related articles
Related discussion
-
Header and Footer in Web page print
by fhajaj (4 replies)
-
help me to get simple requirement
by Slicksim (1 replies)
-
Gridview -> Template Field -> Button
by antti.simonen (1 replies)
-
Classic ASP : Page expires
by chezhian_in05 (0 replies)
-
ASP VS PHP
by paulfp (9 replies)
Related podcasts
-
ASP.NET Caching and Performance
Steve Smith, owner of ASP Alliance and Lake Quincy Media joins us today to teach us about some hidden gems in ASP.NET caching and performance. Steve’s expertise in this area comes from first-hand experience as Lake Quincy’s ad system serves over 60 requests per second and handles over 150 million...
Related jobs
-
Microsoft .Net Architect
in AMSTERDAM (€50K-€90K per annum) -
Microsoft Dynamics CRM Technical Consultant
in Netherlands (€50K-€90K per annum) -
Technical Support Engineer EMEA
in Reading (£50K-£50K per annum) -
Solutions Engineer
in Reading (£50K-£60K per annum)
HI I was wondering if anyone knows how to run a stored procedure prefrable from a .sql file against a new database in VB?
I would be very gratful for you help.
Chris
How do you easy add or update a recordset when you have opened it using a stored procedure?
I'm making a program where the user sees a recordset as a grid (used SP). The user can edit rows or add new ones by going into detail mode. (I use a tabstrip where Grid is on the first and a detail frame is on the second tab.) When user goes into editmode I want the user to manipulate the record and be able to update or add.
But it seems that SP only return readonly recordsets. Is that so?
How do one then implement the grid/detail scenario when using stored procedures?
Examples are preferred!!
regards
Svein Are Gronsund, Norway
This thread is for discussions of ADO Command and Stored Procedures.