5.8w+
社区成员
- 主页
- .NET Framework
- ASP
- Web Services
- .NET互联网桌面应用
- VB
- 图表区
- 分析与设计
- 组件/控件开发
- AppLauncher
- 问答
一个dropdownlist取值查询的问题
页面中有一个dropdownlist,绑定了一个表，显示表中一字段数据，现在想利用dropdownlist中显示的数据做为查询条件，click后，查询后得到的数据显示在datagrid中。可是怎么取出其值呢，老大们帮忙看目的地，以下是我的代码！
sub search_Click(sender as object , e as eventargs)
dim ds as dataset=new dataset
dim conn as oledbconnection
conn=new oledbconnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.mappath("/qkglxt/data/data.mdb"))
dim mycommand as oledbDataAdapter
dim flage as string="'" & dlHTLB.SelectedItem.Value & "'"
mycommand=new oledbDataAdapter("select * from expert where e_realm='"+flage+"' order by id desc",conn)
conn.open()
mycommand.fill(ds)
mydatagrid.datasource=new dataview(ds.tables(0))
mydatagrid.databind()
end sub
我将 dim flage as string="'" & dropdownlist.SelectedItem.Value & "'"
换成 dim flage as string="社科"
在e_realm字段中"社科"就全部在datagrid中显示出来了。
还有换成 dim flage as string=" & dropdownlist.Text & "也一样显示不出。
各位大侠，帮我把把脉吧！到底怎样将dropdownlist的值取出来做为查询条件呢！
sub search_Click(sender as object , e as eventargs)
dim ds as dataset=new dataset
dim conn as oledbconnection
conn=new oledbconnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.mappath("/qkglxt/data/data.mdb"))
dim mycommand as oledbDataAdapter
dim flage as string="'" & dlHTLB.SelectedItem.Value & "'"
mycommand=new oledbDataAdapter("select * from expert where e_realm='"+flage+"' order by id desc",conn)
conn.open()
mycommand.fill(ds)
mydatagrid.datasource=new dataview(ds.tables(0))
mydatagrid.databind()
end sub
我将 dim flage as string="'" & dropdownlist.SelectedItem.Value & "'"
换成 dim flage as string="社科"
在e_realm字段中"社科"就全部在datagrid中显示出来了。
还有换成 dim flage as string=" & dropdownlist.Text & "也一样显示不出。
各位大侠，帮我把把脉吧！到底怎样将dropdownlist的值取出来做为查询条件呢！
...全文
请发表友善的回复…
发表回复
sbxkpl 2004-04-26
呵呵。。。问题结决！结帖！谢谢各位了！
lkk2073 2004-04-26
语法没有错误...跟一下,看看flage和fla里面的内容是什么,再拿到查询分析器里去运行...
首先要学会跟踪程序,其次变量命名要规范...呵呵
首先要学会跟踪程序,其次变量命名要规范...呵呵
sbxkpl 2004-04-26
thanks!谢谢各位了！呵呵。。。。 好事做到底，还问一个，再加一个dropdownlist,用两个dropdownlist的值进行查询.如何进行呢！我用下面的语句and 不成功！马上结帖！
dim flage as string=dlHTLB.SelectedItem.Value
dim fla as string=dlHTDJ.SelectedItem.Value
mycommand=new oledbDataAdapter("select * from expert where e_realm='"+flage+"' and e_zhiwu='"+fla+"' order by id desc",conn)
conn.open()
dim flage as string=dlHTLB.SelectedItem.Value
dim fla as string=dlHTDJ.SelectedItem.Value
mycommand=new oledbDataAdapter("select * from expert where e_realm='"+flage+"' and e_zhiwu='"+fla+"' order by id desc",conn)
conn.open()
xxdneu 2004-04-26
sub search_Click(sender as object , e as eventargs)
dim ds as dataset=new dataset
dim conn as oledbconnection
conn=new oledbconnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.mappath("/qkglxt/data/data.mdb"))
dim mycommand as oledbDataAdapter
dim flage as string=dlHTLB.SelectedItem.Value
mycommand=new oledbDataAdapter("select * from expert where e_realm='"+flage+"' order by id desc",conn)
conn.open()
mycommand.fill(ds)
mydatagrid.datasource=new dataview(ds.tables(0))
mydatagrid.databind()
end sub
dim ds as dataset=new dataset
dim conn as oledbconnection
conn=new oledbconnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.mappath("/qkglxt/data/data.mdb"))
dim mycommand as oledbDataAdapter
dim flage as string=dlHTLB.SelectedItem.Value
mycommand=new oledbDataAdapter("select * from expert where e_realm='"+flage+"' order by id desc",conn)
conn.open()
mycommand.fill(ds)
mydatagrid.datasource=new dataview(ds.tables(0))
mydatagrid.databind()
end sub
lkk2073 2004-04-26
改成:
dim flage as string=dropdownlist.SelectedItem.Value
dim flage as string=dropdownlist.SelectedItem.Value
lkk2073 2004-04-26
单引号重复了...呵呵
sbxkpl 2004-04-26
页面中有一个dropdownlist,绑定了一个表，显示表中一字段数据，现在想利用dropdownlist中显示的数据做为查询条件，click后，查询后得到的数据显示在datagrid中。可是怎么取出其值呢，老大们帮忙看目的地，以下是我的代码！
sub search_Click(sender as object , e as eventargs)
dim ds as dataset=new dataset
dim conn as oledbconnection
conn=new oledbconnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.mappath("/qkglxt/data/data.mdb"))
dim mycommand as oledbDataAdapter
dim flage as string="'" & dropdownlist.SelectedItem.Value & "'"
mycommand=new oledbDataAdapter("select * from expert where e_realm='"+flage+"' order by id desc",conn)
conn.open()
mycommand.fill(ds)
mydatagrid.datasource=new dataview(ds.tables(0))
mydatagrid.databind()
end sub
我将 dim flage as string="'" & dropdownlist.SelectedItem.Value & "'"
换成 dim flage as string="社科"
在e_realm字段中"社科"就全部在datagrid中显示出来了。
还有换成 dim flage as string=" & dropdownlist.Text & "也一样显示不出。
各位大侠，帮我把把脉吧！到底怎样将dropdownlist的值取出来做为查询条件呢！
sub search_Click(sender as object , e as eventargs)
dim ds as dataset=new dataset
dim conn as oledbconnection
conn=new oledbconnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.mappath("/qkglxt/data/data.mdb"))
dim mycommand as oledbDataAdapter
dim flage as string="'" & dropdownlist.SelectedItem.Value & "'"
mycommand=new oledbDataAdapter("select * from expert where e_realm='"+flage+"' order by id desc",conn)
conn.open()
mycommand.fill(ds)
mydatagrid.datasource=new dataview(ds.tables(0))
mydatagrid.databind()
end sub
我将 dim flage as string="'" & dropdownlist.SelectedItem.Value & "'"
换成 dim flage as string="社科"
在e_realm字段中"社科"就全部在datagrid中显示出来了。
还有换成 dim flage as string=" & dropdownlist.Text & "也一样显示不出。
各位大侠，帮我把把脉吧！到底怎样将dropdownlist的值取出来做为查询条件呢！