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..
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?
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]...
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.
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 RepliesI'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
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)
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]....
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 Repliesi 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]....
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 ?
I want to hide all FK Columns in all tables. I am using Asp.Net Dynamic Data 4.0.
I tried to use this code:
[Code]....
And then in List page template call:
[Code]....
But this does not work. If I set breakpoint in function GenerateFields it newer stops there.
I've got this gridview with a column labeled "Client Comment" that displays a clickable little icon when there is a client comment in the database. The problem is the icon is appearing whether or not there is data in the DB (except I don' t think it does when the DB value is null.)
How can I make it so the icon only appears if there is a comment in that database field? With code behind (if so VB) or in the tag?
[Code]....
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.
I have a gridview containing 10 columns. Three of them are set to visible="false' by default. When I click on 'Export to excel' Button, I can hide those invisible columns.
[Code]....
There must be more efficient way than this. How can I find the invisible columns and store their information in array and then only do a loop once?
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 RepliesI 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.
i have a gridview of a list of VehicleRequisition's with a column whose itemtemplate is as follows.
[Code]....
[Code]....
How to update each data in gridview from template field textbox?
if select reason is adjust-In then update plus the qty else adjust -Out minus the qty.
<asp:GridView ID="GridView1" HeaderStyle-BackColor="#3A64F2" HeaderStyle-ForeColor="White" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField= "RowNumber" HeaderText="RowNumber" />
<asp:BoundField DataField= "INV_ID" HeaderText="INV_ID" ItemStyle-Width="150" />
<asp:BoundField DataField= "INV_TYPE" HeaderText="INV_TYPE" ItemStyle-Width="150" />
<asp:BoundField DataField= "INV_SHORTDESC" HeaderText="INV_SHORTDESC" ItemStyle-Width="150" />
<asp:BoundField DataField= "INV_LOCATION" HeaderText="INV_LOCATION" ItemStyle-Width="150" />
<asp:BoundField DataField= "INV_QTY" HeaderText="INV_QTY" ItemStyle-Width="100" />
[CODE]....
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
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] ....
I have a table dt_details which includes columns - name, address, phone,emailid, website,remarks,paid.
In the datagrid i have to display full columns only if paid is yes and if paid is no only name & phoneno should display.How to do that ?
How to redirect a page to a particular website link( links are saved in database) using database on button click, for particular DropDown value i.e, External. If dropdown value is "external", then on clicking button page should redirect to particular website link related to the above drop down. This link can differ in DB but DropDown value is same for all users i.e "External"..(these website links are saved in database, I have to fetch these links from database.
View 1 RepliesI have a gridview that contains columns of electrical specification (value, resistance, etc.). The rows are populated with archival data from previous versions of th same part (rev A, rev B, etc.).
The question is: is there any way for me to review each row and set the font color to red if the value is different from the cell below, or above? This would highlight where changes were made to each individual revision of a part from the previous version.
if (!IsPostBack) {
string[] filePaths = Directory.GetFiles(Server.MapPath("~/PMRF/"));
List<ListItem> files = new List<ListItem>();
foreach (string filePath in filePaths) {
string ext = Path.GetExtension(filePath);
foreach (GridViewRow gr in GridView1.Rows)
[code]...
i want the image of image button to change according to file extension . But its not working.