加好友 发短信
等级:婴狐
帖子:29
积分:391
威望:0
精华:0
注册:2012/3/25 9:14:00
|
权限设置 Post By:2012/9/8 16:45:00 [显示全部帖子]
Dim cmd As New SQLCommand Dim exp As String = "(编辑者 Is Null Or 编辑者 = '" & User.Name & "') And [_Identify] = " & e.Row("_Identify") cmd.CommandText = "Update {员工} Set 编辑者 = '" & User.Name & "' Where " & exp If cmd.ExecuteNonQuery = 1 Then Forms("编辑窗口").Open() Else cmd.CommandText = "Select 编辑者 From {员工} Where [_Identify] = " & e.Row("_Identify") Dim nm As String = cmd.ExecuteScalar If nm > "" Then MessageBox.show(nm & "正在编辑此行!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information) Else cmd.CommandText = "Select Count(*) From {员工} Where [_Identify] = " & e.Row("_Identify") If cmd.ExecuteScalar =0 Then MessageBox.show("此行已被他人删除!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information) End If End If End If使用外部数据源的时候出现错误,需要怎么修改?
此主题相关图片如下:qq截图20120908164343.jpg
|
|