How to display some column in grid view?

Question

I want display specific column in data grid view for profile of user after log in the system but my problem it is display all columns in C# with asp.net sql server, any one can help me?

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        if (Request.QueryString["MyID"] != null)
        {
            if (!IsPostBack)
            {
                string Id1 = Request.QueryString["MyID"];
                dt = d.userunfo(Id1);
                GridView1.DataSource = dt;
                GridView1.DataBind();
            }

        }
    }
}

Set `AutoGenerateColumns` to false and create TemplateFields. — VDWWD, Aug 07 '18 at 08:07
On this site are a few examples which should help you to accomplish this task. https://msdn.microsoft.com/en-us/library/aa479342.aspx — Schadensbegrenzer, Aug 07 '18 at 08:39

score 1 · Answer 1 · answered Aug 07 '18 at 08:06

1

Do you want this like?

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

You can check this answer.

GridView Hide Column by code

answered Aug 07 '18 at 08:06

Mustafa Tığ

101
1
12

score 1 · Answer 2 · answered Aug 07 '18 at 08:19

1

Make sure you have specified the Datasource property of column as database column name

answered Aug 07 '18 at 08:19

Nayan

84
6

ArunPratap · Answer 3 · 2019-02-15T06:53:54.010

Add OnRowDataBound of your GridView

<asp:GridView ID="GridViewID" runat="server" OnRowDataBound="gvTest_RowDataBound" >

in RowDataBound

First, check the roles of user and then you can check the condition and hide your column

protected void GridView_RowDataBound(object sender, GridViewRowEventArgs e)
 {
  //check User Type
   int userType = //Your User Type Here;
   if (userType == 1)
    {
      GridViewID.Columns[15].Visible = false;
    }
   else if (userType == 2 || userType == 3)
    {
     GridViewID.Columns[5].Visible = false;
     GridViewID.Columns[6].Visible = false;
    }                                                                                                                                     
  }

How to display some column in grid view?

3 Answers3