Member Avatar for abhay1234
abhay1234 0 Light Poster

heres the code

<%@ Page AspCompat ="true"  %>

<html xmlns="http://www.w3.org/1999/xhtml" >
<body> 
 <% dim adoconn
    Dim rsnikhil
dim ssql%>
     <%adoconn = Server.CreateObject("ADODB.Connection")%>
     <%adoconn.Open("Provider=Microsoft.Jet.OLEDB.4.0;DataSource=c:\nikhil.mdb;")%>
  

  <%  rsnikhil = Server.CreateObject("ADODB.Recordset")%>
 <%ssql = "SELECT * FROM kulkarni"
     rsnikhil.open(ssql, adoconn) %>
<%
Do While not rsnikhil.EOF
Response.Write(rsnikhil("name"))
Response.Write(rsnikhil("comments"))

rsnikhil.MoveNext
 
loop %> 
<%
     rsnikhil.close()
    rsnikhil = Nothing
    adoconn = Nothing

%>
</body>
</html>
  • 1 Contributor
  • 0 Replies
  • 54 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.