怎样mshflexgrid里的数据减1读取到access里
解决方案 »
- 怎样将一定格式的.txt文件内容显示在dbgrid里面?..........明天就要我交,急死了!
- adodc 没有注册
- 请问各位大侠如何用ADO访问远程Access数据库?ConnectionString 怎样写,谢谢!
- 请问你知道哪儿有 水晶报表Crystal Reports 9 的电子书籍下载呀?
- 得到文件一些属性
- 有关:数值溢出问题!真是怪啊!!!
- 菜鸟问题,程序溢出
- 时间紧!请大家都来帮忙……如解决高分放送
- 请问如何用VB6编写一个通过互联网发送短消息的小程序?
- vb 中如何用ado连接dbf数据库?
- VB怎样控制word的页面,请高手帮忙!
- 请教:webbrowser第一次访问URL失败后再次刷新无效?即使再次Navigate url也无效?
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim i As Integer
Dim j As Integer
cn.CursorLocation = adUseClient
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "db\mydb.mdb;Persist Security Info=False"
cn.BeginTrans
With mshflexgrid
For i = 1 To .Rows - 1
strsql = ""
strsql = strsql & "insert into mytable (" & vbNewLine
strsql = strsql & " id " & vbNewLine
strsql = strsql & " , num_1 " & vbNewLine
strsql = strsql & " , num_2 " & vbNewLine
strsql = strsql & " , num_3 " & vbNewLine
strsql = strsql & " )" & vbNewLine
strsql = strsql & "values" & vbNewLine
strsql = strsql & " " & i & " " & vbNewLine
.col = 1
strsql = strsql & " ," & Val(.Text) - 1 & vbNewLine
.col = 1
strsql = strsql & " ," & Val(.Text) - 1 & vbNewLine
.col = 1
strsql = strsql & " ," & Val(.Text) - 1 & vbNewLine
strsql = strsql & " )" & vbNewLine
cn.Execute strsql
Next i
End With
cn.CommitTrans
cn.Close
Set cn = Nothing
End Sub
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim i As Integer
Dim j As Integer
cn.CursorLocation = adUseClient
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "db\mydb.mdb;Persist Security Info=False"
cn.BeginTrans
With mshflexgrid
For i = 1 To .Rows - 1
strsql = ""
strsql = strsql & "insert into mytable (" & vbNewLine '第一个括号 开始
strsql = strsql & " id " & vbNewLine
strsql = strsql & " , num_1 " & vbNewLine
strsql = strsql & " , num_2 " & vbNewLine
strsql = strsql & " , num_3 " & vbNewLine
strsql = strsql & " )" & vbNewLine '第一个括号 结束
strsql = strsql & "values(" & vbNewLine '第二个括号 开始
strsql = strsql & " " & i & " " & vbNewLine
.col = 1
strsql = strsql & " ," & Val(.Text) - 1 & vbNewLine
.col = 1
strsql = strsql & " ," & Val(.Text) - 1 & vbNewLine
.col = 1
strsql = strsql & " ," & Val(.Text) - 1 & vbNewLine
strsql = strsql & " )" & vbNewLine '第二个括号 结束
cn.Execute strsql
Next i
End With
cn.CommitTrans
cn.Close
Set cn = Nothing
End Sub