dropdownlist绑定数据库有问题

[Amberilee]

将dropdownlist绑定数据库的某列，运行后dropdownlist下拉却显示若干个“System.Data.DataRowView”,该列有多少项dropdownlist就显示多少个“System.Data.DataRowView”。
我把代码写在下面，请达人进来看看哪有问题。

dim dt as datatable
sub page_load(sender as object,e as eventargs)
dim provider,SQL,ConnStr as string
provider="microsoft.jet.oledb.4.0;"
ConnStr = "Provider="+Provider+"Data Source="+server.mappath("/db/Workers.mdb") +";Persist Security Info=False;User ID=;Jet OLEDB:Database password=123"
SQL="select * from Profession"
dim cmd as oledbdataadapter
cmd=new oledbdataadapter(SQL,ConnStr)
dim ds as dataset=new dataset()
cmd.fill(ds,"profession")
dt=ds.tables("profession")
dropProfession.datasource=dt
dropProfession.DataTextField = "职业"
dropProfession.DataValueField = "ID"
dropProfession.databind
end sub

**************************************************
<asp:DropDownList runat="server" Height="18px" Width="148px" ID="dropProfession" AutoPostBack=True></asp:DropDownList>

[njmaxiang]

好像没有连接对象

[lovefootball]

DataView dv = new DataView(dt);
dropProfession.datasource=dv

[working1997]

试了一下，没问题啊

[jimu8130]

你的sql语句是否是select "职业"，id from database ?
如果不是那么是因为你的查询字段和绑定字段不一致

[jimu8130]

绑定的字段得在sql语句中的查询字段相同