datagrid删除时怎样对没有权限的删除进行提示?
我的dataGrid删除的列绑定语句中加入javascript语句对删除进行确认,另外在删除程序中对删除的人进行身份确认,让只有对自己发表的留言可以删除。
问题是,如果删除的人没有权限,怎么让系统的弹出框进行提示?或者别的方法进行提示。
<asp:ButtonColumn HeaderText="删除" Text="<img src=delete.gif border=0 align=absmiddle alt='Edit this item'< id="de" onclick="javascript:return confirm('确定删除这条记录吗?')">" CommandName="Delete" ItemStyle-HorizontalAlign="Center"
HeaderStyle-HorizontalAlign="Center"></asp:ButtonColumn>
Sub dgCommentTable_Delete(Sender As Object, E As DataGridCommandEventArgs)
Dim DBConn as SqlConnection
DBConn = New SqlConnection("server=(local);Initial Catalog=gzhb;User Id=sa;Password=;Trusted_Connection=yes")
Dim MyCommand As SqlCommand
Dim DBCommand As SqlDataAdapter
Dim DSPageData As New DataSet
Dim DeleteCmd As String = "Delete From comment where 评论ID= @ID"
MyCommand = New SqlCommand(DeleteCmd, DBconn)
MyCommand.Parameters.Add(New SqlParameter("@ID", SqlDbType.Int,4))
MyCommand.Parameters("@ID").Value = dgCommentTable.DataKeys(CInt(E.Item.ItemIndex))
DBCommand = New SqlDataAdapter("select 评论人 from Comment where 评论ID ="& dgCommentTable.DataKeys(CInt(E.Item.ItemIndex)), DBConn)
DBCommand.Fill(DSPageData,"name1")
Dim namecmt As String = DSPageData.Tables("name1").Rows(0).Item("评论人")
Dim nameComp As Integer=StrComp(namecmt,Session("EmpName"),CompareMethod.Binary)
If nameComp=-1 Then
MyCommand.Connection.Open()
Mycommand.ExecuteNonQuery()
MyCommand.Connection.Close()
BindGrid()
End If
End Sub