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
Similar Messages:
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
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
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
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
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
Dec 8, 2010
I have gridView with 4 columns. I am fetching data from sql. Now i want to insert into grid using column-name.
Example: if column is EmployeeID then cell value to be added to that column else if column-name is Salary then salary to be added to the column.
EmployeeID EmployeeName Salary Address
E-028458
View 4 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
Nov 26, 2010
I need to create one custom text box control which should be bind with data base.
I am referring following link...
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.databoundcontrol.aspx
I used DataBoundControl to create my control but i am not able to do it properly.
public class SimpleTextBoxControl : DataBoundControl
{
private TextBox nameTextBox;
public string DataTextField
{
get
{
object o = ViewState["DataTextField"];
return ((o == null) ? string.Empty : (string)o);
}
set
{
ViewState["DataTextField"] = value;
}
}
[
Bindable(true),
Category("Data"),
DefaultValue(""),
Description("The text to display on the link."),
Localizable(true),
PersistenceMode(PersistenceMode.InnerDefaultProperty)
]
public virtual string DataTexValue
{
get
{
string s = (string)ViewState["Text"];
return (s == null) ? String.Empty : s;
}
set
{
ViewState["Text"] = value;
}
}
protected override void PerformDataBinding(IEnumerable retrievedData)
{
if (retrievedData == null)
return;
base.PerformDataBinding(retrievedData);
Controls.Clear();
nameTextBox = new TextBox { ID = "nameTextBox" };
foreach (object dataItem in retrievedData)
{
if (DataTextField.Length > 0)
{
nameTextBox.Text = DataBinder.GetPropertyValue(dataItem, DataTextField, null);
}
DataTexValue = nameTextBox.Text;
}
this.Controls.Add(nameTextBox);
}
}
View 1 Replies
Mar 4, 2011
I am working with a gridview that pulls data from a SQL database based on selections in dropdown lists. The source table has six columns for attributes of the selection, but depending on what is chosen, there could be anywhere from one to six of those that are empty (all null values). When the column is empty, I would like to have it hidden so the page is less clunky and confusing.
I've searched around for an answer for the past couple days, but what I have found so far is either related to hiding columns that you know are empty which I will not know or removing them in the SQL code which I think doesn't work if the column is called for in the gridview code and doesn't exist in the query.
View 3 Replies
Oct 8, 2010
I have written a web usercontrol (ascx). Inside, there is a Panel that I want to show/hide on click of a hyperlink inside the usercontrol.
Normally, this is easy just by doing something like this (the onclick attribute is added to the hyperlink on prerender):
var PanelToShow = document.getElementById('<%=PanelInvoiceHasBeenCreated.ClientID %>');
if (PanelToHide != null) {
PanelToHide.style.display = 'none';
}
but because the ascx control is held within the gridview, the above will assess all the controls (of which there are many in the gridview) with the name 'PanelInvoiceHasBeenCreated'. The only time it will work is when there is 1 row in the gridview. Currently, with my existing code, if I click the hyperlink in any row, it shows/hides the panel in the bottom row of the gridview!
Therefore, my question is how do I get the actual, unique ID I need to show/hide on the correct control in the correct row?
View 2 Replies
Jan 7, 2011
Suppose I have a DetailsView, which is bound to a SQLDataSource. The underlying table has two columns, an ID and a value. When in display mode, I want to display only the value. When I switch the DetailsView to edit mode, I want the user to edit the value, and not see or edit the ID. Making the ID column not visible solves this, EXCEPT that then the ID value is not stored in the DetailsView so two-way binding does not work, and I can't update the corresponding DB record. How do I do two-way data binding with a DetailsView, but hide the ID column from the user?
View 2 Replies
Apr 20, 2010
I am using Visual Studio 2005. I have a gridview and when it is in edit mode, there is a locked textbox and an associated dropdownlist for the signature field. If a name already exists in the database, it will show up in the textbox. In that case, I would like to hide the dropdownlist.
So far, I have not been able to figure out how to make this happen.
My latest attempt is this:
Protected Sub GridView1_RowEditing(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewEditEventArgs) Handles GridView1.RowEditing meString = (CType(GridView1.Rows(e.NewEditIndex).Cells(2).FindControl("meSigLabel"), Label)).Text Dim meDDL As DropDownList = CType(GridView1.Rows(e.NewEditIndex).Cells(2).FindControl("edMESigDropDownList"), DropDownList) If meString <> String.Empty Then meDDL.Visible = False Else meDDL.Visible = True End If End SubI receive a NullReferenceError. During debugging, the mestring variable has a value but the meDDL is Nothing.What am I doing wrong?
View 10 Replies
Mar 26, 2013
I know that when you hide a control is asp.net that you cannot access it. Is there a way of hiding it as far as a panel? Can I put it in a panel but size the panel to 1x1? Or in a div and hide it?
View 2 Replies
Jun 16, 2010
I have a grid view will two different button columns. I want to perform a different action depending on what button the user presses. How in the SelectedIndexChanged event do I determine what colmun was pressed. This is the code I use to generate the columns.
grdAttachments.Columns.Clear();
ButtonField bfSelect = new ButtonField();
bfSelect.HeaderText = "View";
bfSelect.ButtonType = ButtonType.Link;
bfSelect.CommandName = "Select";
bfSelect.Text = "View";
ButtonField bfLink = new ButtonField();
bfLink.HeaderText = "Link/Unlink";
bfLink.ButtonType = ButtonType.Link;
bfLink.CommandName = "Select";
bfLink.Text = "Link";
grdAttachments.Columns.Add(bfSelect);
grdAttachments.Columns.Add(bfLink);
View 1 Replies
Jan 6, 2012
I have a simple gridview control on .aspx page. It has one combo box in the gridview control and rest of the columns in the gridview control are all bound controls.
When the user picks something from combo box, I should multiply the number (picked from the combo box) with other number in the same row (meaning in a different column on the same row). I want to do all this in server controls not thru JQuery or Javascript.
Basically my problem is I am able to read data from unbound combo box control in the grid. But I should be able to read the contents of another bound column in the same row and perform multiplication between those two fields.
Code:
<asp:GridView ID="GridViewActuals" runat="server"
DataSourceID="SqlDataSource1" DataKeyNames="gl_number"
onrowcommand="GridViewActuals_RowCommand" Height="285px"
onrowdatabound="GridViewActuals_RowDataBound"
onrowupdated="GridViewActuals_RowUpdated"
Font-Names="Verdana" onrowupdating="GridViewActuals_RowUpdating1">
[Code] ....
View 2 Replies
Mar 15, 2010
how to hide columns in crystal report at run time?
View 4 Replies
Jul 22, 2010
Protected Sub SQLDShowActionRef_Selected(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs) Handles SQLDShowActionRef.Selected
View 4 Replies
Feb 9, 2011
how to hide a repeater column based on the user privileges.
Say I have:
<asp:Repeater ID="repeater" runat="server>
<HeaderTemplate>
<table id="table_id">
<tr>
<th>Name</th>
<th>Secret Info</th>
<tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td><asp:Label ID="Label1" runat="server" Text='<%# Eval("Name") %>' /></td>
<td><asp:Label ID="Label1" runat="server" Text='<%# Eval("SecretInfo") %>' /></td>
<tr>
<ItemTemplate>
<AlternatingItemTemplate>
<tr>
<td><asp:Label ID="Label1" runat="server" Text='<%# Eval("Name") %>' /></td>
<td><asp:Label ID="Label1" runat="server" Text='<%# Eval("SecretInfo") %>' /></td>
<tr>
<AlternatingItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
How would I only display the 'Secret Info' column to logged on users?
View 3 Replies
