Hide GridView Columns In ASP.NET

This example shows how to Hide GridView Columns in normal mode in asp.net and set them to visible when gridview is in edit mode. I am hiding the ID column when gridview loads and setting this column to visible when user clicks on the edit link button.

For this i am using ObjectDataSource to populate the grid and hiding columns in RowDataBound Event.

<asp:GridView ID="GridView1" runat="server"

              AutoGenerateColumns="False"

              DataSourceID="ObjectDataSource1"

              OnRowDataBound="GridView1_RowDataBound"

              OnRowEditing="GridView1_RowEditing">

<Columns>

<asp:CommandField ShowEditButton="true"/>

<asp:TemplateField HeaderText="ID">

<ItemTemplate>

<asp:Label ID="lblID" runat="server" Text='<%#Eval("ID")%>'/>

</ItemTemplate>

<EditItemTemplate >

<asp:TextBox ID="txtID" Visible="true" runat="server"

             Text='<%#Eval("ID")%>'/>

</EditItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Name">

<ItemTemplate>

<asp:Label ID="lblName" runat="server" Text='<%#Eval("Name")%>'/>

</ItemTemplate>

<EditItemTemplate >

<asp:TextBox ID="txtName" Visible="true" runat="server"

             Text='<%#Eval("Name")%>'/>

</EditItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="Location">

<ItemTemplate>

<asp:Label ID="lblLocation" runat="server" 

           Text='<%#Eval("Location")%>'/>

</ItemTemplate>

<EditItemTemplate >

<asp:TextBox ID="txtLocation" Visible="true" runat="server"

             Text='<%#Eval("Location")%>'/>

</EditItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"

                      InsertMethod="Insert"

                      OldValuesParameterFormatString="original_{0}"

                      SelectMethod="GetData"

                      TypeName="DataSet1TableAdapters.TestTableAdapter"

                      UpdateMethod="UpdateQuery">

<InsertParameters>

<asp:Parameter Name="ID" Type="Decimal" />

<asp:Parameter Name="Name" Type="String" />

<asp:Parameter Name="Location" Type="String" />

</InsertParameters>

<UpdateParameters>

<asp:Parameter Name="Name" Type="String" />

<asp:Parameter Name="Location" Type="String" />

<asp:Parameter Name="ID" Type="Decimal" />

</UpdateParameters>

</asp:ObjectDataSource>

We need to write following code to hide columns in RowDataBound event

C# CODE

---

show source

01protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

02    {

03        //Check whether gridview is in edit mode or nor

04        if (GridView1.EditIndex >= 0)

05        { return; }

06        //Check row state of gridview whether it is data row or not

07        if ((e.Row.RowState == DataControlRowState.Normal

08        || e.Row.RowState == DataControlRowState.Alternate)

09        && (e.Row.RowType == DataControlRowType.DataRow

10        || e.Row.RowType == DataControlRowType.Header))

11        {

12            //Now set the visibility of cell we want to hide to false

13            e.Row.Cells[1].Visible = false;

14        }

15    }

16 

17    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

18    {

19        GridView1.EditIndex = e.NewEditIndex;

20        GridView1.DataBind();

21    }

VB.NET

---

show source

01Protected Sub GridView1_RowDataBound(sender As Object, e As GridViewRowEventArgs)

02 'Check whether gridview is in edit mode or nor

03 If GridView1.EditIndex >= 0 Then

04  Return

05 End If

06 'Check row state of gridview whether it is data row or not

07 If (e.Row.RowState = DataControlRowState.Normal OrElse e.Row.RowState = DataControlRowState.Alternate) AndAlso (e.Row.RowType = DataControlRowType.DataRow OrElse e.Row.RowType = DataControlRowType.Header) Then

08  'Now set the visibility of cell we want to hide to false

09  e.Row.Cells(1).Visible = False

10 End If

11End Sub

12 

13Protected Sub GridView1_RowEditing(sender As Object, e As GridViewEditEventArgs)

14 GridView1.EditIndex = e.NewEditIndex

15 GridView1.DataBind()

16End Sub

Download Sample Code

Tweet

If you like this post than join us or share