Conditionally hide CommandField or ButtonField in Gridview

Question

I have a GridView displaying person records   I want to conditionally show a CommandField or ButtonField based on some property of the underlying record  The idea is to only allow a command to be performed on specific people   What is the best way to do this  I d prefer a declarative solution to a procedural one

User · Accepted Answer

First  convert your ButtonField or CommandField to a TemplateField  then bind the Visible property of the button to a method that implements the business logic    lt asp GridView runat  server  ID  GV1  AutoGenerateColumns  false  gt       lt Columns gt           lt asp BoundField DataField  Name  HeaderText  Name    gt           lt asp BoundField DataField  Age  HeaderText  Age    gt           lt asp TemplateField gt               lt ItemTemplate gt                   lt asp Button runat  server  Text  Reject                   Visible   lt    IsOverAgeLimit  Decimal Eval  Age      gt                    CommandName  Select   gt               lt  ItemTemplate gt           lt  asp TemplateField gt       lt  Columns gt   lt  asp GridView gt    Then  in the code behind  add in the method   protected Boolean IsOverAgeLimit Decimal Age        return Age  gt  35M      The advantage here is you can test the IsOverAgeLimit method fairly easily

User · Answer

Allow me to share my approach for what it s worth  For me converting the commandfield to a templatefield control is not an option  as the commandfield comes with built-in functionality that I would otherwise have to create myself  for example the fact that it changes to  Update Cancel  when Edit is clicked  and that when Edit is clicked  all the cells in the row which are labels become textboxes  etc     In my approach  you can leave the commandfield as is  then you can hide it as needed via code behind  In this example  I am hiding it if the field  Scenario  of the grid shows the text  Actual  for the relevant row of the RowDataBound event   protected void gridDetail RowDataBound object sender  GridViewRowEventArgs e                   if  e Row RowType    DataControlRowType DataRow                        if    Label e Row FindControl  lblScenario    Text     Actual                                 LinkButton cmdField   LinkButton e Row Cells 0  Controls 0                   cmdField Visible   false

User · Answer

You can hide a CommandField or ButtonField based on the position  index  in the GridView   For example  if your CommandField is in the first position  index   0   you can hide it adding the following code in the event RowDataBound of the GridView   protected void GridView1 RowDataBound object sender  GridViewRowEventArgs e        if  e Row RowType    DataControlRowType DataRow                  System Web UI Control e Row Cells 0  Controls 0   Visible   false

User · Answer

I have done a very simple thing to enable or disable command button  Below is my grid   lt asp GridView ID  grdOrderProduct  runat  server  TabIndex  1  BackColor  White  BorderColor   CEC9EF  CssClass  table table-striped dataTable table-bordered    OnRowEditing  grdOrderProduct RowEditing  OnRowUpdating  grdOrderProduct RowUpdating  OnRowDeleting  grdOrderProduct RowDeleting  OnRowDataBound  grdOrderProduct RowDataBound    Width  100   CellPadding  3  CellSpacing  1  BorderWidth  0  AutoGenerateColumns  False  gt           lt HeaderStyle   gt           lt AlternatingRowStyle   gt           lt Columns gt           lt asp BoundField DataField  ProductSKU  ReadOnly  true  HeaderText  Product SKU  HeaderStyle-CssClass  headTb4    gt            lt asp BoundField DataField  ProductName  ReadOnly  true  HeaderText  ProductName  HeaderStyle-CssClass  headTb4    gt            lt asp BoundField DataField  QTY  HeaderText  QTY  HeaderStyle-CssClass  headTb4    gt            lt asp BoundField DataField  Discount  HeaderText  Discount    HeaderStyle-CssClass  headTb4    gt            lt asp BoundField DataField  TPrice  HeaderText  MRP  ReadOnly  true  HeaderStyle-CssClass  headTb4    gt             lt asp CommandField ShowEditButton  true  ButtonType  Image  EditImageUrl    Images edit png                    UpdateImageUrl    Images gear png  CancelText     HeaderStyle-CssClass  headTb4                    ShowDeleteButton  true  DeleteImageUrl    Images delete png                    HeaderText  Action  ItemStyle-HorizontalAlign  Center  gt        lt HeaderStyle CssClass  headTb4    gt        lt ItemStyle HorizontalAlign  Center    gt        lt  asp CommandField gt      lt  Columns gt   lt AlternatingRowStyle CssClass  odd    gt   lt PagerStyle HorizontalAlign  Center  VerticalAlign  Top  Wrap  False    gt      In the following method i have done the changes   protected void grdOrderProduct RowDataBound object sender  GridViewRowEventArgs e                if  e Row RowType    DataControlRowType DataRow                                             foreach  ImageButton button in e Row Cells 5  Controls OfType lt ImageButton gt                                           if  button CommandName     Delete                                                 button Visible   false

