I want to pass values dynamically to a dropdownlist from a result of an ado.net connection.


        Dim ftname, fttown As String
        ftname = Session("town")
        fttown = Session("street")

        Dim conn, rs1, sql, dbread
        conn = CreateObject("ADODB.Connection")
        conn.Provider = "Microsoft.Jet.OLEDB.4.0"
        conn.Open(Server.MapPath("maps1_old.mdb"))
        rs1 = Server.CreateObject("ADODB.recordset")
        sql = "SELECT DISTINCT a, x, y FROM maps111 where name LIKE '" & ftname & "%' AND town ='" & fttown & "' "
        rs1.Open(sql, conn)

     

        Dim rname, rx, ry As String


        On Error Resume Next
        rs1.MoveFirst()
        Do While Not rs1.eof
            rname = rs1("a")
            rx = rs1("x")
            ry = rs1("y")


       
            dlist.Items.Add(rname)

            rs1.MoveNext()

       
        Loop

        conn.Close()
        rs1.Close()
        conn = Nothing
        rs1 = Nothing

    End Sub


This code only sows the dropdownliast but doesnt populate with the result.

try to refresh the recordset.
and let me know what happen

nothing happen bro!

You forgot to Bind the Datasource to your dropdownlist.

Best you learn to work with DataReaders and DataSets

You return a DataSet and just bind the DataTable to your list object eg

'Databind the DataReader to the listbox Web control

lstFAQs.DataSource = objDR
lstFAQs.DataBind()

@Kobo

I am using an oledb connection, does this use datareaders and datasets?

U may be right there, because my approach was using recordset which is classic ASP.

Even if you are not going to use DataReader, Dataset or even tables or any other of that sort, you still need to call Databind on your dropdownlist

Look at this example

http://www.4guysfromrolla.com/ASPScripts/PrintPage.asp?REF=%2Fwebtech%2F073101-1.shtml

@kobo

You are now officially I_laugh's wife - thanks.

So, is the problem solved?

@Big Star.

Yes, it is solved. Kobojunkie's name is now KoboGenius.


And she is now I_laugh's wife.