Data Controls :: Change Color Of Label Control Inside GridView Based On Some Condition
May 7, 2015
I am trying to figure out a way to change the color of the text display in a label control or span inside a user control. The text needs to be displayed in a different colour based on the value returned.
<asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name").ToString()=="Flying Bats" ? "Display the text in green" : "Display the text in red" %> '/>
The text value would be one of the two. The font color needs to be ether red or green based on whats been returned.I cannot figure out how to do it.
How to change the value of a "label control in cell of a gridview" from codebehind (no matter whatever data is there in database).I am fetching 4 columns from databse in "label control in cell of a gridview". I want to change the value of a particular column from code behind (no matter whatever data is there in database)
i.e.,
If ( value == '2')display 2 columns value in label control in cell of a gridview from databaseand display other 2 columns value in label control in cell of a gridview as "Not Applicable".
If ( value == '3')display 3 columns value in label control in cell of a gridview from databaseand display other 1 columns value in label control in cell of a gridview as "Not Applicable".
How To Hide A Column But Still Retrieve Its Values? How To Access A Label Control In Cell Of Gridview
In my asp.net+vb web I am using the below code to highlight the row...
If e.Row.DataItem("Auth") Is System.DBNull.Value <> True AndAlso e.Row.DataItem("Auth") > e.Row.DataItem("Held") Then e.Row.BackColor = Drawing.Color.LightCoral
I want now only to give colour to the cell in the field and not the entire row ....
In my asp.net+vb web with access database in a gridview i used the following code
Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) If e.Row.RowType = DataControlRowType.DataRow Then If (e.Row.DataItem("TEN") > 24) Then e.Row.ForeColor = Drawing.Color.Red
[Code] ....
The above code is working in my sqldatabase web but not working in access database web...
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
In my asp.net+vb we+access DB. i have a field named DOB which is date of birth. i displays the data in grid view whose DOB+90 is less than ot equl to current date
DOB+90<=now()
and it works currect. but when i try to used vb code to change the row colour as per data it works for this one.
Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound If e.Row.RowType = DataControlRowType.DataRow Then If (e.Row.DataItem("DOR") <= Now()) Then e.Row.ForeColor = Drawing.Color.Red End If
I have Jobschedule( different work centers) displaying in grid view on my webform When particular workcenter passes the current date then it should highlight with Red color ,(following sechedule i bolded the dated which are passed current date since i did not find how to make color here)
I have a grid with 5 rows and 5 columns, All containing templetefield(Combobox)I am trying to set the background color of my grid cell(contain combobox) depending upon which item is selected. (again, dependent on item selection, so background color is not permanent). How can i achieve this?
I am using a dropdownlist in a gridview which contains 3 valuesappleorangebanana
apple will be displayed as default valueif i select orange and banana the dropdownlist list should be disable or hidden but the selected value must be displayed
protected void btnsubmit_Click(object sender, EventArgs e) { foreach (GridViewRow gr in GridView1.Rows) {
In my asp.net+vb web I was using this code to change row colour of gridview
Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound If e.Row.RowType = DataControlRowType.DataRow Then If e.Row.DataItem("bloodgp") Is System.DBNull.Value <> True AndAlso e.Row.DataItem("bloodgp") Then e.Row.BackColor = Drawing.Color.LightGreen End If End If End Sub
Now I want to change the cell backcolour to red for those cells are blank ....
i am using template field display image based on condition in table field. i have field name verify i used to store yes or no value if it is yes then display image else noting to display in gridview
I want to compare column index 1 and column index 8, and if 8 is bigger then 1 it should be a different font color.
Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) If e.Row.RowType = DataControlRowType.DataRow Then Dim x As String x = e.Row.Cells(1).Text Dim y As String y = e.Row.Cells(8).Text If Convert.ToInt32(x) <= Convert.ToInt32(y) Then e.Row.ForeColor = System.Drawing.Color.Blue End If End If End Sub
I have 3 Textboxes in my Web page. When user key in value in these 3 textboxes,their result should show on a "Label"
1) Gross Amount 2) Taxable Amount 3) Tax Amount
I have to write a Stored Procedure for calculating the value of above textboxes.
Condition is:
If Gross Amount is > or < 0.00, then Taxable and Tax amount should calculate based on below formula: @TaxableAmt = @GrossAmt / @Rate @TaxAmt = @GrossAmt - @TaxableAmt
but If Taxable Aount is > or < 0.00, then Gross and Tax amount should calculate based on below forumla:
and for "Tax Amount" I have 2 different conditions:
If Tax Amount is = 0.00, then Taxable and Gross amount should calculate based on below formula: @TaxableAmt = @TaxAmt / (@Rate-1) @GrossAmt = @TaxAmt + @TaxableAmt
but If Tax Amout is <> 0.00, then whatever the value of Tax Amount is, it should key-in/show as it is.
i.e., @TaxAmt = @TaxAmt
For this requirement, I wrote below SP:
ALTER PROCEDURE [Invoice].[usp_tbl_TaxCode_Update] -- Add the parameters for the stored procedure here @TaxCodeID nvarchar(50) , @GrossAmt decimal(18, 2), @TaxableAmt decimal(18, 2), @TaxAmt decimal(18, 2)
I have a GridView with an alternating Css style. The GridView has a column called tradeId. What I want to show is an alternating colour based on a change in the tradeId. Is this possible? It will make it easier on the eye to group trades together by colour. Here's the GridView code as it is right now:
