Dear Sirhow to change GridView row color from hours wiseFrom Current DateTime lt 12h is green From Current DateTime gt 24h is redplease help me sirpublic partial class Default SystemWebUIPage SqlConnection con new SqlConnection34Data SourcelocaldbProjectsInitial CatalogocmsadminIntegrated SecurityTrueConnect Timeout30EncryptFalseTrustServerCertificateFalse34 protected void PageLoadobject sender EventArgs e if PageIsPostBack

Hi indradeoCheck this example Now please take its reference and correct your codeHTMLltaspGridView ID34GridView134 CssClass34Grid34 runat34server34 AutoGenerateColumns34false34 OnRowDataBound34OnRowDataBound34gt ltColumnsgt ltaspBoundField DataField34Item34 HeaderText34Item34 gt ltaspBoundField DataField34Date34 HeaderText34Date34 gt ltColumnsgtltaspGridViewgtNamespacesCusing SystemDatausing SystemDrawingVBNetImports SystemDataImports SystemDrawingCodeCprotected void PageLoadobject sender EventArgs e if IsPostBack DataTable dt new DataTable dtColumnsAddRangenew DataColumn2 new DataColumn34Item34 new DataColumn34Date34 typeofDateTime dtRowsAdd34Shirt34 new DateTime2022 02 19 15 25 00 dtRowsAdd34Jeans34 DateTimeNow dtRowsAdd34Trousers3

Hi IndradeoPlease refer below sample I have created that sameple using database provided from your side and sample code working fineSQL CREATE TABLE compbox COMPID INT IDENTITY 1 1 NOT NULL EMPID NVARCHAR 10 NULL COMPMESSAGE NVARCHAR MAX NULL Comptype VARCHAR 20 NULL STATUSID NVARCHAR 10 DEFAULT 390139 NOT NULL COMPLODGEDATE DATE DEFAULT getdate NULL CLOSINGDATE DATE NULL REMARKS VARCHAR 255 NULL SGUID UNIQUEIDENTIFIER NULL remoteip NVARCHAR 50 NULL who NVARCHAR 50 NULL userfeedback NVARCHAR 255 NULL type NVARCHAR 255 NULL ATTENDDATE DATETIME NULL ATTENDBY VARCHAR 255 NULL Image VARCHAR 50 NULL remoteAip NVARCHAR 50 NULL CONSTRAINT PKco

Change ASP.Net GridView row color based on hours difference using C# and VB.Net

indradeo

SOLVED CLOSED ACTIVE ANSWERED
User: indradeo
Posted: on Feb 19, 2022 12:46 AM
Forum: Data Controls
Answer: 2
Views: 3156
Sample Code: Download

Dear Sir,

how to change GridView row color from hours wise.

From Current DateTime < 12h is green From Current DateTime > 24h is red

please help me sir.

