C# - How To Hide A Column In The Table Based On A Boolean Variable

Jan 13, 2011

So I have an <asp:Gridview> and in my C# file, I am setting the datasource to some database table, and doing .DataBind().

However, I want to hide a column in the table based on a Boolean variable.

Something like this:

gridview.Columns['Field5'].Visible = false;

Or perhaps:

int c = gridview.Rows.Count();
for(int i = 0; i < c; i++){
gridview.Rows['Field5'].Remove();
}

Perhaps I cannot make it invisible, but I'm sure I can at least loop through and remove all rows related to the column "field5". I don't know how to go about doing this.

Does anyone perhaps have a proper link to using the GridView Class and how all the methods are suppose to be used because it's not clear, perhaps not written by microsoft?

the internet seems to lack a lot of C# documentation (or maybe it's just cluttered with too much useless ASP.net information).

View 3 Replies


Similar Messages:

C# - Populate A Listview Based On 2 Boolean Table Columns?

Feb 11, 2010

I have a database table containing scripts for plays/dramas. The scripts can be categorized under 'Theatre and Education', 'Plays for Young People' or both (by using bools to determine whether they belong to said categories);

scriptID: int
theatreAndEducation:bit
playsForYoungPeople: bit[code]....

View 2 Replies

DataSource Controls :: Set Or Reset A Boolean Column In A Data Table?

Mar 20, 2010

I have defined some binary bit columns in an SQL database table to indicate yes/no conditions, but I don't know how to set or reset them. I tried to use "profile.Volunteer = 0;" C# code in an event handler to reset a voluntary state for the Profile table of members, but what I got back was an error message that said, "Constant value '0' cannot be converted to a bool'. So, if a '0' cannot be used to reset a boolean value, what can be used?

View 2 Replies

Forms Data Controls :: Listview: How To Get The Background Colour Changed Based On A Boolean Value In A Table

Sep 17, 2010

I come across the technique on how to apply a different CSS class to make a row stand out from the others. However, the original code is for gridview whilst I am trying to get it works on a listview. The original code for the gridview is as follows and how to get it done on listview.

-----------------------------------------------------------------------

[Code]....

View 5 Replies

Forms Data Controls :: Datagrid Control Column Link Button Or Label Condition Based On The Boolean Value True Or False

May 11, 2010

I have a datagrid control, the first column is Revno, currently presenting info in linkbutton. i want to do a condition based on another field docid, which gets true or false value from database. if true then present Revno in linkbutton otherwise show the revbnno just as a label., thatway users does'nt have ability to clickit.

