how to change the bg color of null column in gridview?

You can set the background color of some cells in the gridview_RowDataBound procedure
Here is an example

Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)

If e.Row.RowType = ListItemType.Item OrElse e.Row.RowType = ListItemType.AlternatingItem Then
If Session("EstAssurance") = 1 Or Session("EstFiliale") = 1 Then
Else
Dim rv As DataRowView = DirectCast(e.Row.DataItem, DataRowView)
Dim nUnitsInStock As Int32 = Convert.ToInt32(rv.Row.Item(22))
If nUnitsInStock = 1 Then
e.Row.Cells(17).BackColor = Drawing.Color.MediumSeaGreen
' e.Row.Cells(17).ForeColor = Drawing.Color.White
ElseIf nUnitsInStock = 2 Then
e.Row.Cells(17).BackColor = Drawing.Color.Yellow
Else
e.Row.Cells(17).BackColor = Drawing.Color.Tomato ' e.Row.Cells(17).ForeColor = Drawing.Color.White
End If
End If


End If
End Sub

<img src="http://profile.ak.fbcdn.net/hprofile-ak-snc4/187610_572714323_3779144_n.jpg" />

You can set the background color of some cells in the gridview_RowDataBound procedure
Here is an example

Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)

If e.Row.RowType = ListItemType.Item OrElse e.Row.RowType = ListItemType.AlternatingItem Then
If Session("EstAssurance") = 1 Or Session("EstFiliale") = 1 Then
Else
Dim rv As DataRowView = DirectCast(e.Row.DataItem, DataRowView)
Dim nUnitsInStock As Int32 = Convert.ToInt32(rv.Row.Item(22))
If nUnitsInStock = 1 Then
e.Row.Cells(17).BackColor = Drawing.Color.MediumSeaGreen
' e.Row.Cells(17).ForeColor = Drawing.Color.White
ElseIf nUnitsInStock = 2 Then
e.Row.Cells(17).BackColor = Drawing.Color.Yellow
Else
e.Row.Cells(17).BackColor = Drawing.Color.Tomato ' e.Row.Cells(17).ForeColor = Drawing.Color.White
End If
End If


End If
End Sub

<img src="http://profile.ak.fbcdn.net/hprofile-ak-snc4/187610_572714323_3779144_n.jpg" />

Refer :

http://forums.asp.net/t/930313.aspx

http://weblogs.asp.net/sushilasb/archive/2006/01/27/How-To_3A00_-Change-the-row-Background-color-based-on-the-database-value-using-GridView-Control.aspx '>

http://weblogs.asp.net/sushilasb/archive/2006/01/27/How-To_3A00_-Change-the-row-Background-color-based-on-the-database-value-using-GridView-Control.aspx

Thanks & Regards,
Sasi Prabhu.

Hey try these link as


http://yasserzaid.wordpress.com/2010/02/06/change-gridview-cell-color-according-to-condition/

http://www.devcurry.com/2010/12/change-background-color-of-gridview.html

http://www.dotnetspark.com/Forum/550-change-gridview-row-color-based-on-condition.aspx

Thanks & Regards,
GowthamManju
Chennai



Mark if the answer is true

u can also use coding as

for changing the colors based on dates

protected void grvOrders_RowDataBound(object sender, GridViewRowEventArgs e)
{
	DateTime currDate = Convert.ToDateTime(DateTime.Now.ToString("d"));

	if (e.Row.RowType == DataControlRowType.DataRow) {
		if (Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "FabDue").ToString()) < currDate) {
			e.Row.Cells(0).BorderColor = System.Drawing.Color.Red;
		}
		if (Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "PartsDue").ToString()) < currDate) {
			e.Row.Cells(1).BackColor = System.Drawing.Color.Red;
		}
		if (Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "AssyDue").ToString()) < currDate) {
			e.Row.Cells(2).BackColor = System.Drawing.Color.Red;
		}
		if (Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "TestDue").ToString()) < currDate) {
			e.Row.Cells(3).BackColor = System.Drawing.Color.Red;
		}
	}
}

u can alter based on ur ideas

Thanks & Regards,
GowthamManju
Chennai



Mark if the answer is true