ASP.NET,C#.NET,VB.NET,SQL Server,JQuery,JavaScript,Ajax,Gridview Examples,MVC,WCF,AutoLISP,code snippet examples

JQuery:Highlight GridView Negative value columns in ASP.NET

<title>JQuery:Highlight GridView Negative value columns in ASP.NET </title>

.Highlight

{

color: #FF008C;

font-weight: bold;

font-family: Verdana;

}

</style>

///for all columns

$(document).ready(function () {

$("#gvNegative td").each(function () {

var celData = $(this).text();

if ($.isNumeric(celData)) {

var numValue = parseInt(celData);

if (numValue < 0)

$(this).addClass('Highlight');

}

});

///only for particular Column

$(document).ready(function () {

$("#gvNegative tr:has(td)").each(function () {

var $targetColumn = $(this).find("td:eq(1)"); /// set 2nd column

var celData = $targetColumn.text();

if ($.isNumeric(celData)) {

var numValue = parseInt(celData);

if (numValue < 0)

$targetColumn.addClass('Highlight');

}

});

</script>

</head>

<body>

<div>

<asp:GridView ID="gvNegative" runat="server" BackColor="White" BorderColor="#CC9966"

BorderStyle="Solid" BorderWidth="1px" CellPadding="4" Font-Names="Georgia" Font-Size="Small"

Width="550px">

</asp:GridView>

</div>

</form>

</body>

</html>

In C#:

using System.Data;

using System.Data.SqlClient;

public partial class NegativeGridRow : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

DataTable dt = new DataTable();

dt.Columns.Add("Product Name");

dt.Columns.Add("Profit/Loss");

dt.Rows.Add("Monitor", "-999");

dt.Rows.Add("LCD", "200");

dt.Rows.Add("LED", "999");

dt.Rows.Add("Mouse", "-20");

dt.Rows.Add("Processor", "1000");

dt.Rows.Add("Wifi-Router", "-100");

dt.Rows.Add("Hard Drive", "100");

gvNegative.DataSource = dt;

gvNegative.DataBind();

}

In VB.NET:

Imports System.Data

Imports System.Data.SqlClient

Partial Public Class NegativeGridRow

Inherits System.Web.UI.Page

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)

Dim dt As New DataTable()

dt.Columns.Add("Product Name")

dt.Columns.Add("Profit/Loss")

dt.Rows.Add("Monitor", "-999")

dt.Rows.Add("LCD", "200")

dt.Rows.Add("LED", "999")

dt.Rows.Add("Mouse", "-20")

dt.Rows.Add("Processor", "1000")

dt.Rows.Add("Wifi-Router", "-100")

dt.Rows.Add("Hard Drive", "100")

gvNegative.DataSource = dt

gvNegative.DataBind()

End Sub

End Class

output

Aspdotnet-Kishore

Saturday 19 January 2013

JQuery:Highlight GridView Negative value columns in ASP.NET

No comments:

Post a Comment