User · Answer

Convert the CommandField to a TemplateField and set the visible property of the button based on the value of the field  true false    lt asp Button ID  btnSelect   runat  server  Text  Select   Visible   lt    DataBinder Eval Container DataItem  IsLeaf     gt    gt

User · Answer

lt asp GridView ID  gv Document  CssClass  gridstyle  runat  server  OnRowDataBound  gv Document RowDataBound  AutoGenerateColumns  false  DataKeyNames  SourceGUID Source FilePath  ShowHeaderWhenEmpty  false  OnRowDeleting  gv Document RowDeleting  gt      lt Columns gt          lt asp BoundField HeaderText  ItemID  DataField  ItemID  ItemStyle-CssClass  hidden-field  HeaderStyle-CssClass  hidden-field    gt          lt asp BoundField HeaderText  SourceGUID  DataField  SourceGUID  ItemStyle-CssClass  hidden-field  HeaderStyle-CssClass  hidden-field    gt          lt asp BoundField HeaderText  Source  DataField  Source  ItemStyle-CssClass  hidden-field  HeaderStyle-CssClass  hidden-field    gt              lt asp TemplateField HeaderText    gt                  lt ItemTemplate gt                       lt asp HyperLink ID  hyperLink  runat  server  Target   blank  NavigateUrl   lt    Bind  FilePath    gt                                                                   Text   lt    Bind  FileName    gt   gt    lt  asp HyperLink gt                  lt  ItemTemplate gt              lt  asp TemplateField gt         lt asp BoundField HeaderText  Type  DataField  FileExtension  ItemStyle-CssClass  hidden-field  HeaderStyle-CssClass  hidden-field    gt         lt asp BoundField HeaderText  Content type  DataField  FileMimeType  ItemStyle-CssClass  hidden-field  HeaderStyle-CssClass  hidden-field    gt         lt asp BoundField HeaderText  File Path  DataField  FilePath  ItemStyle-CssClass  hidden-field  HeaderStyle-CssClass  hidden-field    gt         lt asp CommandField ShowDeleteButton  True  DeleteText  Delete    gt      lt  Columns gt      Use this code to disable delete button in gridview from code behind   protected void gv Document RowDataBound object sender  GridViewRowEventArgs e         if  e Row RowType    DataControlRowType DataRow                  LinkButton e Row Cells 7  Controls 0   Visible   false

User · Answer

If this was based on roles you could use the multiview panel but not sure if you could do the same against a property of the record   However  you could do this via code   In your rowdatabound event you can hide or show the button in it

User · Answer

Hide the Entire GridView Column  If you want to remove the column completely  i e  not just the button  from the table then use a suitable event handler  e g  for the OnDataBound event  and then hide the appropriate column on the target GridView  Pick an event that will only fire once for this control  i e  not OnRowDataBound   aspx    lt asp GridView ID  grdUsers  runat  server  DataSourceID  dsProjectUsers  OnDataBound  grdUsers DataBound  gt       lt Columns gt           lt asp TemplateField HeaderText  Admin Actions  gt               lt ItemTemplate gt  lt asp Button ID  btnEdit  runat  server  text  Edit    gt  lt  ItemTemplate gt           lt  asp TemplateField gt           lt asp BoundField DataField  FirstName  HeaderText  First Name    gt           lt asp BoundField DataField  LastName  HeaderText  Last Name    gt           lt asp BoundField DataField  Telephone  HeaderText  Telephone    gt       lt  Columns gt   lt  asp GridView gt    aspx cs   protected void grdUsers DataBound object sender  EventArgs e        try                  in this case hiding the first col if not admin         if   User IsInRole Constants Role Name Admin               grdUsers Columns 0  Visible   false            catch  Exception ex                   deal with ex

User · Answer

