当保存,修改,删除的按钮按下后,应如何在数据库内容变更好,表格控件里的内容刷新? 是不是要用RS.CLOSE 后,再RS.OPEN吗?
解决方案 »
- 为什么上次查询记录第一个单元格的数据,会把下一次查询的数据修改了?
- 可不可以当程序退出后仍可将控件的新添加的内容保存?
- 如何动态设定datagrid的标题,使其与数据库表中的列标题一一对应?
- 这样的界面应该怎么实现比较好
- treeview的CheckBoxes = True了,任何将checkboxes选中的多个node text付值给变量或者打印啊
- 求救!!关于picturebox中的图片怎样能保存下来!急,新手
- 请问,“.gen”结尾,method="GET"的网页怎么提交啊?用intl提交不了啊
- 从一个FORM来更新另一个FORM的局部文本框???
- 谢谢大家,帮忙解释一下好吗!
- 怎么处理(有记录就updata,没有记录就insert)才最简洁?
- 散分散分 分留着又不能娶老婆!
- 请各位大哥帮忙,改个VBS
DataConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path1 + ";Persist Security Info=False" + ";Jet OLEDB:Database Password=软讨彩在单本线名探站只票理评发关数相论件"
cnndb.ConnectionString = DataConnectString
cnndb.Open
DataConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path1 + ";Persist Security Info=False" + ";Jet OLEDB:Database Password=软讨彩在单本线名探站只票理评发关数相论件"
cnndb.ConnectionString = DataConnectString
cnndb.OpenstrSQL = "select * from data order by index0 desc"
rst1.Open strSQL, cnndb, adOpenDynamic, adLockOptimistic With vaSpread1
i = 1
Do While Not rst1.EOF
.MaxRows = i
.Row = i
.Col = 1: .Text = rst1!index0
***
rst1.MoveNext
Loop
End With
rs.addnew
**
rs.update
vaSpread1.Refresh
这个控件不能绑定RS
原来是要用vaSpread重新获取RS内容才行的.
rst1.Open strSQL, cnndb, adOpenDynamic, adLockOptimistic***rst1.Refresh 这句不能用.
为何这个记录集没有ReFresh
控件没绑定,是对格子一个一个赋值的.
新增和删除后都再执行一下这个代码:
Private Sub grid_Def()
Dim i As Integer
With vaSpread1
.MaxRows = 0
i = 1
Do While Not rst1.EOF
.MaxRows = i
.Row = i
.Col = 1: .Text = rst1!index0
.Col = 2: .Text = Format(rst1!index1 & "-" & rst1!index2 & "-" & rst1!index3, "yyyy-mm-dd")
.Col = 3: .Text = rst1!index4
.Col = 10: .Text = rst1!index11
.Col = 11: .Text = rst1!index12
i = i + 1
rst1.MoveNext
Loop
End With
End Sub
先关闭,再OPEN?
rst1.Close
Form_Load
这样就实现了功能,只是如果数据多了,就感到有点慢了.
------------------------------
Private Sub Form_Load()
rst1.CursorLocation = adUseClientDTPicker1.Value = DatestrSQL = "select * from data order by index0 desc"
rst1.Open strSQL, cnndb, adOpenKeyset, adLockOptimistic With vaSpread1
.MaxRows = 0
i = 1
Do While Not rst1.EOF
.MaxRows = i
.Row = i
.Col = 1: .Text = rst1!index0
**
.Col = 26: .Text = rst1!index120
i = i + 1
rst1.MoveNext
Loop
End With
End Sub
2、添加、修改、删除表格