Tutorials to .com

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

ASP Database Related Articles


101: ADO events (4) --- FetchComplete (RecordsetEvent) method
FetchComplete (RecordsetEvent) method This method is asynchronous in the long record of operations has been restored to all (access) to the recordset after the call. Syntax FetchComplete pError, adStatus, pRecordset Syntax pError Error object, ...

102: ADO events (5) --- FetchProgress (RecordsetEvent) method
FetchProgress (RecordsetEvent) method The method in a long time during the regular operation of the asynchronous call has been restored in order to report the current (access) to the Recordset in the number of rows. Syntax FetchProgress Progress,...

103: ADO events (6) --- InfoMessage (ConnectionEvent) method
InfoMessage (ConnectionEvent) method During operation in ConnectionEvent, in the event of a warning to call the method. Syntax InfoMessage pError, adStatus, pConnection Parameters pError Error object. This parameter contains any errors were ret...

104: ADO events (7) --- WillChangeField and FieldChangeComplete (RecordsetEvent) method
WillChangeField and FieldChangeComplete (RecordsetEvent) method Hang WillChangeField method of operation of the Recordset object to one or more of the value of Field before the call to make changes. FieldChangeComplete method in one or more Field o...

105: ADO events (8) --- WillChangeRecord and RecordChangeComplete (RecordsetEvent) method
WillChangeRecord and RecordChangeComplete (RecordsetEvent) method Recordset Methods WillChangeRecord one or more records (lines) before the call to change. Methods RecordChangeComplete record in one or more changes after the call. Syntax WillChan...

106: ADO events (9) --- WillChangeRecordset and RecordsetChangeComplete (RecordsetEvent) events
WillChangeRecordset and RecordsetChangeComplete (RecordsetEvent) events Method of operation in WillChangeRecordset hang before the call to change the Recordset. RecordsetChangeComplete method call in the Recordset changes. Syntax WillChangeRecord...

107: ADO events (10) --- WillConnect (ConnectionEvent) Method
WillConnect (ConnectionEvent) Method This method is called before the connection. In connection hang parameters will be used as input parameters, and can make changes before the method returns. This method can return to the abolition of hanging con...

108: ADO events (11) --- WillExecute (ConnectionEvent) method
WillExecute (ConnectionEvent) method The method in the implementation of the connection before the call to suspend the order, and allows the user to check and modify the implementation of parameters hang. This method can return to the abolition of ...

109: ADO events (12) --- WillMove and MoveComplete (RecordsetEvent) method
WillMove and MoveComplete (RecordsetEvent) method Suspend the operation WillMove method to change the Recordset of the current position before the call. MoveComplete methodology of the current position in the Recordset changes call. Syntax WillMo...

110: A comprehensive solution - how to get just the records inserted into the database ID number?
How do I get just inserted database record ID number? 1.SQL Server For SQL Server 2000, it provides two new functions (IDENT_CURRENT, SCOPE_IDENTITY), and improved less than the @ @ IDENTITY. When you insert a new record, you can call the function...

111: Database lists all of the Trigger, Store Procedure
<% dbname = "databasename" ConnStr = "provider = SQLOLEDB; network = DBMSSOCN;" ConnStr = ConnStr & "uid = <uid>; pwd = <pwd>; server =" ConnStr = ConnStr & "<IP Address>; database ...

112: Tried a database listing all the primary key it?
<% dbname = "databasename" ConnStr = "provider = SQLOLEDB; network = DBMSSOCN;" ConnStr = ConnStr & "uid = <uid>; pwd = <pwd>; server =" ConnStr = ConnStr & "<IP Address>; database ...

113: Without DSN database access ISP plate
Unless you use Telnet Logon ISP's server software, otherwise there is no way you connect to database through DSN. Here are several methods to connect to let you go beyond your ISP and the space between the distance, so that you connect to the da...

114: ASP to connect Access database several ways!
1. set dbconnection = Server.CREATEOBJECT ( "ADODB.CONNECTION") DBPath = Server.MapPath ( "customer.mdb") dbconnection.Open "driver = (Microsoft Access Driver (*. mdb)); dbq =" & DBPath SQL = "select * from...

115: CursorLocation property
Set or return the location of the cursor service. Set-up and return value Set or return the following can be set to a constant value of long integer. Constant Description adUseNone do not use cursor services. (The constant is outdated and only f...

116: ASP calling Oracle stored procedure
I, ASP dynamic web site development technology With the deepening of understanding of Internet and IT technology, static static pages of information have become increasingly unable to meet the needs of interactive and e-commerce, and therefore the...

117: Summary of asp to access the data source 1 (carried over documents IIS5.0)
Access to data source ActiveX Data Objects (ADO) is an easy-to-use but also the expansion of the technology, used to add database access to your Web page can use ADO to prepare concise and scalable script to connect to compatible with the OLE DB da...

118: asp access 2 Summary of data sources (documents carried IIS5.0)
Recordset object using the results In order to retrieve data, inspection results and to change the database, ADO provides a Recordset object. As the name implies, "Recordset" object with the database used to retrieve and display lines (or...

119: Class A Class to connect database
Option Explicit 'local variable (s) to hold property value (s) Private lsServer As String 'local copy Private lsDatabase As String 'local variable (s) to hold property value (s) Private lsUserName As String 'local copy Private ...

120: Access database will be migrated to Microsoft SQL Server 7.0
Abstract: This paper describes the Access database will be converted to SQL Server database and tools Introduction As users of high-performance enterprise-class database for the growth in demand, the user often from the Microsoft Access Jet engine...


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