📄 sample.asp

📁 Web based project,kisan online

💻 ASP

字号:

<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<%
 set con= Server.CreateObject("ADODB.Connection")
  con.Mode = 3
  set rs = server.CreateObject("ADODB.Recordset")
  con.ConnectionString =" Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\Inetpub\wwwroot\admin1_files/db.mdb"
   con.Open
   query = "select * from customer"
      rs.Open query,con,1,3 
      rs.MoveFirst 
      Response.Write("First Name")
      Response.Write(" &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp")
      Response.Write("Last Name")
      Response.Write(" &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp")
      Response.Write("Joining date")
      Response.Write(" &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp")
      Response.Write("Address")
      Response.Write(" &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp")
      Response.Write("Mobile Number")
      Response.Write("<br>")
      while not rs.EOF 
      Response.Write rs.Fields(0)
      Response.Write ("&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp")
      Response.Write rs.Fields(2)
      Response.Write ("&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp")
      Response.Write rs.Fields(3)
      Response.Write ("&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp")
      Response.Write rs.Fields(4)
      Response.Write ("&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp")
      Response.Write rs.Fields(5)
       Response.Write("<br>")  
         rs.MoveNext 
         wend
         

%>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -