我的datagrid查询所有就显示,查询部分不显示,这是怎么回事请大哥哥们指导!
下面是代码
Dim sqlconn As New SqlConnection("data source=03068AD0B34B4DE;initial catalog=bumen;uid=sa;pwd=;")
sqlconn.Open()

Dim cmd1 As New SqlCommand("select ryname from ry where rybm='ddlbm.selectedindex'", sqlconn) *用这行就不能显示查询,(其中ddlbm为下拉列表框)
' Dim cmd1 As New SqlCommand("select * from ry", sqlconn) *用这行就能在datagrid中全部显示
Dim sdr1 As SqlDataReader
sdr1 = cmd1.ExecuteReader()
DataGrid1.DataSource = sdr1
DataGrid1.DataBind()

sdr1.Close()
sqlconn.Close()
请问以上是怎么回事 急啊....

ddlbm.selectedindex -->>什么东西
ddlbm.selecteditem.Value-->下拉框value值
ddlbm.selecteditem.text-->下拉框Text值

你應該這樣試試
Dim cmd1 As New SqlCommand("select ryname from ry where rybm='"+ddlbm.selectedindex+"'", sqlconn)

问题就出在我的dropdownlist的text的获取上,我的dropdownlist中的值也是通过数据库绑定出来的,就是选择不了这个值
dropdownlist的绑定在这里 还请指点...
If Not Page.IsPostBack Then
Dim sqlconn As New SqlConnection("data source=03068AD0B34B4DE;initial catalog=bumen;uid=sa;pwd=;")

sqlconn.Open()
Dim cmd As New SqlCommand("select * from ry", sqlconn)

Dim sdr As SqlDataReader
sdr = cmd.ExecuteReader()

ddlbm.DataValueField = "rybm"

ddlbm.DataSource = sdr
ddlbm.DataBind()
sdr.Close()
sqlconn.Close()
End If

带加号的不行啊

'ddlbm.selectItemValue

还是查不出来啊  和数据库有什么关系吗?

换成这样 Dim temp As String
temp = ddlbm.SelectedValue
Dim da As New SqlDataAdapter("select ryname,ryage from ry where rybm='" + temp + "'", sqlconn)
解决问题!
结帖!谢谢各位