Dim strcon As String Dim conn As ADODB.ConnectionPrivate Sub Command1_Click() Dim strsql As String Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset strsql = "select * from BookInfo where BookId='" & Text1.Text & "'" rs.Open strsql, conn If Not rs.EOF Then MsgBox "书籍编号不可以有重复!" Else Adodc1.Recordset.AddNew Array("BookId", "BookName", "BuyTime", "BookNum", "Price", "Memo"), Array(CStr(Text1.Text), CStr(Text2.Text), CStr(Text3.Text), Text4.Text, Text5.Text, CStr(Text6.Text)) Adodc1.Recordset.Update Adodc1.Refresh flexgrid1.Refresh Set flexgrid1.DataSource = Nothing Set flexgrid1.DataSource = Adodc1 End If End SubPrivate Sub Form_Load() Set conn = New ADODB.Connection strcon = "driver={Microsoft Access Driver (*.mdb)};dbq=" & App.Path & "\data.mdb" conn.Open strcon End Sub
to zealot_zk(风中追风): adodc.requery 这句话行吗? mshflexgrid.rebind 它没有rebind方法呀?
mshflexgrid.refresh
mshflexgrid.refresh
即可
Dim conn As ADODB.ConnectionPrivate Sub Command1_Click()
Dim strsql As String
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
strsql = "select * from BookInfo where BookId='" & Text1.Text & "'"
rs.Open strsql, conn
If Not rs.EOF Then
MsgBox "书籍编号不可以有重复!"
Else
Adodc1.Recordset.AddNew Array("BookId", "BookName", "BuyTime", "BookNum", "Price", "Memo"), Array(CStr(Text1.Text), CStr(Text2.Text), CStr(Text3.Text), Text4.Text, Text5.Text, CStr(Text6.Text))
Adodc1.Recordset.Update
Adodc1.Refresh
flexgrid1.Refresh
Set flexgrid1.DataSource = Nothing
Set flexgrid1.DataSource = Adodc1
End If
End SubPrivate Sub Form_Load()
Set conn = New ADODB.Connection
strcon = "driver={Microsoft Access Driver (*.mdb)};dbq=" & App.Path & "\data.mdb"
conn.Open strcon
End Sub
adodc.requery 这句话行吗?
mshflexgrid.rebind 它没有rebind方法呀?