public partial class _Default : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(@"Data Source=(localdb)\Projects;Initial Catalog=ocms_admin;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False");
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            refreshdata();
        }       
    }

    public void refreshdata()
    {
        con.Open();
        SqlCommand cmd = new SqlCommand("select * from comp_box where closing_date IS NULL ", con);
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        sda.Fill(dt);
        con.Close();
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }

    protected void GridView1_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            SqlConnection con = new SqlConnection(@"Data Source=(localdb)\Projects;Initial Catalog=ocms_admin;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False");
            DropDownList DropDownList1 = (e.Row.FindControl("DropDownList1") as DropDownList);
            SqlCommand cmd = new SqlCommand("select * from complaint_status", con);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            DropDownList1.DataSource = dt;
            DropDownList1.DataTextField = "STATUS_NAME";
            DropDownList1.DataValueField = "STATUS_NAME";
            DropDownList1.DataBind();
            DropDownList1.Items.Insert(0, new ListItem("--SELECT_STATUS--", "0"));
            DropDownList DropDownList2 = (e.Row.FindControl("DropDownList2") as DropDownList);
            cmd = new SqlCommand("select * from Assign_to", con);
            sda = new SqlDataAdapter(cmd);
            dt = new DataTable();
            sda.Fill(dt);
            DropDownList2.DataSource = dt;
            DropDownList2.DataTextField = "STATUS_NAME";
            DropDownList2.DataValueField = "STATUS_NAME";
            DropDownList2.DataBind();
            DropDownList2.Items.Insert(0, new ListItem("--SELECT_NAME--", "0"));
           
        }

        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            if (e.Row.RowIndex != 0)
            {              
                DateTime dt1 = Convert.ToDateTime(this.GridView1.Rows[e.Row.RowIndex - 1].Cells[1].Text, new CultureInfo("en-GB"));
                DateTime dt2 = Convert.ToDateTime(e.Row.Cells[1].Text, new CultureInfo("en-GB"));
                TimeSpan timeSpan = dt2.Subtract(dt1);
                if (timeSpan.TotalHours < 12)
                {
                    e.Row.BackColor = Color.Green;
                }
            }
            if (e.Row.RowIndex != 0)
            {
                DateTime dt1 = Convert.ToDateTime(this.GridView1.Rows[e.Row.RowIndex - 1].Cells[1].Text, new CultureInfo("en-GB"));
                DateTime dt2 = Convert.ToDateTime(e.Row.Cells[1].Text, new CultureInfo("en-GB"));
                TimeSpan timeSpan = dt2.Subtract(dt1);
                if (timeSpan.TotalHours > 24)
                {
                    e.Row.BackColor = Color.Red;
                }
            }
        }
        
    }

    protected void Update(object sender, EventArgs e)
    {
        GridViewRow row = (sender as Button).NamingContainer as GridViewRow;
        DropDownList dropDownList1 = row.FindControl("DropDownList1") as DropDownList;
        DropDownList dropDownList2 = row.FindControl("DropDownList2") as DropDownList;
        int COMP_ID = Convert.ToInt32(GridView1.DataKeys[Convert.ToInt32((sender as Button).CommandArgument)].Values[0]);
        string STATUS_ID = dropDownList1.SelectedItem.Text;
        string ATTEND_BY = dropDownList2.SelectedItem.Text;
        // string remark = (row.FindControl("TextBox5") as TextBox).Text;
        string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand("UPDATE comp_box SET STATUS_ID = @STATUS_ID, ATTEND_BY = @ATTEND_BY WHERE COMP_ID = @COMP_ID"))
            {
                cmd.Parameters.AddWithValue("@STATUS_ID", STATUS_ID);
                cmd.Parameters.AddWithValue("@ATTEND_BY", ATTEND_BY);
                cmd.Parameters.AddWithValue("@COMP_ID", COMP_ID);
                // cmd.Parameters.AddWithValue("@REMARKS", remark);
                cmd.Connection = con;
                con.Open();
                cmd.ExecuteNonQuery();
                con.Close();
            }
        }
        //dropDownList1.Items[0].Attributes.Add("disabled", "disabled");
        //dropDownList2.Items[0].Attributes.Add("disabled", "disabled");
    }

    protected void Closed(object sender, EventArgs e)
    {
        GridViewRow row = (sender as Button).NamingContainer as GridViewRow;
        int COMP_ID = Convert.ToInt32(GridView1.DataKeys[Convert.ToInt32((sender as Button).CommandArgument)].Values[0]);
        string STATUS_ID = (row.FindControl("DropDownList1") as DropDownList).SelectedItem.Text;
        string remark = (row.FindControl("TextBox5") as TextBox).Text;
        string CLOSING_DATE = DateTime.Now.ToString();
        string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand("UPDATE comp_box SET STATUS_ID = @STATUS_ID, REMARKS = @REMARKS,CLOSING_DATE = @CLOSING_DATE WHERE COMP_ID = @COMP_ID"))
            {               
                cmd.Parameters.AddWithValue("@COMP_ID", COMP_ID);
                cmd.Parameters.AddWithValue("@STATUS_ID", STATUS_ID);
                cmd.Parameters.AddWithValue("@REMARKS", remark);
                cmd.Parameters.AddWithValue("@CLOSING_DATE", CLOSING_DATE);
                cmd.Connection = con;
                con.Open();
                cmd.ExecuteNonQuery();
                con.Close();
            }
        }
      
        GridView1.EditIndex = -1;
        row.Visible = false;       
    }

    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
}

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 6

Reply
ANSWER
User: dharmendr
Replied: on Feb 19, 2022 05:03 AM
Report

Hi indradeo,

Check this example. Now please take its reference and correct your code.

HTML

