Home » ASP » Database Integration ::

Interrogating a Stored Procedure with ADO

ASP Database Integration

Report www.15seconds.com Views: 94

View Tutorial

This article shows how to use the refresh method of the ADO Parameters collection to interrogate a stored procedure. You may already have experience using ADOX or SQL-DMO to accomplish this, but please keep in mind that the method displayed here is meant to be simple enough that anyone with ADO experience can use it. (ADOX and SQL-DMO will be addressed later.)

Related Tutorials


	Displaying Records Using Stored procedure ASP / Database Integration We will get results form a table using stored procedure. Stored procedures work faster and increase the performance. Stored procedures stored at SQL servers and we can call them in an ASP file. Site: www.dotnetindex.com Report - View Tutorial


	Create a PDF from a stored procedure ASP / Miscellaneous This article explains how to create a stored procedure and to call it from ASP or directly from SQL Server. The stored procedure will in turn create a simple column based report in PDF without using any external tools or libraries (and their associated licensing costs!). Site: dypso.free.fr Report - View Tutorial


	Hit counter Using Stored Procedure ASP / Counters This simple counter uses only one stored procedure to update and display hits. So it uses less server memory. The database back-end is SQL Server. But you may easily modify procedure to use with MS Access Site: www.dotnetindex.com Report - View Tutorial


	Fun With Stored Procedures ASP / Database Integration A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as others ... A stored procedure is compiled by your database (for the most part) one time, when it is entered. This results in faster database executions and overall performance updates... as an added bonus, it further separates the sql statement from your asp leaving you with more readable code. So let's get on with it. Site: www.aspemporium.com Report - View Tutorial


	Adding Records Using Stored procedure ASP / Database Integration This code source is focusing on creating a simple stored procuder to add items into a SQL Server. If you use stored procuders, your applications will work faster and performance will be better. Site: www.dotnetindex.com Report - View Tutorial


	SQLServerTools Object ASP / Database Integration This example was easy Get a list of all current tables in the database created by your's truly, get a list of dependent stored procedures for each table and do it all in a stored procedure. Site: www.aspemporium.com Report - View Tutorial


	ADO and ADO.NET Connection Strings ASP / Database Integration This tutorial was created as an easy reference of various ADO and ADO.NET connection strings for the most popular database types. Connection strings are string variables which contain database connection information and then passed to ADO(ActiveX Data Objects) which will interpret them and act accordingly. Since there are going to be passed to ADO, they need to be in a comprehensible for ADO format. Site: www.webcheatsheet.com Report - View Tutorial


	Deleting Records Using Stored procedure ASP / Database Integration We will continue working on our sample table. Now we will delete some records using stored procuder. To work on the code create a sample database and run this sql script. Site: www.dotnetindex.com Report - View Tutorial


	Updating Records Using Stored procedure ASP / Database Integration This code source is focusing on creating a simple stored procudure updating records in a table. Code is simple and clear, you may modify this code to use in your applications. To work on the code create a sample database and run this sql script . Site: www.dotnetindex.com Report - View Tutorial


	Introduction to ActiveX Data Object (ADO) ASP / Database Integration This tutorial provides you a quick introduction of ActiveX Data Object (ADO), and a simple example of using ADO to work with MS Access database. Site: www.herongyang.com Report - View Tutorial


	Basic ADO and SQL Tutorial ASP / Database Integration Learn how to use the ADO Connection, Command, and RecordSet object with simple SQL statements with ASP (Active Server Pages). Site: aspalliance.com Report - View Tutorial


	What's in an ADO Connection String? ASP / Database Integration This article explains ADO connection strings and parameters. By the end of the article you should be able to build appropriate ones on your own instead of cutting and pasting them. Site: www.asp101.com Report - View Tutorial


	Loops within Loops: Coding an ASP-based Bulletin Board ASP / Scripts This article provides an easy way to list nested forums. It does have some drawbacks, though. For starters, there is an upper-bound on the number of nested replies a message can have. In this example, the number is 12, although this is configurable. Furthermore, this approach is not the most efficient approach, and could be streamlined using stored procedures and fewer ADO objects within the code. Site: www.4guysfromrolla.com Report - View Tutorial


	Wielding the Power of the DataView ASP / Database Integration When faced with learning a new technology, it's common to try and reproduce the basic functionality you're used to in the old one. In doing that with ADO.NET and trying to reproduce the basics or the recordset object, this article discusses the new and many uses of ADO.NET's DataView object. Site: www.asp101.com Report - View Tutorial


	Running Stored Queries in Access Database ASP / Database Integration Explains everything in detail you'll ever need to know about creating Stored Procedures in Access Database and then calling from within ASP. Site: www.stardeveloper.com Report - View Tutorial

Site Search

Categories

2D Graphics

Adobe Fireworks

Adobe Illustrator

Adobe Image Ready

Adobe Photoshop

3D Graphics

Office Applications

Microsoft Excel

Microsoft PowerPoint

Databases

Microsoft Access

Desktop Programming

Web Development

Adobe DreamWeaver

ASP

CSS

Microsoft FrontPage

Advertisement

Copyright © 2006-2008 TutCity.com | Submit Tutorials | Contact us | Terms of use | Privacy Policy