关于MSFLEXGRID控件 将msflexgrid绑定的data控件刷新一下! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 即时flexgrid的版本更新到了7.0,数据绑定的功能仍然很不好用。建议直接将表和flexgrid连接,不要再通过data控件. object.update建议你用mshflexgrid 需要updaterst.update建议用mshflexgridDim cnn1 As New ADODB.ConnectionDim rst As New ADODB.RecordsetDim cnnstr As Stringcnnstr = " provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\test.mdb;"cnn1.Open cnnstrWith rst .CursorType = adOpenKeyset .LockType = adLockOptimistic .Open "select * from stu", cnnstr .AddNew .Fields("字段1") = "1" .Fields("字段2") = "2" .Fields("字段3") = "3" .Fields("字段4") = "4" .Fields("字段5") = "5" .Update .UpdateBatch adAffectAllChaptersEnd WithSet Form1.MSHFlexGrid1.DataSource = rstrst.Closecnn1.Close 需要updaterst.update建议用mshflexgridDim cnn1 As New ADODB.ConnectionDim rst As New ADODB.RecordsetDim cnnstr As Stringcnnstr = " provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\test.mdb;"cnn1.Open cnnstrWith rst .CursorType = adOpenKeyset .LockType = adLockOptimistic .Open "select * from stu", cnnstr .AddNew .Fields("字段1") = "1" .Fields("字段2") = "2" .Fields("字段3") = "3" .Fields("字段4") = "4" .Fields("字段5") = "5" .Update .UpdateBatch adAffectAllChaptersEnd WithSet Form1.MSHFlexGrid1.DataSource = rstrst.Closecnn1.Close 需要updaterst.update建议用mshflexgridDim cnn1 As New ADODB.ConnectionDim rst As New ADODB.RecordsetDim cnnstr As Stringcnnstr = " provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\test.mdb;"cnn1.Open cnnstrWith rst .CursorType = adOpenKeyset .LockType = adLockOptimistic .Open "select * from stu", cnnstr .AddNew .Fields("字段1") = "1" .Fields("字段2") = "2" .Fields("字段3") = "3" .Fields("字段4") = "4" .Fields("字段5") = "5" .Update .UpdateBatch adAffectAllChaptersEnd WithSet Form1.MSHFlexGrid1.DataSource = rstrst.Closecnn1.Close 【生日快乐】 老妈好ihao vb中text中数字大小的问题 用程序写在excel中复制的问题 用Data 控件如何调用 sqlserver2000!~~~急 急!关于adodc控件的问题 如何让程序在中间暂停? 怎么在 ActiveX DLL中加入WinSock? 表与表的联系,在VB中如何实现呢?急,明天中午结账! 我头都大了?(急救!) 请问ado中如何得到存储过程返回的游标?高手请进! 在98系统下用VB编制的程序能否在WINDOWS XP上运行? ▁▂▃▄▅▆▇█▉靠,分也不要了!俺想出国镀金!不要说我卖国哟,哥们还是要杀回马枪报国的!各位支招!
不好用。建议直接将表和flexgrid连接,不要再通过data
控件.
建议你用mshflexgrid
Dim rst As New ADODB.Recordset
Dim cnnstr As String
cnnstr = " provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\test.mdb;"
cnn1.Open cnnstrWith rst
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open "select * from stu", cnnstr
.AddNew
.Fields("字段1") = "1"
.Fields("字段2") = "2"
.Fields("字段3") = "3"
.Fields("字段4") = "4"
.Fields("字段5") = "5"
.Update
.UpdateBatch adAffectAllChapters
End With
Set Form1.MSHFlexGrid1.DataSource = rst
rst.Close
cnn1.Close
Dim rst As New ADODB.Recordset
Dim cnnstr As String
cnnstr = " provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\test.mdb;"
cnn1.Open cnnstrWith rst
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open "select * from stu", cnnstr
.AddNew
.Fields("字段1") = "1"
.Fields("字段2") = "2"
.Fields("字段3") = "3"
.Fields("字段4") = "4"
.Fields("字段5") = "5"
.Update
.UpdateBatch adAffectAllChapters
End With
Set Form1.MSHFlexGrid1.DataSource = rst
rst.Close
cnn1.Close
Dim rst As New ADODB.Recordset
Dim cnnstr As String
cnnstr = " provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\test.mdb;"
cnn1.Open cnnstrWith rst
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open "select * from stu", cnnstr
.AddNew
.Fields("字段1") = "1"
.Fields("字段2") = "2"
.Fields("字段3") = "3"
.Fields("字段4") = "4"
.Fields("字段5") = "5"
.Update
.UpdateBatch adAffectAllChapters
End With
Set Form1.MSHFlexGrid1.DataSource = rst
rst.Close
cnn1.Close