Solved

How do I compare a GridView cell value with a float?

Posted on 2009-07-03
4
586 Views
Last Modified: 2012-05-07
I am using an asp:GridView to display data from SQL Server.  I would like to change the color of a cell by comparing a float to the value of the cell (TableCell).  I am using c#.  Below is a snippet that shows what I am attempting to accomplish.  Thank you in advance.
if ((e.Row.Cells[1].Text != "Text on header row") && (e.Rows.Cells[1] < 0.65))
            {
                e.Row.Cells[1].BackColor = System.Drawing.ColorTranslator.FromHtml("#000FF");
            }

Open in new window

0
Comment
Question by:Budrophious
  • 2
4 Comments
 
LVL 39

Expert Comment

by:abel
ID: 24774767
If the cell is certain to have a double/float value, you can use:


if ((e.Row.Cells[1].Text != "Text on header row") && (Double.Parse(e.Rows.Cells[1].Text) < 0.65))
{
    e.Row.Cells[1].BackColor = System.Drawing.ColorTranslator.FromHtml("#000FF");
}

Open in new window

0
 
LVL 39

Accepted Solution

by:
abel earned 250 total points
ID: 24774772
(in the above code Double should be double)

If it is sometimes valid and sometimes not, change it like this:

double cellValue;
double.TryParse(e.Rows.Cells[1].Text, out cellValue);
// cellValue will contain 0.0 if it is not convertible
if ((e.Row.Cells[1].Text != "Text on header row") && (cellValue < 0.65))
{
    e.Row.Cells[1].BackColor = System.Drawing.ColorTranslator.FromHtml("#000FF");
}

Open in new window

0
 
LVL 15

Assisted Solution

by:jinal
jinal earned 250 total points
ID: 24775110
Hello ,

I attached code in code snippet. Mailny you have to handle GridView RowDataBound Event .

No need to check headertext and just need to check rowtype.

This is a main part.

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            float cellvalue ;
            bool b = float.TryParse(e.Row.Cells[1].Text,out cellvalue);
            if (b)
            {
                if (cellvalue < 0.65f)
                {
                    e.Row.Cells[1].BackColor = System.Drawing.ColorTranslator.FromHtml("#000FF");
                }
            }
        }
    }





/* ASPX File */
 
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default6.aspx.cs" Inherits="Default6" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" 
            onrowdatabound="GridView1_RowDataBound">
        </asp:GridView>    
    </div>
    </form>
</body>
</html>
 
/* Code Behind File */
 
public partial class Default6 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("Name", typeof(string));
            dt.Columns.Add("Value", typeof(float));
 
            DataRow dr = dt.NewRow();
            dr[0] = "Test1";
            dr[1] = 0.5f;
            dt.Rows.Add(dr);
 
            dr = dt.NewRow();
            dr[0] = "Test2";
            dr[1] = 1.5f;
            dt.Rows.Add(dr);
 
            GridView1.DataSource = dt;
            GridView1.DataBind();
 
        }
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            float cellvalue ;
            bool b = float.TryParse(e.Row.Cells[1].Text,out cellvalue);
            if (b)
            {
                if (cellvalue < 0.65f)
                {
                    e.Row.Cells[1].BackColor = System.Drawing.ColorTranslator.FromHtml("#000FF");
                }
            }
        }
    }
}

Open in new window

0
 

Author Closing Comment

by:Budrophious
ID: 31599693
Thank you for your responses!
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question