it could be done when the RowDataBound event fires    protected void GridView RowDataBound Object sender  GridViewRowEventArgs e          if e Row RowType    DataControlRowType DataRow                 Hide the edit button when some condition is true          for example  the row contains a certain property       if  someCondition                     Button btnEdit    Button e Row FindControl  btnEdit               btnEdit Visible   false                         Here s a demo page  markup   lt    Page Language  C   AutoEventWireup  true  CodeBehind  Default aspx cs  Inherits  DropDownDemo  Default    gt   lt  DOCTYPE html PUBLIC  -  W3C  DTD XHTML 1 0 Transitional  EN   http   www w3 org TR xhtml1 DTD xhtml1-transitional dtd  gt   lt html xmlns  http   www w3 org 1999 xhtml   gt   lt head id  Head1  runat  server  gt       lt title gt GridView OnRowDataBound Example lt  title gt   lt  head gt   lt body gt       lt form id  form1  runat  server  gt           lt asp GridView ID  GridView1  runat  server  AutoGenerateColumns  false  gt               lt Columns gt                   lt asp BoundField HeaderText  Name  DataField  name    gt                   lt asp BoundField HeaderText  Age  DataField  age    gt                   lt asp TemplateField gt                       lt ItemTemplate gt                                           lt asp Button ID  BtnEdit  runat  server  Text  Edit    gt                       lt  ItemTemplate gt                   lt  asp TemplateField gt               lt  Columns gt           lt  asp GridView gt       lt  form gt   lt  body gt   lt  html gt    Code Behind  using System  using System Collections Generic  using System Web UI WebControls   namespace GridViewDemo       public partial class  Default   System Web UI Page               protected void Page Load object sender  EventArgs e                        GridView1 DataSource   GetCustomers                GridView1 DataBind                       protected override void OnInit EventArgs e                        GridView1 RowDataBound    new GridViewRowEventHandler GridView1 RowDataBound               base OnInit e                      void GridView1 RowDataBound object sender  GridViewRowEventArgs e                        if  e Row RowType    DataControlRowType DataRow  return               int age              if  int TryParse e Row Cells 1  Text  out age                   if  age    30                                        Button btnEdit    Button  e Row FindControl  btnEdit                        btnEdit Visible   false                                       private static List lt Customer gt  GetCustomers                         List lt Customer gt  results   new List lt Customer gt                  results Add new Customer  Steve   30                results Add new Customer  Brian   40                results Add new Customer  Dave   50                results Add new Customer  Bill   25                results Add new Customer  Rich   22                results Add new Customer  Bert   30                 return results                       public class Customer               public string Name  get set           public int Age   get  set             public Customer string name  int age                        Name   name              Age   age                      In the demo  the Edit Button is not Visible  the HTML markup is not sent to the client  in those rows where the Customer s age is 30

User · Answer

To conditionally control view of Template Command fields  use RowDataBound event of Gridview  like        lt asp GridView ID  gv1  OnRowDataBound  gv1 RowDataBound                runat  server  AutoGenerateColumns  False  DataKeyNames  Id   gt       lt Columns gt                                     lt asp TemplateField HeaderText  Order Status   HeaderStyle-HorizontalAlign  Center  ItemStyle-HorizontalAlign  Center  gt                     lt ItemTemplate gt                           lt asp Label ID  lblOrderStatus  runat  server  Text   lt    Bind  OrderStatus     gt   gt  lt  asp Label gt                     lt  ItemTemplate gt                    lt HeaderStyle HorizontalAlign  Center  gt  lt  HeaderStyle gt                    lt ItemStyle HorizontalAlign  Center  gt  lt  ItemStyle gt              lt  asp TemplateField gt                              lt asp CommandField ShowSelectButton  True  SelectText  Select    gt        lt  Columns gt                   lt  asp GridView gt    and following   protected void gv1 RowDataBound object sender  GridViewRowEventArgs e                Label lblOrderStatus  Label  e Row Cells 4  FindControl  lblOrderStatus             if  lblOrderStatus Text    Ordered                         lblOrderStatus ForeColor   System Drawing Color DarkBlue              LinkButton bt    LinkButton e Row Cells 5  Controls 0               bt Visible   false              e Row BackColor   System Drawing Color LightGray

[asp.net] Conditionally hide CommandField or ButtonField in Gridview

Examples related to asp.net

Examples related to gridview