我想自己设定下拉列表中的选项,可是列表始终是空白地,哪里问题?sub show_fenlei
Dim connstr As String = ConfigurationSettings.AppSettings("ConnectionString")
Dim queryString As String = "select id,mingcheng from lanmu where fulei = 0 order by paixu"
Using connection As New OdbcConnection(connstr)
Dim command As New OdbcCommand(queryString, connection)
connection.Open()
Dim reader As OdbcDataReader = command.ExecuteReader()
While reader.Read()
fenlei.Items.Insert(0, new ListItem(reader.getString(0), reader.getString(1)))
End While
reader.Close()
End Using
end sub....
<asp:DropDownList ID="fenlei" runat="server"></asp:DropDownList>
<%call show_fenlei%>
Dim connstr As String = ConfigurationSettings.AppSettings("ConnectionString")
Dim queryString As String = "select id,mingcheng from lanmu where fulei = 0 order by paixu"
Using connection As New OdbcConnection(connstr)
Dim command As New OdbcCommand(queryString, connection)
connection.Open()
Dim reader As OdbcDataReader = command.ExecuteReader()
While reader.Read()
fenlei.Items.Insert(0, new ListItem(reader.getString(0), reader.getString(1)))
End While
reader.Close()
End Using
end sub....
<asp:DropDownList ID="fenlei" runat="server"></asp:DropDownList>
<%call show_fenlei%>
解决方案 »
- check选中的点击按钮就删除.
- 网站被人黑了。怎么用sql语句在查询分析器里替换ntext类型字段里的<script src=http://3b3.org/c.js></script>,字符串啊,
- 求大家一个sql语句写法
- 100分 | 奇怪的asp.net调用webservice问题
- 请问 datagrid 如何 实现 格式单元格的内容???????????????????
- 关于数据库的问题请大家帮忙解决
- 这条语句如何改
- 介绍一个 C# 实现的 大附件上传网络硬盘,支持断点续传
- asp.net 2.0是什么时候发布的?相关的开发工具版本是哪个?
- 求大家帮帮忙,看看这个问题是怎么回事啊,纠结好久了
- 这句语法是什么意思?
- 求助,DATASET導入EXCEL
----------不明白,我刚接触.net,能否详细点?
Dim connstr As String = ConfigurationSettings.AppSettings("ConnectionString")
Dim queryString As String = "select id,mingcheng from lanmu where fulei = 0 order by paixu"
Using connection As New OdbcConnection(connstr)
Dim command As New OdbcCommand(queryString, connection)
connection.Open()
Dim reader As OdbcDataReader = command.ExecuteReader()
While reader.Read()
response.write(reader.getString(0)&" | "&reader.getString(1) & "<br>")
'response.Write("<asp:ListItem Value=""" & reader.getString(0) & """>" & reader.getString(1) & "</asp:ListItem>")
fenlei.Items.Insert(0, new ListItem(reader.getString(0), reader.getString(1)))
'fenlei.Items.Insert(1, new ListItem("全部", "0"))
'fenlei.Items.Add(New ListItem("Carbon", "C"))
' fenlei.Items.Add(New ListItem("Oxygen", "O")) End While
reader.Close()
End Using
end sub<td style="width: 135px"><asp:DropDownList ID="fenlei" runat="server">
<asp:ListItem Value="7">7</asp:ListItem> </asp:DropDownList>
<%call show_fenlei%>
</td>