insert asp

Insert ASP Code

<% Dim Category 
Dim Description 
Dim cn 
Dim sql 
Category = request.form("txtCategory") 
Description = request.form("txtDescription") 
Set cn = Server.CreateObject("ADODB.Connection") 
cn.Open "NorthWindDSN" 
sql = "INSERT INTO Categories (CategoryName, Description) "  
sql = sql & " values( '" & Category & "' , '"  
sql = sql & Description & "' )" 
cn.Execute(sql) 
Response.write "You have successfully inserted a new record." 
cn.Close 
Set cn = nothing %> 

 Click Next for amend-select.asp 

1. Installing the Personal Web Server (PWS)
2. or Internet Information Services (IIS)
3. Create the Example ASP Files
4. Create a DSN Connection
5. Connect to the Database
6. Modify Access Data Online
7. Inserting Data
8. Modifying Data
9. Deleting Data
10. Data Insert Form

Enable GingerCannot connect to Ginger Check your internet connection
or reload the browserDisable in this text fieldEditEdit in GingerEdit in Ginger×