集合对象也可以当成数据源使用。例如datatable 中的rows 集合,也可以当作数据源让控件系结。下列范例利用dropdownlist web 控件将我们在第五章所建立的members 数据表中的columns 集合当成数据源使用:
<%@import namespace=system.data.ado%>
<%@import namespace=system.data%>
<html>
请选择一个字段:
<asp:dropdownlist id="ddla" runat="server"/>
<script language="vb" runat="server">
sub page_load(sender as object, e as eventargs)
dim strconstr as string = "provider=microsoft.jet.oledb.4.0;" & _
"data source=c:\inetpub\wwwroot\cr\ch05\myweb.mdb"
dim strcomstr as string = "select * from members"
dim dsca as adodatasetcommand = new
adodatasetcommand(strcomstr,strconstr)
dim dsdataset as dataset = new dataset()
dsca.filldataset(dsdataset, "members")
ddla.datasource=dsdataset.tables("members").columns '将columns 集
合当成数据源
page.databind()
end sub
</script>
</html>