DROPDOWNLIST is bound to not data, only display system.data.DataRowView

wangyyyaa

I put the code out, and I saw it wrong.??

IF not ispostback.
            DIM Astr As String
            astr = "Select AutherName from Picture"
            DIM CMD1 AS New Sqlcommand (Astr, Conn)
            Conn.open ()
            DIM ADP AS New SqldataAdapter (cmd1)
            DIM DS AS New DataSet
            ADP.FILL (DS, "Picture")
            DROPDOWNLIST1.DATASOURCE = ds.tables (0) .defaultView
            DropDownList1.Database
            DropdownList1.DataTextField = "Authername"
            DROPDOWNLIST1.DATAVALUEFIELD = "PID"
            CONN.CLOSE ()
        END IF

xwgjyhl

DropdownList1.DataTextField = "Authername"
            DROPDOWNLIST1.DATAVALUEFIELD = "PID"
DropDownList1.Database
You are going back.

xwgjyhl

Post DataBind, first specify text and value

wangyyyaa

Thank you, I will try it.

wangyyyaa

Ok, thank you\, but there is a problem, it is a few as a few Authername in my table, which is displayed in DropDownList, I want it to display only one, what??????????

若水淡淡

astr = "Select Distinct Authername from Picture"

kalian2000

astr = "Select AutherName from Picture"

->

Astr = "Select Distinct Authername, Pid from Picture"

kalian2000

TO: DROPDOWNLIST1.DATAVALUEFIELD = "PID"

You didn't find the PID, how to bind?

ghjwow

Select Distinct Authername, PID from Picture

wangyyyaa

Everything is OK, thank you ~ `