Data Controls :: How To Avoid Exporting Certain Column Headers In GridView

Oct 9, 2012

I have boundfiled column inside gridview and made the column as invisible by setting visible="false".

But while exporting the gridview to excel I am getting the Header text alone exported. Wherever the column's visibility is set to false the header text should not be exported. After binding the gridview I have set the column's visiblity to false so it won't export the column values.

The problem is to stop exporting the header text to excel. Let's say column index is 10

public class GridViewExportUtil
{

public static void Export(string fileName, GridView gv)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader(
"content-disposition", string.Format("attachment; filename={0}", fileName));

[CODE]...

View 1 Replies


Similar Messages:

Forms Data Controls :: Multiple Column Headers In Gridview?

Sep 17, 2010

I've been trying for the past few hours to add mutliple headers to my grid view but keep failing to get it to show. There's plenty of examples online that I found but can't seem to get the most simplest to work. Below is the code I've been using with no success. I even tried changing the "TableCell" o "TableHeaderCell" but still yields no headers as expected. Anyone know what I could be doing wrong?

[Code]....

View 16 Replies

Data Controls :: JavaScript And CSS When Freezing GridView Column Headers

Jan 25, 2012

I recently applied a javascript code from article "Dynamically freeze ASP.net Gridview header using Javascript" found here, ASP Snippets Article, to my page. The javascript works great, but somehow, it's overriding my CSS code for the headers.  When I refresh the page, I can see the headers with my CSS in place for just a fraction of a second before it is replaced with generic styling.  I am not a javascript person, so really can't troubleshoot the problem.  I have a style sheet with the following code.

.dGrid {
width: 983px;
background-color: #ffffff;

[Code]......

View 1 Replies

Forms Data Controls :: Get Gridview Column Headers When Creating Dynamic Columns?

Mar 16, 2011

i have a gridview which is populated from a stores proc using pivot tables. The column are created dynamically apart from a total column which is created as a template field. the gridview looks like below:

CPW
EE
Foh
H3G
IND
O2
ORG
P4U
T-M
TSC
VIR
VOD
Total

Stores Visited

70
0
0
12
0
16
18
7
11
1
2
8
145

i need to add a hyperlink to each gridview cell and when that cell is clicked pass the header text through the querystring to another page. I can access the cells value ok and pass that through but i cannot seem to access the cells column header text. when i response.write out a count of the gridview.columns it brings back 2 which is the template fields but not the dynamic fields i have tried this on the rowdatbound, rowcreated, page_load and page_unload. the count should be 12 its like it cannot find the dynamic columns at all. ?

here is my code for populating the gridview

[Code]....

and here is my gridview:

[Code]....

i am also moving the total column in this code

[Code]....

and calculating my total in this code and adding my link to the total colum (which works fine)

[Code]....

now i just need to somehow add a link to the other cells and somehow get the value of the header text for that cell clicked.

View 2 Replies

Data Controls :: Scrollable GridView With Fixed Headers - Header Column Alignment

Jan 16, 2014

Scrollable GridView with Fixed Headers inside ASP.Net UpdatePanel using jQuery Plugin. I have one more question in that.  How to adjust the width of the columns headers because for some of my gridviews the headers not showing the proper format.  in the gridview I gave HorizontalAlign="Left" and in the columns I gave 

<asp:BoundField DataField="XXX" HeaderText="XXX" ItemStyle-Width="150px" HeaderStyle-HorizontalAlign="Left" />  

It's not showing in the correct fomart. header is coming to the left side and data is coming to the right side...

View 1 Replies

Forms Data Controls :: GridView Showing Empty Data Text Along With All The Column Headers

Jul 21, 2010

I just hit the same problem as described here: [URL] - GridView paging with ObjectDataSource. I see the column headers but no data, and I know for a fact my method returns a DataTable with data in it.

View 1 Replies

Forms Data Controls :: Show Column Headers When Gridview Returns Empty Data Set?

Oct 15, 2010

I have in my code a gridview that I redirect to excel, it works fine when I have data in the data set. waht I want is to show column headers when there is no data right now what i get is empty sheet.

View 7 Replies

Data Controls :: Add Custom Column While Exporting Excel From GridView

May 7, 2015

I am able to save excel sheet from GridView perfectly. However, I need to add one custom column, which will be URL of a file on sever, I am not allowed to add URLs directly in the table (as per company's development policies). I tried pulling URL from web.config however I am not sure where to add that in the following code

<asp:GridView ID="bestpractgrv" runat="server" AutoGenerateColumns="False" CellPadding="3" GridLines="Vertical" Width="100%" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" PageSize="10" AllowPaging="True" OnPageIndexChanging="OnPaging" DataKeyNames="iID">
<AlternatingRowStyle BackColor="Gainsboro" />
<Columns>

[code]....

View 1 Replies

Forms Data Controls :: Removing The Blank Column From Gridview And From Exel Also While Exporting Data?

Oct 29, 2010

I have a requirement that i need to remove the columns from gridview which are blank but at remove funtion it gives me error so i make that columns visible false now its working fine but at the time of exporting data from gridview to excel it also export that visible= false columns in spredsheet and i don't want that blank or hidden column in my excel sheet

View 2 Replies

Forms Data Controls :: Add A 'free Format TextBox' To 3 Of The Column Headers?

Sep 1, 2010

I have the following gridView and I would like to add a 'free format textBox' to 3 of the column headers, to allow filtering. Much like here If I could/somehow achieve this that would be amazing. I can't use dropDown lists like many of the examples I have found as these lists would be too populated and proving too unfriendly to use.

[Code]....

View 2 Replies

GridView With Filtering In The Column Headers?

Aug 1, 2010

I need to use a grid that allows for filtering in the column headers. I know there are some third-party components out there that cost money. I am looking for something that is free / open-source that can be used on a project. Is anyone aware of a GridView that can do this?

View 2 Replies

Forms Data Controls :: 2 Headers And After Some Sort Of Amount Of Records The Headers Will Repeat Again?

Mar 20, 2010

I have never work with a repeater and after a lot of research I got to the conclusion that this is the control I need to use for what I have to do. I need display data but I will need 2 headers and after some sort of amount of records the headers will repeat again. In this page you will find an example of what I'm trying to do http://ratings.fide.com/view_source.phtml?code=45276 I don't know if a repeater is the right control but i thin it is.

View 3 Replies

How To Use DisplayName Data Annotations For Column Headers In WebGrid

Mar 9, 2011

I have a Car class that I'm trying to display in an MVC 3 view using the WebGrid helper. Below are the Car and it's metadata class.

Car class:

[MetadataType(typeof(CarMetadata))]
public partial class Car
{
// car implementation
}
Car metadata class:
public class CarMetadata
{
[DisplayName("Car Name")]
[StringLength(100, ErrorMessageResourceType = typeof(ValidationText), ErrorMessageResourceName="CarNameDescriptionLength")]
[Required]
public string CarName { get; set; }
}

View contents:

@model List<Car>
...
var grid = new WebGrid(Model, canPage: true, rowsPerPage: 10);
grid.Pager(WebGridPagerModes.NextPrevious);
@grid.GetHtml(
htmlAttributes: new { id = "grid" },
columns: grid.Columns(
grid.Column("CarName", ?????)
));

GOAL: I'd like to figure out how to use the DisplayName data annotation as the column header text in the WebGrid (?????). Does anyone know how this is accomplished?

View 1 Replies

Forms Data Controls :: Fixed Headers In Gridview

Mar 25, 2011

I wanted to have fixed headers in grid view. I came across multiple solutions but none worked with IE 8 and Chrome. One of the best solutions is following:

<style type="text/css">
<!--
.DataGridFixedHeader {background-color: white; position:relative; top:expression(this.offsetParent.scrollTop);}
-->
</style>

View 3 Replies

Forms Data Controls :: Multi Sub Headers In Gridview

Jan 14, 2010

What is the best way to format a grid, (or any other control) in this format?

Header1 Header2
A B C D Header3 Header4 header5
row
row
row
row
row
Header3 Header4
row
eader5 Header6 header7 header8
row
row
row
footer data

is this format even possible?

View 3 Replies

Forms Data Controls :: Textboxes In Gridview Headers

Sep 14, 2010

I have a couple of Textboxes in a Gridview header, mainly used to search for items in the dataset. This works fine; however, on Post Back, the textboxes do not hold the entered text. The View State is enabled for these control items.

View 4 Replies

Forms Data Controls :: Gridview Separators And Headers

Nov 18, 2010

I have the following output from a SQL Datasource that I would like to separate into the Giant Sets...

Giant Set 1 Exercise 1 10 reps
Giant Set 1 Exercise 2 15 reps
Giant Set 1 Exercise 3 10 reps
Giant Set 2 Exercise 1 15 reps
Giant Set 2 Exercise 2 15 reps
Giant Set 2 Exercise 3 15 reps

So I want it to look like this...

Giant Set 1
Exercise 1 10 reps
Exercise 2 15 reps
Exercise 3 10 reps

Giant Set 2
Exercise 1 15 reps
Exercise 2 15 reps
Exercise 3 15 reps

Is this possible with a gridview?

View 2 Replies

Forms Data Controls :: Scrollable Gridview With Fixed Headers

Aug 5, 2010

I want scrollable gridview with fixed header. For that i create belw code

[Code]....

It works fine uptil page loads.I have functionality to delete rows from gridview.Once i click delete button from gridview the width of header columns get decreased then the width od data inside gridview.It means depending on the content of data the size gets variable.HOW to show data inside gridview irrespective of the content of data.

View 9 Replies

Forms Data Controls :: Shows A Gridview (headers) Without Having Records?

May 11, 2010

I have written a code from here http://www.aspsnippets.com/Articles/Display-GridView-with-Empty-Message-and-Header-and-Footer-when-no-data-in-ASP.Net.aspx. I just edited this as follows. this is my gridview code:-

<asp:GridView ID="gvCustomers" runat="server" Width="550px" AutoGenerateColumns="false"
Font-Names="Arial" Font-Size="11pt" AlternatingRowStyle-BackColor="#C2D69B" HeaderStyle-BackColor="green"
AllowPaging="true" PageSize="10">
<Columns>
<asp:BoundField HeaderText="State Name" DataField="StateName" FooterText="Footer" />
<asp:BoundField HeaderText="Organizatio Name" DataField="OrganizatioName" FooterText="Footer" />
<asp:BoundField HeaderText="Partner Name" DataField="PartnerName" FooterText="Footer" />
</Columns>
<AlternatingRowStyle BackColor="#C2D69B" />
<EmptyDataTemplate>
<table cellspacing="0" rules="all" style="font-family: Arial;
font-size: 11pt; width: 550px; border-collapse: collapse;">
<tr style="background-color: Green;">
<th scope="col">
State Name
</th>
<th scope="col">
Organization Name
</th>
<th scope="col">
Partner Name
</th>
</tr>
<tr>
<td colspan = "3" align = "center">
No Data found.
</td>
</tr>
</table>
</EmptyDataTemplate>
</asp:GridView>

and my code file code is as follows
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["contest"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bind_Grid();
}
}
protected void Bind_Grid()
{
string strSql = "select * from mtblInformation";
SqlCommand com = new SqlCommand(strSql,con);
SqlDataAdapter sda = new SqlDataAdapter(com);
DataTable dt = new DataTable();
sda.Fill(dt);
if (dt.Rows.Count > 0)
{
gvCustomers.DataSource = dt;
gvCustomers.DataBind();
}
}

when in database table have records then gridview binds and its showing records, But when there is no record in DB , instead of showing msgs that "No Data found." gridview doesn't appear.

View 2 Replies

Forms Data Controls :: Dynamic Month Headers On Gridview

May 19, 2010

I would like to create a gridview which has as headers the last 12 months, which would need to change as time progresses... is it possible to do this?

View 24 Replies

Forms Data Controls :: Freezing Headers And Columns In A Gridview

Jun 25, 2010

Freezing Headers and Columns in a Gridview

[Code]....

View 8 Replies

Forms Data Controls :: Putting A Scroll Bar On A Gridview, And Fixing The Headers?

Jan 25, 2010

I have been looking through endless webpages trying to get a handle on putting a scroll bar on a gridview, and fixing the headers . I have tried following a few examples and had a working demo on a test page, however when I placed the code in the main page on a FormView i have come up with the following error on this procedure

[Code]....
[Code]....

View 4 Replies

Data Controls :: Adding Horizontal ScrollBar With Fixed Headers To GridView

May 7, 2015

Refer here: [URL] ....

What If i have many fields to be included in the gridview, so in that case I need HORIZONTAL SCROLL BAR. But I can't fixed the headers...

View 1 Replies

Data Controls :: When Applying Scrollable Gridview Headers Does Not Match With TemplateField

Feb 21, 2013

I used the link below [URL] .....

I have nearly 25 columns in my Gridview so when i apply the scrollable gridview the header does not align with template field.

View 1 Replies

Data Controls :: Implement Scrollable Nested GridView With Fixed Headers?

Nov 30, 2013

I try to make a combination of 2 of your articles

[URL]

It works but the column header width's are not matching the data columns.

When i take out the nested gridview it works fine.

Here's my code:

 <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
<script type="text/javascript">
$("[src*=plus]").live("click", function () {
$(this).closest("tr").after("<tr><td></td><td colspan = '999'>" + $(this).next().html() + "</td></tr>")
$(this).attr("src", "images/minus.png");

[code]....

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved