Dataset column hidding in GridView

Question

5.00/5 (1 vote)

See more:

Hi All,
am working with GridView and while binding dataset to grid i am setting column mapping to MappingType.Hidden for few columns but Gridview is showing all.
am not sure what is the issue. please if anyone tell me about the issue here.

code

VB

oDs.Tables(0).Columns("id").ColumnMapping = MappingType.Hidden
GridView1.DataSource = oDs
GridView1.DataBind()

i am not designing itemTemplate because grid is on master page and multiple pages are passing distict datasets to it. so can't set columns to visible = false.

Posted 20-Feb-12 19:55pm

Zubair Alie

Add a Solution

5 solutions

Solution 2

Use "GridView_RowDataBound" Event.

C#

protected void GridView_RowDataBound(object sender, GridViewRowEventArgs e)
{
    e.Row.Cells[index].Visible = false;
}

Put the index of column you want to hide.

Posted 20-Feb-12 20:31pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Solution 3

Show / Hide GridView Columns in ASP.NET[^]

Posted 20-Feb-12 20:34pm

Sudip Saha

Solution 4

hi,
try this...

VB

Gridview1.Columns(1).Visible = False

Posted 20-Feb-12 20:52pm

Ganesan Natarajan

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

beevif · Accepted Answer · 2012-02-20T20:20:00

Solution 1

Please try like this. Hope this will help you.

C#

foreach (DataColumn dc in oDs.Tables(0).Columns)
            {
                BoundColumn dgc = new BoundColumn();
                dgc.HeaderText = dc.ColumnName;
                dgc.DataField = dc.ColumnName;
                if (dc.ColumnName.Contains("Id"))
                    dgc.Visible = false;
                GridView1.Columns.Add(dgc);
            }

Posted 20-Feb-12 20:20pm

beevif

Updated 20-Feb-12 20:21pm

v2

Comments

Zubair Alie 21-Feb-12 5:28am

i resolved the issue by self but you provided much better solution than i produced
am adding my own solution in solution list. you may have a look on that too.

shaikh-adil 28-Nov-12 8:47am

+5

Zubair Alie · Accepted Answer · 2012-02-20T23:29:00

VB

Protected Sub GridView1_RowCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowCreated


        For Each col As DataColumn In CType(GridView1.DataSource, _
                                            DataSet).Tables(0).Columns
        If col.ColumnMapping = MappingType.Hidden Then
                e.Row.Cells(CType(GridView1.DataSource, _
                            DataSet).Tables(0).Columns.IndexOf(col.ColumnName) + 1)
                            .Visible = False
        End If
        Next
End Sub