Public Sub OpenConn() '连接数据库 Set cn = New ADODB.Connection Set rs = New ADODB.Recordset cn.CursorLocation = adUseClient cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & App.Path & "\data.accdb;Jet OLEDB:Database Password=123;Persist Security Info=False;" End Sub Private Sub Command3_Click() '保存 Dim i As Integer End SubCall OpenConnFor i = 1 To MSFlexGrid1.Rows - 1 NumId = NumId + 1
MSFlexGrid控件是加microshoft flexgrid control 6.0也引用了ActiveX Data Objects 2.7 用ado'如果把数据库换成是SQL SEVER了.MSFlexGrid控件还能用吗?其他数据库换cn.Open "Provider就可以了,和MSFlexGrid没有关系
Public Sub OpenConn() '连接数据库
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
cn.CursorLocation = adUseClient
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & App.Path & "\data.accdb;Jet OLEDB:Database Password=123;Persist Security Info=False;"
End Sub
Private Sub Command3_Click() '保存
Dim i As Integer
End SubCall OpenConnFor i = 1 To MSFlexGrid1.Rows - 1
NumId = NumId + 1
SQL = "insert into XSD values ('" & NumId & "','" & Label4.Caption & "','" & Format(DTPicker1.Value, "yyyy-mm-dd") & "','" & Text3.Text & "','" & Label1(7).Caption & "','" & Label3.Caption & "','" & Text4.Text & "','" & Text5.Text & "','" & MSFlexGrid1.TextMatrix(i, 0) & "','" _
& MSFlexGrid1.TextMatrix(i, 1) & "','" & MSFlexGrid1.TextMatrix(i, 2) & "','" & MSFlexGrid1.TextMatrix(i, 3) & "','" & MSFlexGrid1.TextMatrix(i, 4) & "','" & MSFlexGrid1.TextMatrix(i, 5) & "','" & MSFlexGrid1.TextMatrix(i, 6) & "','" & MSFlexGrid1.TextMatrix(i, 7) & "','" & MSFlexGrid1.TextMatrix(i, 8) & "','" & MSFlexGrid1.TextMatrix(i, 9) & "','" & MSFlexGrid1.TextMatrix(i, 10) & "','" & MSFlexGrid1.TextMatrix(i, 11) & "','" & Label1(5).Caption & "')"
rs.Open SQL, cn, 1, 3
Next
Call CloseConnMsgBox "单据保存成功!", 48, "提示"
用ado'如果把数据库换成是SQL SEVER了.MSFlexGrid控件还能用吗?其他数据库换cn.Open "Provider就可以了,和MSFlexGrid没有关系
ado管数据库的连接,MSFlexGrid是把ado的记录集拿来用
数据库————〉ado——————〉MSFlexGrid
原来是这回事.谢谢jhone99兄 .阿勇兄!
可以绑定也可以不绑定
就好像TextBox,可以绑定数据库,也可以不绑定