Data Controls :: Change GridView Row Color Based On Date In BoundField?
Mar 7, 2013
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
But i want three diffrent conditions
1. whose DOB=current month
2. whose DOB comes in next month
3. whose DOB comes in month after next month
The font colour should be diffrent
View 1 Replies
Similar Messages:
Sep 16, 2013
rollno name dateofbd
1 a sep 16
2 b sep 17
3 c sep 18
4 d sep 19
This is datagridview after data is loaded.
whenever i load the data it compare the dateofbd with system date
if systemdate matches with dateofbd. that particular cell say example sep 16 that cell background color
should changes to red.and sep 16 should display in bold in windows application.
View 1 Replies
May 7, 2015
I want a RowDataBound if the previous date in filed check in not found be red color
Like the date 10/10/2014 not found so 10/11/214 be red and how can i edit the date to be dd/mm/yyyy
Name Checkin Checkout Branch
450 10/6/2014 9:13:38 AM 10/6/2014 6:01:50 PM branch0
450 10/7/2014 9:16:34 AM 10/7/2014 6:44:21 PM branch0
450 10/8/2014 9:11:53 AM branch0
450 10/8/2014 6:03:25 PM branch0
450 10/11/2014 9:17:33 AM 10/11/2014 6:29:16 PM branch0 (red color )
450 10/11/2014 4:50:42 PM branch0
450 10/12/2014 9:09:38 AM branch0
View 1 Replies
Mar 15, 2011
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)
View 12 Replies
Mar 11, 2010
I was hoping this is simple but i have problems.
Basically i was only able to set the string color with itemstyle-Forecolor.
But how do i set the background of a column and also set height,width.Ok height may not work because i have an itemtemplate with predefined height.
Can this be done in a simple boundfield or must i have all my datafields in itemtemplates?
What i do for one column:
[Code]....
View 18 Replies
Jul 26, 2013
I want to change the color of particular gridview rows with an image in one row, based on condtion. How to achieve it.
View 1 Replies
Jan 9, 2011
i want to change color of gridview row to red ,if user login period is expired .
i am doing this:
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
ViewState["expdatex"] = DateTime.Now.ToString("MM/dd/yyyy");
if (e.Row.RowType == DataControlRowType.DataRow)
[Code]....
but it is changed all the cells color.
View 5 Replies
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
Sep 15, 2013
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 ....
View 1 Replies
Feb 15, 2014
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?
View 1 Replies
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.
View 1 Replies
Feb 25, 2011
My gridview does not use controls, because it is populated using expressions
<asp:TemplateField HeaderText="As Of Sales">
<ItemTemplate>
<%#Getsales(Decimal.Parse(Eval("asofsales").ToString())).ToString("C0")%>
</ItemTemplate>
<FooterTemplate>
<%#Getsales1().ToString("C0")%>
</FooterTemplate>
<FooterStyle Font-Bold="True" />
</asp:TemplateField>
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
View 1 Replies
Sep 10, 2010
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:
[Code]....
View 2 Replies
Apr 27, 2016
How can change the color of dropdownlist with based on their Text
If dropdownlist have listitem Santosh and Arati if santosh color is red if Arati color is blue when page is loading
View 1 Replies
Feb 19, 2011
I want to change a particular row color of gridview based on some condition, i am using ASP.NET with c#.
View 2 Replies
Feb 15, 2010
I'm trying to change a row in detailsview based on a value in a coloum. Exactly the same as this example but in Detailsview: [URL]
View 3 Replies
May 7, 2015
I have SQL2012 database, which has a Table with many columns in it . One of the columns is "Start Date" and i set the dataType to "Date". Now I am putting the data into a gridview but the data is different to the database, the "Start Date" column has time as well. why this is happening ( the Start Date column is the gridview is a BoundField).
View 1 Replies
May 11, 2010
<ItemTemplate>
<asp:LinkButton ID="lblRevision" runat="server" CssClass="Textboxes" Text='<%# DataBinder.Eval(Container.DataItem, "RevNo")%>' CommandName="FileDownloadRecord"></asp:LinkButton>
</ItemTemplate>
how to change the linkbutton color based on the DOCID value (another field which is coming via databind) which is 1 or 0 bit type boolean value.
View 2 Replies
Sep 14, 2011
I need to be able to change a row's back color in the GridView based on the value in each row's second cell.
But, I'm having some trouble looping through each row. I thought the following might work:
VB.NET Code:
For Each gvi As GridViewRow In Me.gvTechPPE.Rows
ClientScript.RegisterStartupScript(Me.GetType(), "New Entry", "alert ('" & gvi.Cells(1).Text & "')", True) Next
I ran that just as a test. An alert pops up, but only for the first item in the GridView. All the others are skipped.
View 8 Replies
Jun 20, 2012
i want to differentiate the row of gridview based on condition.
i have used template column in gridview .
eg
name rate
a 0 display the background of this row is red color
b 1000 display the background of this row is green color
c 500 display the background of this row is green color
View 1 Replies
Mar 20, 2011
I am wondering if its possibl to change the DataField value of the asp:BoundField in the code behind.aspx page:
[Code]....
I would like to change DataField="From" to DataField="To" before I call the GridView.DataBind.Please let me know if this is possible and if so how can I do it.
View 3 Replies
Aug 16, 2013
I want to access the header text of bound fields programatically. suppose i have GridView1 with following bound fields:
<asp:BoundField Visible="false" DataField="ID" HeaderText="ID" /> <asp:BoundField DataField="Title" HeaderText="Title" /> <asp:BoundField Visible="false" DataField="Description" HeaderText="Description" />
how can I access their header text programmatically ( display it(either using response.write or any label)
View 1 Replies
Feb 25, 2010
I am developing a scheduling system in which customers are alloted 15 minute timeslots (see example below). During rowdatabound event I know how to change the value of Cell(1) to NULL by using e.Row.Cells(1).Text = "" so Select option is not available for that timeslot. This works fine for someone who has taken only 1 timeslot.
Question is, when a Customer has for example 1:00 hour appointment (which is 4 x 15 minute time slots), how do I make the next 3 rows Cell(1) value NULL?
Is there anything like e.Row+1.Cells(1).Text = "" or some loop that I can run to take care of next few rows?
[code]....
View 4 Replies
Jun 1, 2010
I am pretty new to asp.net development. I have a a checkbox in template column in gridview how do i change the color of grid row when the check state changes.
View 5 Replies
Dec 13, 2010
i have gridview & m appliying for dis gv paging sorting and row color change respective courses for dat i have written code but after 3 records he give this error
Specified argument was out of the range of valid values.
Parameter name: index my code is
[code]....
View 5 Replies