Solved

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

Posted on 2009-07-03
4
566 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
A quick way to get a menu to work on our website, is using the Menu control and assign it to a web.sitemap using SiteMapDataSource. Example of web.sitemap file: (CODE) Sample code to add to the page menu: (CODE) Running the application, we wi…
This video discusses moving either the default database or any database to a new volume.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

762 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now