Hide Select and Delete link buttons in asp.net gridview

I am using a code to export my gridview to excel, everything works great both I dont want to disaplay first to columns in my excel exported file...

any suggestions?

Protected Sub btnExportExcel_Click(ByVal sender As Object, ByVal e As EventArgs)

        Response.Clear()
        Response.Buffer = True
        Response.AddHeader("content-disposition", "attachment;filename=PhysicianConcerns.xls")
        Response.Charset = ""
        Response.ContentType = "application/vnd.ms-excel"


        Dim sw As New StringWriter()
        Dim hw As New HtmlTextWriter(sw)
        GridView1.AllowPaging = False
        GridView1.AllowSorting = False
        GridView1.DataBind()


        'Change the Header Row back to white color 
        GridView1.HeaderRow.Style.Add("background-color", "#FFFFFF")


        'Apply style to Individual Cells 

        GridView1.HeaderRow.Cells(2).Style.Add("background-color", "teal")
        GridView1.HeaderRow.Cells(3).Style.Add("background-color", "teal")
        GridView1.HeaderRow.Cells(4).Style.Add("background-color", "teal")
        GridView1.HeaderRow.Cells(5).Style.Add("background-color", "teal")
        GridView1.HeaderRow.Cells(6).Style.Add("background-color", "teal")
        GridView1.HeaderRow.Cells(7).Style.Add("background-color", "teal")
        GridView1.HeaderRow.Cells(8).Style.Add("background-color", "teal")
        GridView1.HeaderRow.Cells(9).Style.Add("background-color", "teal")
        GridView1.HeaderRow.Cells(10).Style.Add("background-color", "teal")


        ' Find controls to hide

        Dim Links As LinkButton = GridView1.HeaderRow.Cells(0).FindControl("LinkButton1")

        Links.Enabled = False


        For i As Integer = 2 To GridView1.Rows.Count - 1

            Dim row As GridViewRow = GridView1.Rows(i)
            'Change Color back to white 
            row.BackColor = System.Drawing.Color.White
            'Apply text style to each Row 
            row.Attributes.Add("class", "textmode")

        Next

        GridView1.RenderControl(hw)

        'style to format numbers to string 

        Dim style As String = "<style>.textmode{mso-number-format:\@;}</style>"
        Response.Write(style)
        Response.Output.Write(sw.ToString())
        Response.Flush()
        Response.End()

    End Sub

Open in new window

LVL 9
TonyRebaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jagssiduralaConnect With a Mentor Commented:
before this line

GridView1.RenderControl(hw)

any where you can write.
0
 
jagssiduralaCommented:
Before rendering the control hide two columns

GridView1.Columns[0].Visible = false;

GridView1.Columns[1].Visible = false;
0
 
TonyRebaAuthor Commented:
Can you tell me in what lines do I need to place this?
0
 
TonyRebaAuthor Commented:
Can you tell me in what lines do I need to place this?
0
 
TonyRebaAuthor Commented:
perfect , that is what i was looking for!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.