Gridview row color

In this blog we will know how to change the grid view row color according to some given conditions.

Scenario

I have a Dropdown list with two items that is "Important" and "Very Important" and a textbox for 'short note'. I have saved those to database. I want the data to load on grid view but with colored row. I mean for the data that is 'Important' i want the row to be colored 'blue' and for the data that is 'very important' i want the row to be colored 'red'.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!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>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>

</div>
<asp:DropDownList ID="DropDownList1" runat="server">
</asp:DropDownList><br />
<asp:Label ID="Label1" runat="server" Text="Short Notes" Width="100px"
Font-Bold="True"></asp:Label>
<asp:TextBox ID="TextBox1" runat="server" Height="58px" TextMode="MultiLine"></asp:TextBox>

<br />
<br />
<br />
<asp:Button ID="btn_insert" runat="server" onclick="btn_insert_Click"
Text="Insert" />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"
onrowdatabound="GridView1_RowDataBound">
<Columns>
<asp:BoundField DataField="shortnote" HeaderText="Shortnote" />
</Columns>
</asp:GridView>
</form>
</body>
</html>

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Drawing;
public partial class _Default : System.Web.UI.Page
{
string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlCommand com;
SqlDataAdapter sqlda;
DataSet ds;
string str;

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DropDownList1.Items.Add("Select");
DropDownList1.Items.Add("Important");
DropDownList1.Items.Add("very Important");
}

}
protected void btn_insert_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(connStr);
con.Open();
str = "insert into Details(shortnote,flag) values('" + TextBox1.Text + "','" + DropDownList1.SelectedItem.Text + "')";
com = new SqlCommand(str, con);
com.ExecuteNonQuery();
con.Close();
bindgrid();
}
void bindgrid()
{
SqlConnection con = new SqlConnection(connStr);
con.Open();
str = "select * from Details";
com = new SqlCommand(str, con);
sqlda = new SqlDataAdapter(com);
ds = new DataSet();
sqlda.Fill(ds, "Details");
GridView1.DataSource = ds;
GridView1.DataMember = "Details";
GridView1.DataBind();
con.Close();
}

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
if (Convert.ToString(DataBinder.Eval(e.Row.DataItem, "flag")) == "Important")
{
e.Row.BackColor = System.Drawing.Color.Blue;
}
else
{
e.Row.ForeColor = System.Drawing.Color.Red;
}

}

}
}