How can I hide CommandField Button in GridView when user is Admin ltaspGridView ID34AdminGrid34 runat34server34 CellPadding34434 ForeColor3433333334 GridLines34None34 HorizontalAlign34Center34 AutoGenerateColumns34false34 ShowHeaderWhenEmpty34true34 Width34900px34 Height34121px34 OnRowDataBound34OnRowDataBound34 DataKeyNames34Uid34 AllowPaging 34true34 OnRowDeleting34OnRowDeleting34 OnSelect

Hi George616Refer below sample codeHTMLltaspGridView ID34GridView134 runat34server34 AutoGenerateColumns34false34gt ltColumnsgt ltaspBoundField DataField34Id34 HeaderText34Id34 ItemStyleWidth343034 gt ltaspBoundField DataField34Name34 HeaderText34Name34 ItemStyleWidth3415034 gt ltaspBoundField DataField34Country34 HeaderText34Country34 ItemStyleWidth3415034 gt ltaspCommandField ButtonType34Button34 ShowDeleteButton34true34 ItemStyleForeColor3400003D34 ItemStyleWidth3415034 gt ltColumnsgtltaspGridViewgtCodeCprotected void PageLoadobject sender EventArgs e if thisIsPostBack SystemDataDataTable dt new SystemDataDataTable dtColumnsAddRangenew SystemDataDataColumn3 new SystemDataDataColumn34Id34 typeof

Show Hide GridView CommandField Button based on user Role using C# and VB.Net in ASP.Net

George61...

SOLVED CLOSED ACTIVE ANSWERED
User: George616
Posted: on Jul 10, 2020 03:31 AM
Forum: Data Controls
Answer: 2
Views: 10692
Sample Code: Download

How can I hide CommandField Button in GridView when user is Admin ?

<asp:GridView ID="AdminGrid" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" HorizontalAlign="Center" AutoGenerateColumns="false" ShowHeaderWhenEmpty="true" Width="900px" Height="121px" OnRowDataBound="OnRowDataBound"
    DataKeyNames="Uid" AllowPaging ="true" OnRowDeleting="OnRowDeleting" OnSelectedIndexChanged="AdminGrid_SelectedIndexChanged">
    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
    <EditRowStyle BackColor="#999999" />
    <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
    <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
    <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
    <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
    <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
    <SortedAscendingCellStyle BackColor="#E9E7E2" />
    <SortedAscendingHeaderStyle BackColor="#506C8C" />
    <SortedDescendingCellStyle BackColor="#FFFDF8" />
    <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
    <Columns>
        <asp:TemplateField HeaderText="Email Address" ItemStyle-Width="300">
            <ItemTemplate>
                <asp:Label ID="Label1" runat="server" Text='<%# Eval("email") %>' />
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="txtname" Text="" runat="server" />
            </EditItemTemplate>
            <FooterTemplate>
                <asp:TextBox ID="footertxtname" Text="" runat="server" />
            </FooterTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Role">
            <ItemTemplate>
                <asp:Label ID="Label2" runat="server" Text='<%# Eval("UserRole") %>' />
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="txtname" Text="" runat="server" />
            </EditItemTemplate>
            <FooterTemplate>
                <asp:TextBox ID="footertxtname" Text="" runat="server" />
            </FooterTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Date Created/Time" ItemStyle-Width="300">
            <ItemTemplate>
                <asp:Label ID="Label3" runat="server" Text='<%# Eval("CreateDate") %>' />
            </ItemTemplate>
            <EditItemTemplate>
                <asp:TextBox ID="txtname" Text="" runat="server" />
            </EditItemTemplate>
            <FooterTemplate>
                <asp:TextBox ID="footertxtname" Text="" runat="server" />
            </FooterTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="">
            <ItemTemplate>
            </ItemTemplate>
            <EditItemTemplate>
            </EditItemTemplate>
            <FooterTemplate>
            </FooterTemplate>
        </asp:TemplateField>
         <asp:CommandField ButtonType="Button" ShowDeleteButton="true" ItemStyle-ForeColor="#00003D" ItemStyle-Width="150" />
    </Columns>
    <EmptyDataTemplate>
        <div style="text-align: center;">
            No User Records</div>
    </EmptyDataTemplate>