<asp:GridView ID="GridView1" CssClass="Grid" runat="server" AutoGenerateColumns="false"
    OnRowDataBound="OnRowDataBound">
    <Columns>
        <asp:BoundField DataField="Item" HeaderText="Item" />
        <asp:BoundField DataField="Date" HeaderText="Date" />
    </Columns>
</asp:GridView>

Namespaces

using System.Data;
using System.Drawing;

VB.Net

Imports System.Data
Imports System.Drawing

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[2] { new DataColumn("Item"), new DataColumn("Date", typeof(DateTime)) });
        dt.Rows.Add("Shirt", new DateTime(2022, 02, 19, 15, 25, 00));
        dt.Rows.Add("Jeans", DateTime.Now);
        dt.Rows.Add("Trousers", new DateTime(2022, 02, 21, 05, 05, 00));
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
}


protected void OnRowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        DateTime dateTime = Convert.ToDateTime(e.Row.Cells[1].Text);

        if (dateTime.Subtract(DateTime.Now).TotalHours < 12)
        {
            e.Row.BackColor = Color.Green;
        }
        if (dateTime.Subtract(DateTime.Now).TotalHours > 24)
        {
            e.Row.BackColor = Color.Red;
        }
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not IsPostBack Then
        Dim dt As DataTable = New DataTable()
        dt.Columns.AddRange(New DataColumn(1) {New DataColumn("Item"), New DataColumn("Date", GetType(DateTime))})
        dt.Rows.Add("Shirt", New DateTime(2022, 2, 19, 15, 25, 0))
        dt.Rows.Add("Jeans", DateTime.Now)
        dt.Rows.Add("Trousers", New DateTime(2022, 2, 21, 5, 5, 0))
        GridView1.DataSource = dt
        GridView1.DataBind()
    End If
End Sub

Protected Sub OnRowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
    If e.Row.RowType = DataControlRowType.DataRow Then
        Dim dateTime As DateTime = Convert.ToDateTime(e.Row.Cells(1).Text)

        If dateTime.Subtract(DateTime.Now).TotalHours < 12 Then
            e.Row.BackColor = Color.Green
        End If
        If dateTime.Subtract(DateTime.Now).TotalHours > 24 Then
            e.Row.BackColor = Color.Red
        End If
    End If
End Sub

Screenshot

arjunv

0 20

Reply
ANSWER
User: arjunv
Replied: on Feb 24, 2022 05:57 AM
Modified: on Feb 24, 2022 06:02 AM
Report

Hi Indradeo,

Please refer below sample. I have created that sameple using database provided from your side and sample code working fine.

SQL

CREATE TABLE [comp_box] (
    [COMP_ID]         INT              IDENTITY (1, 1) NOT NULL,
    [EMP_ID]          NVARCHAR (10)    NULL,
    [COMP_MESSAGE]    NVARCHAR (MAX)   NULL,
    [Comp_type]       VARCHAR (20)     NULL,
    [STATUS_ID]       NVARCHAR (10)    DEFAULT ('01') NOT NULL,
    [COMP_LODGE_DATE] DATE             DEFAULT (getdate()) NULL,
    [CLOSING_DATE]    DATE             NULL,
    [REMARKS]         VARCHAR (255)    NULL,
    [S_GUID]          UNIQUEIDENTIFIER NULL,
    [remote_ip]       NVARCHAR (50)    NULL,
    [who]             NVARCHAR (50)    NULL,
    [user_feedback]   NVARCHAR (255)   NULL,
    [type]            NVARCHAR (255)   NULL,
    [ATTEND_DATE]     DATETIME         NULL,
    [ATTEND_BY]       VARCHAR (255)    NULL,
    [Image]           VARCHAR (50)     NULL,
    [remote_A_ip]     NVARCHAR (50)    NULL,
    CONSTRAINT [PK_comp_box] PRIMARY KEY CLUSTERED ([COMP_ID] ASC)
);

INSERT INTO [comp_box] 
     VALUES ('101847', 'Application -:- Userid/Password Problem :-  Employee no 101846 not working.','IT COMPLAINT', 3, '2/26/2022', NULL, NULL, NULL, NULL, '', NULL, NULL, '', '', '', NULL)

HTML

