Library code snippets
ADO Command and Stored Procedures
By David Nishimoto, published on 06 Jul 2002
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.
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...
Related articles
Related discussion
-
Help to Call ASP function from onclick event in HTML to pass an array
by vka (0 replies)
-
Binary Studio | software development outsourcing Ukraine
by shane124 (4 replies)
-
Variable In Vb.Net
by chia (0 replies)
-
ideas in building a captive portal
by sjranjan (2 replies)
-
How to debug classic ASP pages during AJAX calls in ASP.NET website
by andwan0 (0 replies)
Related podcasts
-
Scott Guthrie
Scott catches up with Scott Guthrie in an interview covering Ajax, Asp 2.0, extender controls, CSS adapters and more.
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.