</asp:GridView>

   protected void Page_Load(object sender, EventArgs e)
   {
       if (!this.IsPostBack) 
       {
           this.BindGrid(); 
           string UserRole = "A";
           foreach (GridViewRow row in AdminGrid.Rows)
           {
               Button btnDelete = row.Cells[4].Controls[0] as Button;
               if (UserRole == "A")
               {
                   btnDelete.Visible = true;
               }
               else if (UserRole == "U")
               {
                   btnDelete.Visible = false;
               }
           }
       }
   }

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 2

Reply
ANSWER
User: dharmendr
Replied: on Jul 10, 2020 03:49 AM
Report

Hi George616,

Refer below sample code.

HTML

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="Id" HeaderText="Id" ItemStyle-Width="30" />
        <asp:BoundField DataField="Name" HeaderText="Name" ItemStyle-Width="150" />
        <asp:BoundField DataField="Country" HeaderText="Country" ItemStyle-Width="150" />
        <asp:CommandField ButtonType="Button" ShowDeleteButton="true" ItemStyle-ForeColor="#00003D"
            ItemStyle-Width="150" />
    </Columns>
</asp:GridView>

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        System.Data.DataTable dt = new System.Data.DataTable();
        dt.Columns.AddRange(new System.Data.DataColumn[3] { 
                        new System.Data.DataColumn("Id", typeof(int)),
                        new System.Data.DataColumn("Name", typeof(string)),
                        new System.Data.DataColumn("Country",typeof(string)) });
        dt.Rows.Add(1, "John Hammond", "United States");
        dt.Rows.Add(2, "Mudassar Khan", "India");
        dt.Rows.Add(3, "Suzanne Mathews", "France");
        dt.Rows.Add(4, "Robert Schidner", "Russia");
        GridView1.DataSource = dt;
        GridView1.DataBind();

        string UserRole = "A";
        foreach (GridViewRow row in GridView1.Rows)
        {
            Button btnDelete = row.Cells[3].Controls[0] as Button;
            if (UserRole == "U")
            {
                btnDelete.Visible = true;
            }
            else if (UserRole == "A")
            {
                btnDelete.Visible = false;
            }
        }
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Dim dt As System.Data.DataTable = New System.Data.DataTable()
        dt.Columns.AddRange(New System.Data.DataColumn(2) {
                            New System.Data.DataColumn("Id", GetType(Integer)),
                            New System.Data.DataColumn("Name", GetType(String)),
                            New System.Data.DataColumn("Country", GetType(String))})
        dt.Rows.Add(1, "John Hammond", "United States")
        dt.Rows.Add(2, "Mudassar Khan", "India")
        dt.Rows.Add(3, "Suzanne Mathews", "France")
        dt.Rows.Add(4, "Robert Schidner", "Russia")
        GridView1.DataSource = dt
        GridView1.DataBind()
        Dim UserRole As String = "A"
        For Each row As GridViewRow In GridView1.Rows
            Dim btnDelete As Button = TryCast(row.Cells(3).Controls(0), Button)
            If UserRole = "U" Then
                btnDelete.Visible = True
            ElseIf UserRole = "A" Then
                btnDelete.Visible = False
            End If
        Next
    End If
End Sub

dharmend...

0 6

Reply
ANSWER
User: dharmendr
Replied: on Jul 10, 2020 05:56 AM
Report

Use the below code.

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.BindGrid();
        foreach (GridViewRow row in AdminGrid.Rows)
        {
            Button btnDelete = row.Cells[4].Controls[0] as Button;
            string UserRole = (row.FindControl("Label2") as Label).Text.Trim().ToUpper();
            if (UserRole == "A")
            {
                btnDelete.Visible = true;
            }
            else if (UserRole == "U")
            {
                btnDelete.Visible = false;
            }
        }
    }
}

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Show Hide GridView CommandField Button based on user Role using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us