Tutorials to .com

Tutorials to .com » Asp » ASP Database Related

ASP Database Related Articles


1: Arabic numerals the amount of conversion of the stored procedure for the Chinese
Create Procedure AtoC @ ChangeMoney Money as Set Nocount ON Declare @ String1 char (20) Declare @ String2 char (30) Declare @ String4 Varchar (100) Declare @ String3 Varchar (100) - from the original A value out of the value of Declare @ i i...

2: Application database unique constraint and capture asp database errors
This article mentioned in the asp page, with the exception of special statements, refer to <@ PAGE LANGUEGE = "VBSCRIPT"> Asp and the database to write the combination of the program, often encountered the same data table are not al...

3: The implementation of DTC with asp
DTC in SQL SERVER is a very useful tool, it allows you to automate the import, export, query, insert, such as a series of data manipulation, we can also call asp He is now my demo for everyone to see New stored procedure ______________________ CR...

4: Data Shaping technology - the necessary configuration data providers
Configuration data providers generally require two. OLE DB service provider of data services configuration data configuration features, and data providers, such as SQL Server's OLE DB provider, will provide data filling line forming Recordset. ...

5: Data Shaping technology - Data configuration
ADO allows you to answer the answer can be expressed as Recordset question. For example, suppose you want a list of corporate clients, and you have a Customers table contains the name of the database. Query command issued on the table, then ADO will...

6: PivotChart and PivotTable functionality expansion
Wes Kim Microsoft Corporation April 2001 Apply to: Microsoft ® Access 2002 Abstract: how to use the incident to the expansion of Microsoft Access 2002 in PivotTable view and PivotChart view function. Contents Introduction The location o...

7: Data access page to bind to the disconnected recordset
Meyyammai Subramanian Microsoft Corporation April 2001 Apply to: Microsoft ® Access 2002 Abstract: This paper explains how data access pages will be bound to the ADO disconnected recordset. Contents Introduction Create a record of the u...

8: Online maintenance of the database using ASP
With the development of the Internet in a networked environment, the database application gradually to the simple, functional and practical direction. This article describes how to use ASP technology to achieve Online database maintenance method of...

9: In ASP using Oracle Object for OLE visit Oracle 8
ASP (Active Server Pages) is Microsoft for the development of Internet applications made by one of the tools, it is a similar to HTML (Hypertext Markup Language HTML), Script and CGI (Common Gateway Interface Common Gateway Interface) combination, ...

10: Compress and repair Access databases (recommended)
Compact and Repair You can use the "Compact and Repair" function in Access from ASP code. The following code is an example of how this can be done. Note that when you decide to "Compact and Repair" your Access database, some a...

11: Using ASP to access a variety of commonly used type of database (4)
Using ASP to access a variety of commonly used type of database (4) DBPath = "SourceDB =" & Server.MapPath ( "DBC database file name") 'Connect to database conn.Open Driver & SourceType & DBPath Set CreateDbcR...

12: Access database table read example
8/30/2001 12:28:41 PM in kendylan add Joy ASP ← return to the page: <% strConn = "DBQ =" + server.mappath ( "kendylan.mdb ")+"; DefaultDir =; DRIVER = (Microsoft Access Driver (*. mdb));" set objConn = server.cr...

13: ASP code to restore database
Document 4: RestoreDB.asp <% @ Language = VBScript%> <HTML> <HEAD> <META Name=VI60_defaultClientScript content=VBScript> <META NAME="GENERATOR" Content="Microsoft FrontPage 4.0"> <SCRIPT ID=...

14: Online Access database compression
While working on BuildDB / Buildapp online Demo, I developed a little function that will compact Access databases over the web. Here's a "no-frills" page that'll compact the databases for you. One problem with Access databases is ...

15: Using ASP to access a variety of commonly used type of database (1)
Abstract: This article discusses the use of ASP to access DBF, DBC, MDB, Excel, SQL Server-based data and function, and finally give a use of the function This article provides database access to Excel example, the reuse and sharing of enterprise d...

16: Using ASP to access a variety of commonly used type of database (2)
Microsoft Excel Driver Excel Microsoft Visual FoxPro Driver Dbc SQLOLEDB.1 SQL Server7.0 Second, connect the database and open the data table Different database connection methods are different (that is, the establishment of Connection as an exa...

17: Using ASP to access a variety of commonly used type of database (3)
Function CreateSecuredMdbRecordset (database files, and data sheets or Select statement, password) Dim conn, Provider, DBPath 'Connection object the establishment of Set conn = Server.CreateObject ( "ADODB.Connection") Provider = &...

18: odbc and ole db database in connection What is the difference?
It is worth noting that, OLE DB for ODBC compatibility allows OLE DB access to existing ODBC data source. The advantage is clear, as the OLE DB for ODBC is relatively more widespread use, the ODBC drivers available than corresponding to the number o...

19: Stored procedure on page
Saw a few friends to write stored procedures on the article page, feeling a little problem. Spider starleee and eastern wish I could express views, to put it simply click. The first is that the paging method allsky do not set up to see if he is lik...

20: A theory the fastest Web database paging method
Part of the database we are talking about three types of traditional paging methods and their advantages and disadvantages, and a paging method in theory the best, this we have to explain in detail on this page the best method. One: the idea. Web ...


Page 1 of 32
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]