I am trying to control the label controls from the ItemTemplateField in the GridView, each row contains a label control and a group name.
For example the gridview looks like this:
| Group A |
label 1 |
| Group B |
label 2 |
| Group C |
label 3 |
I am using VB Function to control the label based on NT user group name. If the NT user from Group A then only the first row is visible and the rest are hidden, If the user from Group B then only 2nd row is visible.
html page:
<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="default.aspx.vb" Inherits="Control_Systems._default" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Applications</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="ControlDS" BorderStyle="None" ShowHeader="False">
<Columns>
<asp:TemplateField ConvertEmptyStringToNull="False" HeaderText="NT_GROUP" SortExpression="NT_GROUP">
<ItemTemplate>
<asp:Label ID="lblGroup" runat="server" Text='<%# Eval("NT_GROUP") %>' Visible="False"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="App_Name" SortExpression="App_Name">
<ItemTemplate>
<asp:Label ID="lblAppName" runat="server" Text='<%# Bind("App_Name") %>' Visible="False"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Url" SortExpression="Url">
<ItemTemplate>
<asp:HyperLink ID="hLnk" runat="server" NavigateUrl='<%# Eval("Url") %>' Text='<%# Eval("Url") %>' Target="_blank" Visible="False"></asp:HyperLink>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<br />
<asp:SqlDataSource ID="ControlDS" runat="server" ConnectionString="<%$ ConnectionStrings:ControlCS %>" SelectCommand="SELECT NT_GROUP, App_Name, RTRIM(App_Web_Link) AS Url FROM VW_WebLinks"></asp:SqlDataSource>
</div>
</form>
</body>
</html>
code page:
Public Class _default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
End Sub
Protected Sub GridView1_RowDataBound(sender As Object, e As GridViewRowEventArgs) Handles GridView1.RowDataBound
If e.Row.RowType = DataControlRowType.DataRow Then
Dim hLink As HyperLink = TryCast(e.Row.FindControl("hLnk"), HyperLink)
Dim lblApp As Label = TryCast(e.Row.FindControl("lblAppName"), Label)
Dim lblGrp As Label = TryCast(e.Row.FindControl("lblGroup"), Label)
If IsInGroup("Group A") Then '----------> Must match record from the table
hLink.Visible = True
lblApp.Visible = True
lblGrp.Visible = True
Else
e.Row.Visible = False '----------> Make rows hidden if user is not in group
End If
End If
End Sub
Public Function IsInGroup(ByVal GroupName As String) As Boolean
Dim MyIdentity As System.Security.Principal.WindowsIdentity = System.Security.Principal.WindowsIdentity.GetCurrent()
Dim MyPrincipal As System.Security.Principal.WindowsPrincipal = New System.Security.Principal.WindowsPrincipal(MyIdentity)
Return MyPrincipal.IsInRole(GroupName)
End Function
End Class
TSQL View:
| NT_Group |
App_Name |
Url |
| Group A |
|
link 1 |
| Group B |
|
link 2 |
| Group C |
|
link 3 |
Is it possible to get the GridView1_RowDataBound to check if the authenticated NT user group matches the NT_Group row, then display the row that only corresponds to the user group and hide other rows?
I appreciate any help.
