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
Similar Messages:
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
Dec 5, 2013
i have a gridview, in my gridview, i have a attachment button.
when user click on the attachment button, it will direct them to EquipmentAttachment.aspx.
what i want to do right now is, if the attachment exist, then the attachment button visible, else the button attachment set to false.
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
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
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
May 13, 2013
I have a page with a label and a textbox with two button edit and update. when the user clicks on edit the labels get hidden and text box appears. And when he clicks on update the textbox disappears and label appears I have achieved making the text box disappear and label appear but when I click on edit the textbox is not appearing ....
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Institute : System.Web.UI.Page {
[Code] ....
View 1 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
Jul 16, 2010
I have an emergency request that I need to sort it out very quickly as I did not notice it early :(.
I have a dropdownlist, the contnet in the gridview (sqldatasource connection) changes based on the value the user slects, say I have play1, play2 from the dropdownlist, I would like to show column1, column2 and column3 with user selects play1; show column4, column5, and clomn6 when use selects play2; the datatable actually includes all 6 columns.
I understand that I need to use something like RowCreated event, and I need to set up condition based on the dropdownlist value, but I dont really know how to.
View 3 Replies
Nov 9, 2013
For this I am using ASP.NET 4.5, C#, and Entity Framework to SQL.
I have some sections of my site where users can make multiple entries and can optionally upload attachments. There is a page where the user can see a gridview that acts as an overview of the entires. I have been asked to display a column with a paperclip icon if an attachment exists.
The way the database is structured, the table that holds the entries has columns like this:
id, schoolName, dateStarted, dateEnded, attachmentId
The attachments are in another table. For this table the attachmentId will hold an Int32 or be NULL (no attachment). My current query looks like basically like this:
var query = context.applications.Where(c => c.id == applicationPrimaryKey);
var results = result.educationUniversities.ToList();
gdvEducationUniversity.DataSource = results;
gdvEducationUniversity.DataBind();
Gridview looks like this:
<asp:GridView
ID="gdvWorkMentor"
runat="server"
AutoGenerateColumns="False"
DataKeyNames="id"
<Columns>
[Code]....
I somehow need to create a condition where an image of a paperclip is shown if the attachmentId value is not Null. Optionally I imagine the query could be re-written to return a true/false value based on if the attachmentId value is null though I'm not certain how to do this.
View 1 Replies
Aug 26, 2010
I'm trying to conditionally hide 2 link buttons within a Gridview(gvPosts), ModifyButton and DeleteButton. I want the two buttons to hide in every row where the currently logged on Username is not the same as the Username in gvPosts' lbEmpID, a LinkButton control in the same row. Unfortunately the code is hiding the buttons in every row, including the one where lbEmpID.text = Profile.Username. My code is below, what am I doing wrong?
Dim lbtn As LinkButton
For Each rowItem As GridViewRow In gvPosts.Rows
lbtn = DirectCast(rowItem.Cells(0).FindControl("lbEmpID"), LinkButton)
If lbtn.Text <> Profile.UserName Then
Dim Modify As LinkButton
Dim Remove As LinkButton
For Each rowItem1 As GridViewRow In gvPosts.Rows
Modify = DirectCast(rowItem1.Cells(0).FindControl("ModifyButton"), LinkButton)
Remove = DirectCast(rowItem1.Cells(0).FindControl("RemoveButton"), LinkButton)
Modify.Visible = False
Remove.Visible = False
Next
End If
'If chk.Checked Then
'Response.Write(chk.ClientID + "<br />")
'End If
Next
View 3 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
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
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
May 4, 2010
Currently I have something like this, but when I click "update" the record doesn't get updated (but no error is returned).
[Code]....
View 5 Replies
Nov 11, 2010
i have a grid view and i want to show the sum of columns in footer.
View 2 Replies
Jun 22, 2010
I want to show default Column names in my grid, if the data is not coming from the database.
like:
ID Name Date
but with blank values..... you can just a blank grid.
View 2 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
Feb 19, 2010
I am trying to show/hide TemplateField of gridview but not getting it... here is ma sample aspx code
<asp:TemplateField HeaderText="ColumnA">
<ItemTemplate>
<asp:Label ID="lblTest" runat="server" Text=' <%# Eval("Test")>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
Now in server side i am trying to hide this column but failed !!
protected void gv_RowCreated(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header || e.Row.RowType == DataControlRowType.DataRow)
gv.Columns[2].HeaderStyle.CssClass = "hiddenClass"; // here i am setting display:None using css class
}
how to show/hide TemplateField on server side
View 5 Replies
Dec 13, 2010
I have the following two Boundfields in my gridview:
[Code]....
If UserSelectedDisplay exists, I want to display that. Otherwise I want to display display_title. How would you do that?
View 2 Replies
Sep 2, 2010
is there a way to show or hide a Template Field within a gridview upon a condition in C#?
View 2 Replies
Jan 17, 2010
I have a gridview, which contains a template field with a button. On this button, I want to show and hide another column with this one button. I don't want to use Java Script because my site already uses a lot of this and AJAX. So, can someone show an example of some code behind, which is what I want to do on how to show and hide another column on a gridview?
View 1 Replies
Mar 12, 2010
I have three columns in my GridView. Columns are FileName,
FileType and More. More field is a link field. If you click on the link, it should display the data (Created Date:10/03/2010
) like this.
--------------------------------------------------------------------------------------------------------------------
File Name File Type
--------------------------------------------------------------------------------------------------------------------
Image.jpg F:Temp More
Created Date:10/03/2010
--------------------------------------------------------------------------------------------------
Again if you click on More link, it should hide
View 3 Replies
Mar 30, 2010
I am using VS2008.I am binding dynamic datatable to gridview. I have few dropdowns and textboxes in gridview.
I have dropdownlist(ddlTrCodeNw_)in gridview foooter template. Based on the selection of Trcode value few controls will be enabled,disabled,visible,hide. in gridview.
<asp:GridView ID="gvAPPost" runat="server" Width="100%" ShowFooter="true"
AllowPaging="true" AutoGenerateColumns="false"
onrowcommand="gvAPPost_RowCommand"
onrowdatabound="gvAPPost_RowDataBound"
>
<Columns>
<asp:TemplateField HeaderText="Discount %" Visible="false">
<FooterTemplate>
<asp:TextBox ID="txtDiscountPerNw" runat="server" Width="40px" Enabled="false" Visible="false" ></asp:TextBox >
</FooterTemplate>
<ItemTemplate>
<asp:TextBox ID="txtDiscountPer" runat="server" Width="40px" Enabled="false" Visible="false"></asp:TextBox >
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
Intially I set TemplateField HeaderText also Visible="false".
so i have written the condition in ddlTrCodeNw_SelectedIndexChanged.
Now when
if(ddlTrCodeNw.SelectedValue=="24")
{
txtDepstNw.Enabled = true;
txtDepstIncNw.Enabled = true;
txtCrdtNw.Enabled = false;
txtCrdtIncNw.Enabled = false;
lblDiscTrcodeNw.Visible = true; // I want to show this TemplateField HeaderText also when i need.
}
I can I show TemplateField HeaderText also whenever i need.
View 3 Replies
Jan 19, 2010
I am looking at building a grouping gridview, which I will know, will suit my needs. Therefore, I am not looking for a nested gridview. My answer is based upon an example I found at [URL]
However, what I am looking to do is to add a button to the group header row, which when pressed the rows within the group can either be shown or hidden.
View 3 Replies