<asp:GridView ID="gvDetails" CssClass="Grid" runat="server" AutoGenerateColumns="false"
    OnRowDataBound="OnRowDataBound">
    <Columns>
        <asp:BoundField DataField="COMP_ID" HeaderText="COMP_ID" />
        <asp:BoundField DataField="EMP_ID" HeaderText="EMP_ID" />
        <asp:BoundField DataField="COMP_MESSAGE" HeaderText="COMP_MESSAGE" />
        <asp:BoundField DataField="STATUS_ID" HeaderText="STATUS_ID" />
        <asp:TemplateField HeaderText="COMP_LODGE_DATE">
            <ItemTemplate>
                <asp:Label ID="lblDate" Text='<%# Eval("COMP_LODGE_DATE") %>' runat="server" />
            </ItemTemplate>
        </asp:TemplateField>
        <asp:BoundField DataField="CLOSING_DATE" HeaderText="CLOSING_DATE" />
        <asp:BoundField DataField="REMARKS" HeaderText="REMARKS" />
        <asp:BoundField DataField="S_GUID" HeaderText="S_GUID" />
        <asp:BoundField DataField="remote_ip" HeaderText="remote_ip" />
        <asp:BoundField DataField="who" HeaderText="who" />
        <asp:BoundField DataField="user_feedback" HeaderText="user_feedback" />
        <asp:BoundField DataField="type" HeaderText="type" />
        <asp:BoundField DataField="ATTEND_DATE" HeaderText="ATTEND_DATE" />
        <asp:BoundField DataField="ATTEND_BY" HeaderText="ATTEND_BY" />
        <asp:BoundField DataField="Image" HeaderText="Image" />
        <asp:BoundField DataField="remote_A_ip" HeaderText="remote_A_ip" />
                
    </Columns>
</asp:GridView>

Namespaces

using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Drawing;

VB.Net

Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration
Imports System.Drawing

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        this.BindGrid();
    }
}

protected void OnRowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        DateTime dateTime = Convert.ToDateTime((e.Row.FindControl("lblDate") as Label).Text);

        if (dateTime.Subtract(DateTime.Now).TotalHours < 12)
        {
            e.Row.BackColor = Color.Green;
        }
        if (dateTime.Subtract(DateTime.Now).TotalHours > 24)
        {
            e.Row.BackColor = Color.Red;
        }
    }
}

private void BindGrid()
{
    string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    using (SqlConnection con = new SqlConnection(conString))
    {
        using (SqlCommand cmd = new SqlCommand("SELECT COMP_ID, EMP_ID, COMP_MESSAGE ,Comp_type, STATUS_ID, COMP_LODGE_DATE, CLOSING_DATE, REMARKS, S_GUID" +
                                                ",remote_ip, who,user_feedback, type,ATTEND_DATE ,ATTEND_BY, Image, remote_A_ip FROM comp_box", con))
        {
            cmd.CommandType = CommandType.Text;
            con.Open();
            this.gvDetails.DataSource = cmd.ExecuteReader();
            this.gvDetails.DataBind();
            con.Close();
        }
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not IsPostBack Then
        Me.BindGrid()
    End If
End Sub

Protected Sub OnRowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
    If e.Row.RowType = DataControlRowType.DataRow Then
        Dim dateTime As DateTime = Convert.ToDateTime((TryCast(e.Row.FindControl("lblDate"), Label)).Text)

        If dateTime.Subtract(DateTime.Now).TotalHours < 12 Then
            e.Row.BackColor = Color.Green
        End If

        If dateTime.Subtract(DateTime.Now).TotalHours > 24 Then
            e.Row.BackColor = Color.Red
        End If
    End If
End Sub

Private Sub BindGrid()
    Dim conString As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Using con As SqlConnection = New SqlConnection(conString)
        Using cmd As SqlCommand = New SqlCommand("SELECT COMP_ID, EMP_ID, COMP_MESSAGE ,Comp_type, STATUS_ID, COMP_LODGE_DATE, CLOSING_DATE, REMARKS, S_GUID" & ",remote_ip, who,user_feedback, type,ATTEND_DATE ,ATTEND_BY, Image, remote_A_ip FROM comp_box", con)
            cmd.CommandType = CommandType.Text
            con.Open()
            Me.gvDetails.DataSource = cmd.ExecuteReader()
            Me.gvDetails.DataBind()
            con.Close()
        End Using
    End Using
End Sub

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Change ASP.Net GridView row color based on hours difference using C# and VB.Net

Company

Explore

Follow us

Contact Us