asp.net中的 dropdownlist 在oracle数据库中的动态生成问题(急急急急)
大哥或者大姐能帮我改改下面的程序,让我实现动态生成dropdownlist,拜托了,下面的程序老是出现如下的错误:“:“System.Data.DataRowView”不包含名称为 车辆类型 的属性。”
function loaddataview() as dataview
dim m_connection as OleDbConnection
dim string1,sql as string
dim m_DataSet as DataSet
string1="Provider=OraOLEDB.Oracle.1;Password=clgl;User ID=clgl;Data Source=clgl;"
m_Connection = new OleDbConnection(string1)
m_Connection.Open()
dim m_DataAdapter as OleDbDataAdapter
sql="select CLLX_CLLX from TAB_CLLX"
m_DataAdapter = new OleDbDataAdapter( sql, m_Connection )
m_DataSet = new DataSet()
m_DataAdapter.Fill( m_DataSet,"TAB_CLLX" )
loaddataview=new dataview(m_dataset.tables("TAB_CLLX"))
end function
sub page_load(byval sender as object,byval e as eventargs)
ddl.DataSource=loaddataview()
ddl.DataTextField="车辆类型"
ddl.DataValueField="CLLX_CLLX"
ddl.DataBind()
end sub