str="select * from 老师表 where 学校ID=" + dropdownlist1.SelectedValue.Tostring Dim DA as New SqlDataAdapter(str,conn) dim DS as new dataset DA.fill(DS) dropdownlist2.datasource=ds dropdownlist2.DisplayMember=“老师名称” dropdownlist2.ValueMember=“老师ID” dropdownlist2.databind()
Dim DA as New SqlDataAdapter(str,conn)
dim DS as new dataset
DA.fill(DS)
dropdownlist2.datasource=ds
dropdownlist2.DisplayMember=“老师名称”
dropdownlist2.ValueMember=“老师ID”
dropdownlist2.databind()