数据库中有多条记录,我想选择特定的记录显示在MSHFlexGrid控件中,下面是代码。有错误,帮忙看看!
Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset
rs.Open "select from 表1 where 姓名='" & Trim(Text1.Text) & "'and 工作单位='" & Trim(Combo1.Text) & "'"
Set MSHFlexGrid1.DataSource = rs.DataSource
MSHFlexGrid1.Refresh
rs.Close
Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset
rs.Open "select from 表1 where 姓名='" & Trim(Text1.Text) & "'and 工作单位='" & Trim(Combo1.Text) & "'"
Set MSHFlexGrid1.DataSource = rs.DataSource
MSHFlexGrid1.Refresh
rs.Close
解决方案 »
- 看看我的一个程序,谁能给改成用数据库做的
- 请教各位高人:屏蔽键盘的WIN按键、屏蔽ctrl+alt+del按键(或者按了时,发生我们定义的事情)、屏蔽开始菜单?
- VB小问题 在线等 帮偶一下
- 用datalist显示一个字段,删掉字段中一个内容,让他直接显示少了一个。
- vb怎样选择调用access中的批量数据进行运算,生成excel表! 用的是access,请求高手指点,不胜感激
- 菜鸟提问:在VB6中我怎么找不到flash控件呢?
- 找不一记录怎么办
- 请问各位用VB的时候的打包工具用什么比较好啊?还有SETUP FACTORY 5。0的免费版在哪儿可以下载啊?
- 还是MSHFlexGrid的打印问题,怎么调用excel??
- 关于数据存放的问题
- 报表打印的问题?寻设计思路..............
- 自定义控件背景如何透明??
Set MSHFlexGrid1.DataSource = rs应该OK了
rs.Open "select from 表1 where 姓名='" & Trim(Text1.Text) & "'and 工作单位='" & Trim(Combo1.Text) & "'"
rs.Open "select * from 表1 where 姓名='" & Trim(Text1.Text) & "' and 工作单位='" & Trim(Combo1.Text) & "'",conn,adopenkeyset,adlockreadonly
set mshflexgrid1.datasource=rs
rs.close
set mshflexgrid1.datasource=rs
如果有上面的语句,且rs.Open "select * from 表1 where 姓名='" & Trim(Text1.Text) & "' and 工作单位='" & Trim(Combo1.Text) & "'",conn,adopenkeyset,adlockreadonly
运行正确只有解吸为没有符合条件的数据
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
If rs.State = adStateOpen Then
rs.Open "select * from 表1 where 姓名='" & Trim(Text1.Text) & "' and 单位名称='" & Trim(Combo1.Text) & "'", Conn, adOpenKeyset, adLockReadOnly
Set MSHFlexGrid1.DataSource = rs
MSHFlexGrid1.Refresh
rs.Close
End If
End Sub查询了数据库中存在的数据,MSHFlexGrid1控件中还是不显示。是不是我的代码不应该放在这个事件中,初学还请各位多多指教!
rs.Open "select * from 表1 where 姓名='" & Trim(Text1.Text) & "' and 单位名称='" & Trim(Combo1.Text) & "'", Conn, adOpenKeyset, adLockReadOnly
-------------------------
Then后面少了 rs.Close
If rs.State = adStateOpen Then rs.Close
rs.Open "select * from 表1 where 姓名='" & Trim(Text1.Text) & "' and 单位名称='" & Trim(Combo1.Text) & "'", Conn, adOpenKeyset, adLockReadOnly
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
If rs.State = adStateOpen Then rs.Close rs.Open "select * from 表1 where 姓名='" & Trim(Text1.Text) & "' and 单位名称='" & Trim(Combo1.Text) & "'", Conn, adOpenKeyset, adLockReadOnly Set MSHFlexGrid1.DataSource = rs
MSHFlexGrid1.Refresh
rs.Close
Set rs=Nothing
End Sub
rs.Open "select * from 表1 where 姓名='" & Trim(Text1.Text) & "' and 单位名称='" & Trim(Combo1.Text) & "'", Conn, adOpenKeyset, adLockReadOnly
Set MSHFlexGrid1.DataSource = rs
MSHFlexGrid1.Refresh
rs.Close
End If