很容易,你自己看一下有关ADO和SQL的书就可以知道了
解决方案 »
- 求助前辈139邮箱表单自动填写问题(自动发短信)
- 编辑frmdata
- 关于MSFLEXGRID的问题2
- 如何得到标准ie窗口的内容,以及控制它?最好能取得COM组件的引用。ie窗口是事先打开的,而不是被自己的程序打开的
- 用API实现窗体不能人为调节大小
- 急救!怎样手工绑定DataCombo控件? [问题点数:40分]
- 一个困扰已久的问题:如何用vb做出vc中dockbar的效果?
- 用InstallShield打包VB程序(使用DAO连接数据库),应该包括DAO的哪些文件?
- 用ADO连接MDB数据库,并对数据库中的视图或表结构进行编辑或删除时出错。(UP有分)
- 高手,哪里有“ado"电子书下载
- 如何判断控件是否有某一属性??
- 怎么样可以像VB的安装光盘一样……
Private Sub Command1_Click()
On Error GoTo RefreshErr
Dim SearchStr As String 'Name Or PassWord 姓名和会员卡密码是字符型
Dim SearchNum As Integer 'CardNum 会员卡号是数值型
Dim SearchDate As Date 'CardDate 会员卡建卡时间是时间型
Dim OldPosition As Integer '保存旧指针
OldPosition = datPrimaryRS.Recordset.AbsolutePosition
Find.Show 1
If CanFind Then '查找内容非空
datPrimaryRS.Refresh
SearchStr = Find.Text1.Text
Select Case FindSel
Case Is = 0 'Name Or PassWord
datPrimaryRS.Recordset.Find "Name='" + SearchStr + "'"
Case Is = 1 'CardNum
SearchNum = Val(SearchStr)
datPrimaryRS.Recordset.Find "CardNum=" & SearchNum
Case Is = 2 'CardDate
SearchDate = DateValue(SearchStr)
datPrimaryRS.Recordset.Find "CardTime=" & SearchDate
End Select
If datPrimaryRS.Recordset.AbsolutePosition = -3 Then
MsgBox "没有找到与此相关的记录!", vbInformation, "查找"
datPrimaryRS.Refresh '恢复旧指针
datPrimaryRS.Recordset.AbsolutePosition = OldPosition
End If
End If
Exit Sub
RefreshErr:
MsgBox Err.Description
End SubPrivate Sub datPrimaryRS_Error(ByVal ErrorNumber As Long, Description As String, ByVal Scode As Long, ByVal Source As String, ByVal HelpFile As String, ByVal HelpContext As Long, fCancelDisplay As Boolean)
'错误处理程序代码置于此处
MsgBox "Data error event hit err:" & Description
End Sub
Private Sub datPrimaryRS_WillChangeRecord(ByVal adReason As ADODB.EventReasonEnum, ByVal cRecords As Long, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)
验证代码置于此处下列动作发生时该事件被调用
Dim bCancel As Boolean Select Case adReason
Case adRsnAddNew
……
Case adRsnClose
……
Case adRsnDelete
……
Case adRsnFirstChange
……
Case adRsnRequery
……
Case adRsnResynch
……
Case adRsnUndoAddNew
……
Case adRsnUndoDelete
……
Case adRsnUndoUpdate
……
Case adRsnUpdate
……
End Select
If bCancel Then adStatus = adStatusCancel
End SubPrivate Sub cmdAdd_Click()
On Error GoTo AddErr
datPrimaryRS.Recordset.AddNew
Exit Sub
AddErr:
End SubPrivate Sub cmdDelete_Click()
On Error GoTo DeleteErr
With datPrimaryRS.Recordset
.Delete
.MoveNext
If .EOF Then .MoveLast
End With
Exit Sub
DeleteErr:
MsgBox Err.Description
End SubPrivate Sub cmdRefresh_Click()
'只有多用户应用程序需要
On Error GoTo RefreshErr
datPrimaryRS.Refresh
Exit Sub
RefreshErr:
MsgBox Err.Description
End SubPrivate Sub cmdUpdate_Click()
On Error GoTo UpdateErr datPrimaryRS.Recordset.UpdateBatch adAffectAll
Exit Sub
UpdateErr: If Err.Number = -2147217887 Then
MsgBox "会员记录信息输入的格式有误,请检查!", vbInformation, "输入错误"
Err.Clear
datPrimaryRS.Refresh
End If
End SubPrivate Sub cmdClose_Click()
Unload Me
End SubPrivate Sub Form_Load()
On Error GoTo By
datPrimaryRS.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & App.Path & "\Favorite.mdb"
'Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=D:\VB\Favorite.mdb
Exit Sub
By:
MsgBox Err.Description
End Sub