We are excited to announce that the IIS.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

View Complete Thread
  • Re: Problem displaying database info on page

    Aug 22, 2005 04:43 PM|jforward5|LINK

    no this is the asp.net included in visual basic 7.0 i think it is asp.net 1.1.  but i figured that the code i used would work but i guess not.  here is my code:

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

    Dim oConn, oRs

    Dim qry, qry2, connectstr

    Dim db_name, db_username, db_userpassword

    Dim db_server

    Dim fieldname, tablename

    db_server = "whsql-v02.prod.mesa1.secureserver.net"

    db_name = "db_14122"

    db_username = "jforward5"

    db_userpassword = "jan1077"

    tablename = "users"

    connectstr = "Driver={SQL Server};SERVER=" & db_server & ";DATABASE=" & db_name & ";UID=" & db_username & ";PWD=" & db_userpassword

    oConn = Server.CreateObject("ADODB.Connection")

    oConn.Open(connectstr)

    qry = "select * from atlanta"

    oRs.oconn.execute(qry)

    If Not oRs.EOF Then

    While Not oRs.EOF

    Response.Write(oRs(0))

    Response.Write(oRs(1))

    Response.Write(oRs(2))

    oRs.movenext()

    End While

    oRs.close()

    End If

    oRs = Nothing

    oConn = Nothing

     

     

    End Sub

    what do i need to do to make it show the information in my db.  I know there is information in my db because i put it there manually.

    http://www.crackerjacksoftware.com
    CrackerJack Software, we solve computer problems!