Dim db As Connection
Set db = New Connection
db.CursorLocation = adUseClient
db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\database\db1.mdb;"
Set adoPrimaryRS = New Recordset
adoPrimaryRS.Open "select * from 缴费 , db, adOpenStatic, adLockOptimistic"
adoPrimaryRS.MoveFirst
Set MSHFlexGrid1.DataSource = adoPrimaryRS
adoPrimaryRS.Close
Set adoPrimaryRS = Nothing怎么加个条件??
如根据text1.text来判断MSHFlexGrid1显示值???select * from 缴费 , db, adOpenStatic, adLockOptimistic 这里怎么加呢??
Set db = New Connection
db.CursorLocation = adUseClient
db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\database\db1.mdb;"
Set adoPrimaryRS = New Recordset
adoPrimaryRS.Open "select * from 缴费 , db, adOpenStatic, adLockOptimistic"
adoPrimaryRS.MoveFirst
Set MSHFlexGrid1.DataSource = adoPrimaryRS
adoPrimaryRS.Close
Set adoPrimaryRS = Nothing怎么加个条件??
如根据text1.text来判断MSHFlexGrid1显示值???select * from 缴费 , db, adOpenStatic, adLockOptimistic 这里怎么加呢??
解决方案 »
- 怎样在窗体中实现按回车键焦点移到下一控件?
- VB如何将数据导出到pdf文件!高分求助!!!
- 求比较全面的函数声明资料(shell32.dll)
- 用SQL語句如何獲取一個char型字符串中某個字符的位置?
- 关于连接数据库的问题!
- 问问
- 如何用按钮实现导航条
- 我在联接服务器上的sql数据库时,必须先登录服务器。问题是我不想登录服务器,可以联接数据库吗?
- 能否在VB6.0程序中插入各国字符(比如阿拉伯文\波兰文等等) 系统的LOCALE是中文的
- 用GRID,如何在最后一行显示每一列的和?用MSHFlexGrid或TDBGrid程序如何编写?
- 如何可以讓光標不顯示。
- 请教如何在richtextbox中显示图片
这样不行!!还是错误!!!
=========
可以去掉adoPrimaryRS.MoveFirst这句或者改为:
If Not (adoPrimaryRS.Bof And adoPrimaryRS.Eof) Then adoPrimaryRS.MoveFirst
select * from 缴费 where 字段名='"& text1.text &"'", db, adOpenStatic, adLockOptimistic
Set db = New Connection
db.CursorLocation = adUseClient
db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\database\db1.mdb;"
Set adoPrimaryRS = New Recordset
'如果字段名是字符:
adoPrimaryRS.Open "select * from 缴费 where 字段名='" & text1.text &"'", db, adOpenStatic, adLockOptimistic"
'如果字段名是数字:
adoPrimaryRS.Open "select * from 缴费 where 字段名=" & text1.text , db, adOpenStatic, adLockOptimistic"
adoPrimaryRS.MoveFirst
Set MSHFlexGrid1.DataSource = adoPrimaryRS
adoPrimaryRS.Close
Set adoPrimaryRS = NothingMSHFlexGrid1是只读的,要修改,得自己放一些TEXTBOX上去。
就是怎么选择MSHFlexGrid1一个内容,然后点一个修改的按钮后,把选择一条内容传到对应的text1,然后
再保存!!
MsgBox "你还没有选择记录!", vbOKOnly + vbExclamation, "警告"
Else
Set db = New Connection
db.CursorLocation = adUseClient
db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\database\db1.mdb;"
Set adoPrimaryRS = New Recordset
adoPrimaryRS.Open "select * from 缴费 where 用户编号='" & Trim(MSHFlexGrid1.TextMatrix(MSHFlexGrid1.Row, 1)) & "'", db, adOpenStatic, adLockOptimistic
adoPrimaryRS.MoveFirst
For j = 0 To 7
Text1(j).Text = adoPrimaryRS.Fields(j)
Next
End If
只能显示第一条的记录.如何显示选择数据??也就是我选择那条记录,text1就对应那条记录??