Solved

Hide Select and Delete link buttons in asp.net gridview

Posted on 2010-11-17
5
430 Views
Last Modified: 2012-05-10
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

0
Comment
Question by:TonyReba
  • 3
  • 2
5 Comments
 
LVL 12

Expert Comment

by:jagssidurala
ID: 34157837
Before rendering the control hide two columns

GridView1.Columns[0].Visible = false;

GridView1.Columns[1].Visible = false;
0
 
LVL 9

Author Comment

by:TonyReba
ID: 34158069
Can you tell me in what lines do I need to place this?
0
 
LVL 12

Accepted Solution

by:
jagssidurala earned 500 total points
ID: 34158130
before this line

GridView1.RenderControl(hw)

any where you can write.
0
 
LVL 9

Author Comment

by:TonyReba
ID: 34158452
Can you tell me in what lines do I need to place this?
0
 
LVL 9

Author Closing Comment

by:TonyReba
ID: 34159594
perfect , that is what i was looking for!!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've been asked to discuss some of the UX activities that I'm using with my team. Here I will share some details about how we approach UX projects.
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
This video teaches users how to migrate an existing Wordpress website to a new domain.
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now