How To Hide Columns In A Bound Gridview With No Rows

Oct 24, 2011

I've got a grid view on my form that is bound to a data table at run tim. The data table is returned by a function rather than direct from the DB so I can't set the datasource at runtime.

I bind the grid in the page_load event like this:-

Code:
Dim _dt As System.Data.DataTable
_dt = _srvc.GetVinylShutters(0)
_dt.Rows.Add(_dt.NewRow)
grdShutters.DataSource = _dt
grdShutters.DataBind()
(_dt.Rows.Add(_dt.NewRow) is just there to add a blank row in, otherwise I wasn't seeing any columns at all)

I've then got the following snippet which I want to use to hide some underlying columns:-

Code:
For Each col As DataControlField In grdShutters.Columns
Select Case col.HeaderText
Case "OrderID", _
"ShutterID", _
"ModelID", _

[Code] ...

The thing is, wherever I put this it doesn't seem to hide the columns. If I break into the code I can see that grdShutters.Columns.Count equals zero althought I can see that the bound datatable has 38 columns.

I've tried the Page's Load, LoadComplete and PreRenderComplete events as well as the gridview's DataBound, RowDataBound and RowCreated events. I get teh same result in all of them. The grid doesn't actually have any columns until it appears on the screen.

View 7 Replies


Similar Messages:

Forms Data Controls :: How To Convert Gridview Rows To Columns And Columns To Rows

Mar 4, 2011

I'm binding a gridview from a webservice with 30 columns and 10 rows, I need to print the same in a PORTRAIT, for that i decided to display columns as rows and

rows as columns like below:

EMP1 1 2 3 4
EMP2 1 2 3 4

View 3 Replies

Forms Data Controls :: In Page User Able To Select Gridview Columns And It Will Hide Remaining Columns

Mar 18, 2010

in asp.net page user able to select gridview Columns, and it will hide remaining columns and that selection done by check box with column list bellow is Image link , what exactly I am looking for [URL] it look bellow after selection of column done [URL]

View 1 Replies

Hide Columns In GridView With Auto - Generated Columns?

Jan 19, 2010

GridView1.Columns.Count is always zero even SqlDataSource1.DataBind();

But Grid is ok I can do

for (int i = 0; i < GridView1.HeaderRow.Cells.Count;i++)

I rename request headers here but

GridView1.Columns[i].Visible = false;

I can't use it because of GridView1.Columns.Count is 0. So how can I hide them ?

View 5 Replies

Javacript With A Gridview / Values Of The Bound Columns?

Apr 14, 2010

I have got a simple gridview two bound columns and one template column with a textbox.

I need to get the values of the bound columns is this possible. I need to times the textbox with the bound column value

Now i can get the textbox value using

// var sumInput = null;
// var tempValue = 0.0;
// var retail = 0.0;
// function Load(sender, args) {
// sumInput = sender;
// }
// function Blur(sender, args) {
// sumInput.set_value(tempValue + (sender.get_value()));
// }
// function Focus(sender, args) {
// tempValue = sumInput.get_value() - (sender.get_value());
// }

View 4 Replies

FindControl Not Working On GridView When Inserting Bound Columns

Nov 8, 2010

I have a gridview with several ItemTemplates. The first contains a checkbox the rest contain textboxes. I then added dynamically some bound controls like this:

BoundField bdfPrivName = new BoundField();
clsUtilities.SetBoundFieldCenter(ref bdfPrivName, "PrivName", "Priv Name");
BoundField bdfDescription = new BoundField();
clsUtilities.SetBoundFieldLeft(ref bdfDescription, "PrivDesc", "Description");
BoundField bdfLive = new BoundField();
clsUtilities.SetBoundFieldCenter(ref bdfLive, "Live","Active?");
grdExisting.Columns.Add(bdfPrivName);
grdExisting.Columns.Add(bdfDescription);
grdExisting.Columns.Add(bdfLive);

I then use FindControl() to locate the checkbox and textboxes and perform my logic based the result
foreach (GridViewRow gvr in grdMissing.Rows) {
mckbAny = (CheckBox)gvr.FindControl("ckbAdd");
mtxtApplyDate = (TextBox)gvr.FindControl("txtAddApplyDate");
mtxtDateToAdd = (TextBox)gvr.FindControl("txtAddDateToAdd");
mtxtDateToRemove = (TextBox)gvr.FindControl("txtAddDateToRemove");
}
etc.

This all worked fine. I then got a request to put the bound fields as the second, third and fourth columns, after the check box and before the textboxes. I found that this was easy to do by changing the Add's to Inserts as follows:
grdExisting.Columns.Insert(1, bdfPrivName);
grdExisting.Columns.Insert(2, bdfDescription);
grdExisting.Columns.Insert(3, bdfLive);
It looked fine of the page, but the FindControl(), all of them fail to work.

View 2 Replies

GridView Adding Additional Rows In Row Data Bound Event

Nov 1, 2012

I have a gridview that I bind on Page Load event.In the rowdatabound event I want to add a row to the gridview and bind it based on the value of the current record.The row is not being added. Is there a way to bind the extra row in the rowdatabound event?

Private Sub grdDocuments_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles grdDocuments.RowDataBound
If e.Row.RowType = DataControlRowType.DataRow Then
Dim dt As DataTable
Dim dv As DataView = grdDocuments.DataSource

[code]...

View 1 Replies

C# - Hide Columns By Id In Gridview?

Mar 17, 2011

I have the asp.net application where I am having the editable grid view with the edit,Delete,Add options. this grid having as usual Template fields . I want to hide some columns. I know i can do that by using columns index. but i don't want to follow it. instead I want to hide columns by Id. this is because if in my application further I need to add more columns then there is need to change the code gain and again in the core. so I am choosing this way. Bu as i found <asp:TemplateField /> does not contain Id attribute. so it is become impossible for me to hide <asp:TemplateField/> by Id.

View 3 Replies

Web Forms :: Cannot Hide Columns On GridView

Mar 25, 2011

I have a GridView that is successfully populated by an IList. IThere are about 2 dozen columns I only need 8. I am trying to call:

this.grdView.Columns[0].Visible = false;

But I get an index out of range error. And when I call, this.grdView.Columns.Count I get 0.

I have tried this on several events including: grdView_RowDataBound

View 3 Replies

How To Use ColumnName In GridView Control To Hide Some Columns

Aug 11, 2010

I want to hide few columns of a gridview before they gets displayed. I want to do it by create a common function which can be used by multiple controls. I am using an extension and would like to know how it can be done.

Here is my code

[Code]...

I want to create an extension to hide or show columns provided in the list as an array. 1st function is used on page. While below two functions are needs to be used for multiple applications

View 1 Replies

Data Controls :: Conditionally Hide Columns In GridView

Sep 14, 2013

My grid view will display the data like below..

Id  Name Mark1 Mark2 Mark3

1     aaa      50     30      20
2    bbb      50     30      30
3     ccc      50     30      20

if mark3 has all fields with 0 means i want to hide column mark3. How to do this..

View 1 Replies

Forms Data Controls :: Hide Columns In Gridview When Empty?

Feb 16, 2010

I have a Gridview and I want to hide a column when empty. The code works then the column is in Boundfield but not in Templatefield. Can anyone show me the code of how to do it in Templatefield?

Here's my code using OnDataBound event:

protected void hideColumn(object sender, EventArgs e)

View 4 Replies

VS 2008 Gridview - Hide Certain Columns And Change Column Names

Jun 15, 2012

I have a gridview that I am loading from a stored procedure. I need to be able to hide certain columns and change the column names. Since it is loading with stored procedure the columns aren't listed in the gridview->edit columns properties.

View 1 Replies

Forms Data Controls :: Hide Rows In A Gridview?

Jan 21, 2010

I have developed a gridview that groups rows together based upon a field in the gridview. To separate each group, I have inserted a row that contains the name of the group.

However, I have hit a problem, what I need to do is to have an image button on the row I have inserted between the groups, which when clicked will hide and show the rows in that group in a toggle fashion. I can get the start of the row for a group, but I am unable to work the number of rows in a group and to then show and hide the rows in that group.

View 10 Replies

C# - Programmatically Add Rows To GridView With Predefined Columns?

Feb 22, 2011

Given a GridView control defined like this:

[code]....

The "FilePath" and "AttachmentID" fields are being set correctly in the grid, however, the CheckBox control is never set correctly; it is always unchecked.

My question:

How do I get this CheckBox field set from C# as I'm creating the new row?

P.S. I am not sure if I am creating the row correctly in the first place.

View 2 Replies

C# - GridView Getting Height And Width Of Columns / Rows?

Jul 22, 2010

I am trying to set the top gridview's column's width to the body's column width and then the left columns height to the body's coloumns height. Here is my code:

<form id="form1" runat="server">
<div>
<asp:Table ID="Table1" runat="server">
<asp:TableRow>

[Code]....

View 1 Replies

Forms Data Controls :: Hide / Show Gridview Columns Using Javascript?

Jul 15, 2010

I have a webpage that lists information about trucks and their map sections and whether the combination is active and will be used.

On the page I put a check box that says Show Only Active and marked the checked property as true by default. When the RowDataBound event fires I check to see if that checkbox is marked as true and if it is I check if the individual map sections are marked as active. If they are not active then I set the row visibility equal to false like below.

[code]....

View 1 Replies

Forms Data Controls :: How To Show / Hide Columns Conditionally In Gridview

May 24, 2010

dv = new DataView(table);
Table.Columns.Add("ID", typeof(string));
table.Columns.Add("Type", typeof(string));
table.Columns.Add("EmpName", typeof(string));
table.Columns.Add("Manager", typeof(string));
row = table.Rows.Add();
row["ID"] = result["ID"].ToString();
row["Type"] = result["Type"].ToString();
row["EmpName"] = result["EmpName"].ToString();
row["Manager"] = result["Manager"].ToString();

Then I am adding boundfield to gridview for all 4 columns. Now I want to check if "Type" column contain "Sales" thne do not show "Manager" columns. Let me know can I do this?

View 4 Replies

Forms Data Controls :: Use JavaScript To Hide Rows In A Gridview?

Feb 8, 2010

I have a gridview, which has a hidden column, and I am using this column with the value contained within as a flag. What I would like to do is to use this hidden column with a LinkButton that will execute some JavaScript.

Can someone show me, or point me in a direction of an example, which goes through the rows of a gridview and can show or hide rows in a gridview based upon a value?

View 2 Replies

VS 2008 Hiding Columns In Gridview After Binding All Rows?

Jul 22, 2010

I am trying to set come columns to invisible after all of the rows are binded but I'm having trouble. I'm hiding columns that have empty data which I save in a session variable. This works fine. Then I tried changing the columns visible property using the ColumnByName routine in the DataBound but that must be the wrong event because I do not think the columns exist yet.

The columns are autogenerated btw.

Where can I set the columns properties after it has binded? Can i do this before the columns are autogenerated the the screen itself?

View 4 Replies

Forms Data Controls :: Show/Hide Gridview Rows In JavaScript?

Apr 2, 2010

On a page of my project, i have a gridview, i need to perform following operations with it:

1. On Page_Load i want to bind all the data (100 Rows) with the gridview.

2. On my Page i want to show only 4 records with Show More/Show Less Links.

3. When user clicks on the link, i want to show All data or 4 Rows accoeding to the link.

4. I don't want any roundTrip to the server, so plz don't suggest AJAX, i want to attain this by using Javascript.

View 3 Replies

Data Controls :: Hide GridView Rows Conditionally In RowDataBound Event

Jul 30, 2013

On Row databound i want to show some rows in If and Hide in some rows in else conditon. But it generate an exception that (Index was out of range. Must be non-negative and less than the size of the collection Parameter name: index.

protected void gvHotels_RowDataBound(object sender, GridViewRowEventArgs e)
{
DataTable dt = new DataTable();
if (e.Row.RowType == DataControlRowType.DataRow)

[code]...

View 1 Replies

Forms Data Controls :: When Updating Gridview When Hide Columns Values Turn To Null?

Mar 5, 2010

I am updating a gridview. Problem is that when I hide certain fields that I do not want the user to update, they lose their values ie. the data is wiped out in the field unless I show them on the grid and make them writeable. Is there a property I need to set for the field to retain the value when the grid is updated or is this in the sql statement?

View 7 Replies

Data Controls :: Show Only Specific Columns And Hide Others When Sending GridView In Email Body

Jun 17, 2012

i have done sending gridview data  as excel  to mail, it is working fine

then  i had 5 columns in gridview but i want to send 4 column instead of 5 column.

protected void Button1_Click(object sender, EventArgs e)
{
fn_AttachGrid(); // here calling function to send mail gridview data as excel format
}

[Code]....

View 1 Replies

Freeze Columns In Gridview Where Grid Has Static Height And All Rows Are Rendered?

Feb 23, 2011

I'm trying to freeze columns in gridview where grid has static height and all rows are rendered(no paging and scroll var is visible).I only managed to add scroll through content by overflow property,but this time all columns are scrolling as well.My task is to freeze columns while maintaining column width.Let this be my grid

<div style="height:200px;overflow:auto;">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
UseAccessibleHeader="true or false">

[code]...

View 1 Replies







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