单击cmdAddNew按钮时提示框标题为“microsoft DataGrid 控件” 内容为“书签无效”Private Sub cmdAddNew_Click()
Rs.AddNew
Rs("物料名称") = Text1
Rs("单位") = Text2
Rs("领料人") = Text3
Rs("日期") = Text4
Rs.Update
End SubPrivate Sub cmdBreak_Click()
Rs.Close
Cn.Close
Set Cn = Nothing
MsgBox "连接断开"
cmdBreak.Enabled = False
cmdConnect.Enabled = True
End SubPrivate Sub cmdConnect_Click()
On Error GoTo cuowu:
Cn.ConnectionString = "provider=sqloledb.1;persist security info=false;user id=sa;password=zxc007;initial catalog=易耗品;data source=(local)"
Cn.Open
MsgBox "连接成功"
sql = "select * from 易耗品领料记录 "
Rs.Open sql, Cn, adOpenKeyset, adLockOptimistic
Set DataGrid1.DataSource = Rs
cmdConnect.Enabled = False
cmdBreak.Enabled = True
Exit Sub
cuowu:
MsgBox "连接失败"
End Sub
Rs.AddNew
Rs("物料名称") = Text1
Rs("单位") = Text2
Rs("领料人") = Text3
Rs("日期") = Text4
Rs.Update
End SubPrivate Sub cmdBreak_Click()
Rs.Close
Cn.Close
Set Cn = Nothing
MsgBox "连接断开"
cmdBreak.Enabled = False
cmdConnect.Enabled = True
End SubPrivate Sub cmdConnect_Click()
On Error GoTo cuowu:
Cn.ConnectionString = "provider=sqloledb.1;persist security info=false;user id=sa;password=zxc007;initial catalog=易耗品;data source=(local)"
Cn.Open
MsgBox "连接成功"
sql = "select * from 易耗品领料记录 "
Rs.Open sql, Cn, adOpenKeyset, adLockOptimistic
Set DataGrid1.DataSource = Rs
cmdConnect.Enabled = False
cmdBreak.Enabled = True
Exit Sub
cuowu:
MsgBox "连接失败"
End Sub
解决方案 »
- 求sql
- 查寻两表三字段都相等
- 查询结果自动生成一字段,并按1234升序的方法生成值
- usInstallShield正在使用中
- 长时间操作同一表,死锁问题
- 如何用sql语句实现成绩求平均分、名次
- 关于存储过程执行时间问题,在线等~~
- 服务器感染了病毒,备份数据库时数据库完全,差异都不可见,在线,分不够再给,
- 请高手写sql语句
- INSERT: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connecti
- SQL语句不能再ACCESS种执行,,NOT IN
- 建立链接服务器后,使用not in时出现"不能在手动或分布事务模式下创建新的连接。"的问题
rs.CursorLocation = adUseClient 即OK !