ASP Database Programming
ASP Database Programming
Topics for this course
71 Lessons
ASP Database Programming
01 How to select Web Server to execute the ASP scripts
02 Where can I find the PWS or IIS software
03 Where can I find the Free NT Web sites or Economic NT Web hosting service
03 How can I install the PWS into the PC
04 How to start using the PWS
05 How to start writing your first ASP script
06 How to test my first ASP scripts in my PC
07 How can I add the sub directory to the PWS
08 How to create a DSN (Data Source Name)
09 What we need while using database in ASP
10 How to connect to database by using ADO connection
11 How to connect to database by using DNS
12 How to create a Table by using ADO Connection and SQL commands
13 How to delete a table from database
14 How to add a new column into a table
15 How to delete a column in a table
16 How to cancel the connection if the ADO Connection had no response
17 How to close an ADO Connection
18 How to use the ADO Connection object to perform a Transaction
19 How to use the ADO Recordset to query the records
20 How to close the ADO Recordset
21 How to get the value from each field in table
22 How do we know the current bookmark is pointing to which record while opening a table
23 How to use the Move method to get the record in a set of information
24 How to use an optional method to move the current bookmark location
25 How to check the number of records in the RecordSet
26 How to list out all the records in the table
27 How to find out the records that match your requirement
28 How can we know the total of fields (or column) in the table
29 How to get each of the field type
30 How to add a new record to the database
31 How can we know the Recordset is process Add function currently
32 How to add an array value to the Recordset
33 How to cancel the Add function in the ADO Recordset
34 How to add a new record by using SQL
35 How to detect the error while using the ADO
36 How to select the only information that we want to show to the user
37 How to clear the Filter Setup
38 How to select the record which we want to show by using SQL
39 How to know if the current recordset can be updated
40 How to modify the current record
41 How to update record by using SQL Command
42 How to delete a record in Recordset
43 How to delete a record by using SQL command
44 How to delete all records in Recordset
45 How to delete all records by using SQL
46 How to get the total of records that have been deleted
47 How to sort the records in Ascending or Descending
48 How to clear the Sort Properties
49 How to sort the record by using SQL command
50 How to select the top 10 records by using SQL
51 How to get the total amount in fields
52 How to count the total record queried by SQL_
53 How to get the minimum value in the same column
54 How to get the Maximum value in the same column
55 How to get the first record by using SQL
56 How to execute batch updates with ADO
57 How to transfer the table (in a recordset) into the array
58 What can I do if the error Too-Few-Parameters occurred
59 What can I do if error Cannot-Find-Input-Table occurred
60 What can I do if this error Fetching-Backward occurred
61 What will happen if I save the data in different datatype
62 What will cause error Data-Type-Mismatch while using this SQL
63 How to solve the LockType problem in ASP scripts
64 Discussion Board – How to create an Access database
65 Discussion Board – How to post the first Discussion
66 Discussion Board – How to avoid the user from sending an incomplete form
67 Discussion Board – How to save the ASP form
68 Discussion Board – How to create an index of the discussion
69 Discussion Board – How to show the details of the discussion
70 Discussion Board – How to delete the discussion
About the instructor
69 Courses
6 students
Free