 |
|
 |
Home »
ASP »
Database Integration
::
ReportRelated Tutorials
 |
|
|
|
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
|
||
|
|
|
|
|
|
ASP / Database Integration The driving force behind Active Server technologies is data access. In order to develop a truly dynamic web site developers need to allow users to access data on demand. Luckily, with Microsoft's Active Server Pages, this is exceedingly easy to do. This article for ASP beginners details how to connect to a SQL Server 7.0 database using ActiveX Data Object (ADO) and Open Database Connectivity (ODBC). Site: www.15seconds.com
|
||
|
|
|
|
|
|
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
|
||
|
|
|
|
|
|
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
|
||
|
|
|
|
|
|
ASP / Database Integration By centralizing database code within ActiveX DLL's, you can simplify your development efforts, and decrease the learning curve for new developers. In this article, we will create a Visual Basic ActiveX DLL that controls database functionality for our Active Server Page (ASP) demo. Site: www.asp101.com
|
||
|
|
|
|
|
|
ASP / Web Forms Dictionary object is an useful object to store any form of data in an array list. Following asp script block stores all data coming from a form and list them in our HTML codes. Site: www.dotnetindex.com
|
||
|
|
|
|
|
|
ASP / General Development The Dictionary object is used to store name/value pairs (referred to as the key and item respectively). The Dictionary object is like an associative array, but with its own built-in functionality that looks after the basic tasks of storing and manipulating the data, and sizing for the required number of elements. Each item in the Dictionary object is associated with a unique key. The key is used to retrieve an individual item. We don't have to worry about which row or column the data is in, we just access it using a unique key. Site: www.webcheatsheet.com
|
||
|
|
|
|
|
|
ASP / Database Integration Here is an invaluable program that you can use to view and control the presentation of records in your database. We will use the Recordset object and the MaxRecords property via ADO, to set the number of records to return to the recordset and therefore to your screen. This is like a table in memory, holding records which are subdivided into individual fields. |
||
|
|
|
|
|
|
ASP / Database Integration 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.) Site: www.15seconds.com
|
||
|
|
|
|
|
|
ASP / Component Building This very important article describes in detail what you need to know to register / unregister ActiveX ( COM Component ) DLLs remotely using only plain ASP pages. Must read for all ASP developers. Site: stardeveloper.com
|
||
|
|
|
|
|
|
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
|
||
|
|
|
|
|
|
ASP / General Development This article discusses the usage of persistence with the Application object in detail. Explains when to use Persistence, advantanges and disadvantages of using Persistence, and what types of data exchanges are targets for optimization and the benefits and disadvantages of using persistence with the Application object. Site: www.15seconds.com
|
||
|
|
|
|
|
|
ASP / File Operations The File object represents a specified file on the local machine or on a network share. To work with the File object's properties and methods, you need to create an instance of the FileSystemObject object first and then instantiate the File object through the GetFile method. Also you can get a File object reference from the Folder object, by using the Files Collection. Site: www.webcheatsheet.com
|
||
|
|
|
|
|
|
ASP / Database Integration This article looks at a neat and not often discussed feature of ADO - disconnected Recordsets. A disconnected Recordset, as its name implies, is a Recordset that lacks a connection. This may seem a bit confusing at first - how can a Recordset lack a connection to a data store? - but will hopefully become more clear as the article progresses. |
||
|
|
|
|
|
|
ASP / Database Integration We can use several providers to open DBF files usind ADODB. Basic way is to use ODBC data source (DSN or DSNless), there is several samples published on web. But how to open DBF files without ODBC? There are two other OLEDB providers, using which you can work with DBF files. Site: www.motobit.com
|
||
|
|
Site Search
Categories
Adobe Fireworks
Adobe Flash
Adobe Illustrator
Adobe Image Ready
Adobe Photoshop
3D Studio Max
Cinema 4D
Maya 3D
Microsoft Excel
Microsoft PowerPoint
Microsoft Word
Microsoft Access
MySQL
C and C++ 
Python
Visual Basic
.htaccess
Adobe DreamWeaver
ASP
CGI & Perl
CSS
Java
JavaScript
Microsoft FrontPageAdvertisement
|
|