<ItemTemplate>
<asp:LinkButton ID="lblRevision" runat="server" CssClass="Textboxes" Text='<%# DataBinder.Eval(Container.DataItem, "RevNo")%>' CommandName="FileDownloadRecord"></asp:LinkButton>
</ItemTemplate>
this docid field has flag true or false.
if true meaning show the revno as LinkButton, otherwise show the revno as label.
GetDocdetail(DataBinder.Eval(Container.DataItem, "Docid")
on the codebehind side i can use this function.
Public Function GetDocdetail(ByVal DocID As boolean) As String
If DocID = "true" Then
Else
End If
End Function

View 4 Replies

Data Controls :: Hide Gridview Column With Session Variable?

Apr 27, 2016

With reference to the following link: [URL]

I have a column on Page1 gridview which holds Edit and Delete button.My question is how can i remove or hide the Edit and Delete button column on Page2 gridview so that the buttons are not visible?NB: The Gridview is tied to a session which was from page1. So on Page2 the buttons should not be seen...

View 1 Replies

Hide A Column Of GridView Based On A Condition?

Feb 11, 2011

I want to hide a column of GridView based on a condition. How can I access the column in C# code?

if() // condition
{
// Disable code here. ?????
}

View 2 Replies

Data Controls :: Hide Column In Repeater Based On Some Condition

Sep 14, 2013

My Repeater 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 :: ItemTemplate - Hide A Hyperlink Based On The Value Of A Column?

Apr 1, 2011

I have a gridview and in the gridview i have a an itemtemplatefield with a regular html hyperlink in it.

Based on the value of one of the columns in the gridview, i want to hide this hyperlink and just replace it with the value of another column

e.g. <a href="page.aspx?x=<%=Me.CurrentAgent.ID %>&id=<%# Eval("Id") %><%# Eval("Customer") %></a>

if Eval("Status") = 123 then instea of the above hyperlink, i just want <%# Eval("Customer") %>

View 2 Replies

Data Controls :: Dynamically Show Hide Label And HyperLink Based On Condition In Same Column Of GridView

May 7, 2015

I am checking string  and then bind category. If condition is false then i  need anchor tag in which i pass querystring to specific link.

<itemtemplate>
<asp:Literal runat="server" ID="litPrice" Text='<%#((String.IsNullOrEmpty(Eval("Price").ToString()) || Eval("Price").ToString()=="00/0.00" || Eval("Price").ToString()=="0/0.00") ? "<span font-family="arial"><a href="http://www.xyz.com/web/enquiries.asp?category="+ Eval("category")>Enquiry</a></span>" : Eval("Price"))%>' >
</asp:Literal>
</itemtemplate>

I am getting error. CS1010: Newline in constant

View 1 Replies

How To Prevent From Changing The Boolean Variable To The Original Value

Dec 2, 2010

I change the value of the boolean variable to true but then I have to refresh the page by clicking another button or two. Once the ASP.NET page refreshes, the value returns back to false when I want it to be true. How can I prevent it from changing the boolean variable to the original value and keep it as true. What would be the C# syntax for this.

public partial class _Default : System.Web.UI.Page
{
bool plus = false;
bool minus = false;
bool multiply = false;
[code]...

View 4 Replies

Setting The Column Size Based On The Max Column Size In The Table?

Jul 13, 2010

I want to set the coulms size of all the columns in the table in the DB based on the maximum width/size of one of those columns of that particular table That is if I have three columns Name(nvarchar 50), Address(nvarchar 70) and Description(nvarchar 100), then I want Name and Address to also be nvarchar 100, can anyone give me the code for the same in VB.

View 1 Replies

SQL Server :: Filtering Data Based On Boolean

Oct 18, 2010

I have a Gridview on my aspx page that is filtered based on a series of fields. One of these fields is a drop down list 'Status' the options are; 'Read', 'Unread' and 'Both'.

The SQL Stored Procedure expects serveral parameters including a bit parameter for the field 'Read'. If the Drop Down list has Read or Unread in it my Stored Parameter works but if it has Both in I am not sure what to pass to the Stored Procedure to get it to give me all records or basically ignore the Read field.

View 3 Replies

State Management :: Accessing A Session Variable In HTML For A Boolean Expression?

Nov 4, 2010

[code]...

How do I correctly define my boolean expression? I've been looking, but haven't found the right syntax.

View 4 Replies

Web Forms :: Sort A Data Table Based On A Particular Column Which Has Integer Values In Ascending Order?

Oct 22, 2010

How do I sort a data table based on a particular column which has integer values in ascending order?

I wrote this:

'Sort the datatable based on sequence id leadtable.DefaultView.Sort ="Id" But it doesnt seem to work Datatble is defined as:

[Code]....

View 9 Replies

SQL Server :: How To Copy One Column Data From A Table To Another Table Column With Rest Of The Column

Jan 16, 2011

I want to copy data from a table[tblExcel][No.of columns:2] to another table[ev_event] which has 5 columns, 2 columns from the another table, 3 columns from user defined value

[code].....

View 4 Replies

Forms Data Controls :: Evaluating Boolean Column In DataGrid

Mar 2, 2010

I have a boolean column in a datagrid that I would like to display as red/green image (I have already created these) instead of false/true. Or maybe I could display the "True" in green text and "False" in red text. Can someone point me in the right direction?

View 2 Replies

Forms Data Controls :: Changing Row Color In Grid View Based On A Boolean Field Using Rowdatabound Event

Aug 4, 2010

I know that variations of this same question have been posed numerous times - but I can't quite seem to find the exact solution.

I would like any row in my gridview where the boolean field "Approved" is True to be shaded gray. Here is the code that I'm using, but every row ends up being gray, regardless of the value in that "Approved" field. My guess is that I'm not correctly evaluating the boolean value in this field (which is actually a yes/no field in MS Access), Not sure if I should be reading that value as "-1", "Yes" or "True" or "NotNull"? Anyway, here is the code:

[code]....

View 4 Replies

Forms Data Controls :: How To Add A Hyperlink In A New Column On A GridView Based On A Data Table

Dec 18, 2010

I have created a gridView control and have successfully bound DataTable (dt) to it using

[Code]....

However, I want to add a dynamic hyperlink that will take the user somewhere based on the value of one of the columns in the selected row. I'm not sure how to do that.

View 4 Replies

Forms Data Controls :: AutoPostback Checkbox For Quickly Updating A Boolean Column In GridView

Jan 24, 2011

In trying to improve 'user experience' with a GridView, I have an administrative application where a GridView is displaying records from a SQL table. One of the columns is a bit column, and is displayed as a checkbox in the GridView. I want the user to be able to simply check or uncheck the box while viewing the GridView, and the value in that column for that record is immediately updated. So I set AutoPostBack="true" on the CheckBox in the GridView's Template Field.

But tests are indicating that the column value is not actually getting changed, even though the page appears to post back and displays the newly checked (or unchecked) checkbox correctly. But if I check the SQL table directly the column's value has not changed.

View 5 Replies

SQL Server :: Correct Boolean Type When Designing Database Table?

Sep 26, 2010

In my VB.Net code I am using boolean type and it is later stored through a stored procedure to a MS SQL database table. I have so far allways been using "int" as the column type in database table because there is no Boolean type to choose from when designing the columns of a table in the MS SQL Express? Is it correct to use the column type int for storing Boolean values?

View 2 Replies

Data Controls :: How To Hide Column In GridView And Access Value Of Hidden Column

Aug 16, 2013

As per my requirement, I am getting CompID, Company Name and URL from SQL database. I want to display just CompName and URL in gridvew. So, I need to hide the CompID in gridview. One way I can do BoundField field Visible to false but I need to retrive that compID id when user selected any of the row. if I set visible to false user wont see any compID in gridvew but I want access the selected compID also using SelectedRow.Cells[1].Text..

View 1 Replies

DataSource Controls :: How To Select Column Value From Grid And Hide A Column

Oct 19, 2010

I'm trying to retreive a column value from gridview5 to use it in a query to display resuls in gridview, Also how do you hide a column in the grid?

Where (p.Link_ID Like GridView5.?

[code]....

View 3 Replies

ADO.NET :: Select Name Column From The Applicant Table And Value Column From ApplicantValue Table?

Feb 2, 2011

I am quite new to LINQ, and I am stuck with this probably basic problem, but haven't been able to find a solution, so I thought I could ask here.

So, I have this repository where I put my functions for data accessing, and now I need to write a function to get all the applicants that have applied for this particular advertisement, and their values too. Now, the values are stored in a separate M:N table, where every row consists of the applicantID,advertisementID and value. I just wanna append the value to every applicant that I show, so that it would look like a Ranking List.

However, I do not seem to know how to select just the name column from the Applicant table, and just the Value column from the ApplicantValue table.

And there's this Iqueryable interface that further confuses me...

Here's my function to get the Applicants only:

[Code]....

Now, if I try to add to the definition of the type two columns, it says that it only messes with types, i.e. one type should be passed. So I figured I would do a ViewModel and then pass it, like this

[Code]....

and then in the function I have no idea how to pass the values:

View 5 Replies

Data Controls :: Change Value Of GridView BoundField Column Based On Value From Another Column

May 7, 2015

I am using item template and eval function in the gridview to display the records. Can I add a coulmn which is not in the table?

I have to add some columns which is not in the table and assign the values from code behind to that particular column

View 1 Replies







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