readcontent11 폼

    <html>
    <body>
    
    <form method="post" action="readcontent22.asp">
    <table border="2">
    
    <caption>
    Enter Employee ID Number  
    </caption>
      <tr>
         <td>Employee ID:</td>
         <td><input type="text" name="txtEID" size="47"</td>
      </tr>
    
      <tr>
         <td></td>
         <td><input type="submit" name="btnsubmit" value="Submit"></td>
      </tr>
    </table>
    </form>
    
    </body>
    </html>

     

    readcontent22 만든거 블러오기 폼 불러오기

    <html>
    <body>
    
    <%
    
    X1 = CInt(Request.Form("txtEID"))
    
    
    Set Conn = Server.CreateObject("ADODB.Connection")
    Conn.ConnectionString = "DSN=win.dsn"
    
    Conn.Open
    
    Set Rs = Server.CreateObject("ADODB.Recordset")
    
    Rs.Open "Select * From tblEmployees Where EmployeeID="& X1 &";",Conn
    %>
    
    
    
    <ul>
      <li><b>Category ID:   </b> <%=Rs("EmployeeID")%> </li>
      <li><b>Category Name: </b> <%=Rs("FirstName")%> </li>
      <li><b>Description:   </b> <%=Rs("HireDate")%> </li>
    </ul>
    
    <%
    Rs.close
    set Rs=nothing
    Conn.close
    Set Conn=nothing
    %>
    
    </body>
    </html>
    
    
    

    • 네이버 블러그 공유하기
    • 네이버 밴드에 공유하기
    • 페이스북 공유하기
    • 카카오스토리 공유하기
    loading