Hide column based on label value in gridview

See more:

ASP.NET

Gridview

data-binding

i have gridview with 12 column and one of the column have 3 value "ex1" "ex2" "ex3"
i want if ex1 apppear hide some columns , if ex2 appear hide others columns and so on

i try using row roundabout but dint work nothing is hiding

What I have tried:

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
  {
      if (e.Row.RowType == DataControlRowType.DataRow)
      {
          Label lbl = e.Row.FindControl("Label1") as Label;
          for (int i = 0; i < GridView1.Columns.Count; i++)
          {
              if (lbl.Text == "Client")
              {
                  GridView1.Columns[13].Visible = false;
              }
          }



      }
  }