Tutorials to .com

Tutorials to .com » Asp » Database » ASP Database Related

ASP Database Related Articles


21: Approach on the page
Of time, has not been fully tested, this is probably meant. CREATE PROCEDURE getnotes @ forumID varchar (10), @ a_intPageNo int, @ a_intPageSize int, @ rootID varchar (10) AS declare @ m_intRecordNumber int declare @ m_intStartRecord int de...

22: How to use asp to sql server data into execl document
1, ASP documents: <% @ LANGUAGE = "VBSCRIPT"%> <% Option explicit%> <% 'EXAMPLE AS: the database of a number of people online 24 hours a day, in a file to EXCEL 'AUTHOR: iron and steel workers 'EMAIL: hello...

23: How to use database storage file
In SQL Server which has a data type for its Image, in addition it can store files can be stored outside the binary of large data files, this field most of the people is heard by the film but I do not know how to use today the article will be to disc...

24: Sql Table Data Manipulation
Table data manipulation, including data to insert, modify and delete. First, insert the data Add to the data sheet should pay attention to two points: first, user rights, and only members of sysadmin angle package, database and database As owners...

25: How to get the current sql database where the name of
* Bean products are produced Tofu http://www.asp888.net technical points If reproduced, please retain the copyright information * / User problem reads as follows: Here are a few of the issues on the SQL SERVER you would like to ask (server-sid...

26: Disconnect the database connection examples
The use of disconnected Recordset is a key condition for the client to use a temporary table, that is, Designated Rs.CursorLocation = adUseClient or 3, the following is a complete Examples: demo-1.asp (online demonstration: http://www.aspcn.com/d...

27: A composite query methods
Almost every application will complete the need for a complex query. The establishment of a powerful composite query first to be able to dynamically Query generation, followed by the query should be able to modify the data, the last of the inquiry ...

28: The image is stored in the field of SQL7 documents to the client to download the source code of the ASP
The image is stored in the field of SQL7 documents to the client to download the source code of the ASP File name: download.asp Usage: download.asp? Fid = xxx Description: SQL7 the storage of the image field to download the document to the client...

29: Ado connection with Informix data
Original Address http://examples.informix.com/white_papers/appeng/3rd_party/ado_iis/ado_iis_note_ibyx.html -------------------------------------------------- --------------------- Using ADO with IIS to connect to an Informix Database Introductio...

30: How to display the database structure of the source code
The above code to display the table structure, field types, length, auto-ID, the main health. If you can be found after careful study of how the remote to change the structure of the database, and I wish you good luck! To view this demonstration, y...

31: How to read from the ACCESS database graphics (continued)
Note that you can from one document to create a new bitmap object, but the use of such Stored in the database of the graphics format in the browser can not be identified. When you save images to the database, you should know what format you need t...

32: Data Shaping technology - visit the grading of the line Recordset
The following example illustrates hierarchical Recordset visit the firm steps required: authors and titleauthors table through the Recordset object to relevance author ID. Outside the circle shows that each author's name, state / province, and...

33: Data Shaping Technology - Shape Append command
Shape APPEND command will be assigned to parent Recordset son Recordset object in the Field of Value attribute. Syntax SHAPE (parent-command) [[AS] parent-alias] APPEND ((child-command) [AS] child-alias RELATE parent-column TO child-column ...) ...

34: See some of the ASP is not long stored procedure call techniques
1, the simplest is as follows Dim objConn Set objConn = Server.CreateObject ( "ADOBD.Connection") objConn.Open Application ( "Connection_String") 'Call the stored procedure to increment a counter on the page objConn.Exec...

35: WebComputing ━ ADO Final Report 1
In today's dynamic pages to a variety of (Dhtml) solutions have stressed the importance of connecting with the database, in fact, the page the background database is then linked to the current popular applications in areas such as in e-commerce ...

36: WebComputing ━ ADO Final Report 2
Second, Connection object: In the ADO model, Connection object is the most basic object is to provide him with the database. The other two objects with the database through the connection to complete the operation. Its properties, methods are as fo...

37: WebComputing ━ ADO Final Report 3
Third, Error object: As described above, the Connection object is used for various types of databases and articulated, but in this process there will be some unpredictable error, which has been the object Error. First of all, a concept to make it c...

38: WebComputing ━ ADO Final Report 4
IV, Command object: From the literal meaning of English can be seen, Command is used to do parameter command execution and delivery. Command object and pass the bulk parameters, StoredProcude so flexible and powerful implementation of the function ...

39: WebComputing ━ ADO Final Report 5
5, StoredProcedure StoredProcedure in the discussion, I also wish to the Execute method of Command object to click on the role, as a general rule to use the Execute method of Command has three purposes. 1, for a number of simple processing, such as...

40: WebComputing ━ ADO Final Report 6
6, RecordSet object Wrote this article, I can not help but think of the sages of the two sentences, one is cut Cao debate in Mencius said: big bang, and then decline, three and exhaust. ADO in this part of the final report of the first five are for...


Page 2 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]