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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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