﻿<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?)  » Coloring a datagridview</title><generator>InstantForum 2017-1 Final</generator><description>StrataFrame Forum</description><link>http://forum.strataframe.net/</link><webMaster>StrataFrame Forum</webMaster><lastBuildDate>Tue, 09 Jun 2026 17:47:42 GMT</lastBuildDate><ttl>20</ttl><item><title>Coloring a datagridview</title><link>http://forum.strataframe.net/FindPost31293.aspx</link><description>Hi There,&lt;br/&gt;&lt;br/&gt;I am trying to color rows in a grid depending on a special value in a database field.&lt;br/&gt;&lt;br/&gt;What I haven't yet figured out is how I can do this depending on a BO-Value and not a &lt;br/&gt;&lt;br/&gt;cell-value.&lt;br/&gt;&lt;br/&gt;For example: I have a datagridview with a BBS as datasource which is connected to a BO.&lt;br/&gt;&lt;br/&gt;In this BO I have a field called "isdeleted" and I want to show all coresponding lrows with the forecolor set to red.&lt;br/&gt;&lt;br/&gt;What I do now is the following: I have added an invisible column with this field to the datagridview and have a little sub which colors the rows:&lt;br/&gt;&lt;br/&gt;[code]&lt;br/&gt;&lt;br/&gt;&lt;font face=Consolas&gt;&lt;/font&gt;&lt;font color=#0000ff face=Consolas&gt;&lt;font color=#0000ff face=Consolas&gt;Private&lt;/font&gt;&lt;/font&gt;&lt;font face=Consolas&gt; &lt;/font&gt;&lt;font color=#0000ff face=Consolas&gt;&lt;font color=#0000ff face=Consolas&gt;Sub&lt;/font&gt;&lt;/font&gt;&lt;font face=Consolas&gt; setgridcolor()&lt;br/&gt;&lt;br/&gt;&lt;/font&gt;&lt;font color=#0000ff face=Consolas&gt;&lt;font color=#0000ff face=Consolas&gt;For&lt;/font&gt;&lt;/font&gt;&lt;font face=Consolas&gt; I &lt;/font&gt;&lt;font color=#0000ff face=Consolas&gt;&lt;font color=#0000ff face=Consolas&gt;As&lt;/font&gt;&lt;/font&gt;&lt;font face=Consolas&gt; &lt;/font&gt;&lt;font color=#0000ff face=Consolas&gt;&lt;font color=#0000ff face=Consolas&gt;Integer&lt;/font&gt;&lt;/font&gt;&lt;font face=Consolas&gt; = 0 &lt;/font&gt;&lt;font color=#0000ff face=Consolas&gt;&lt;font color=#0000ff face=Consolas&gt;To&lt;/font&gt;&lt;/font&gt;&lt;font face=Consolas&gt; kundengrid.Rows.Count - 1&lt;br/&gt;&lt;br/&gt;&lt;/font&gt;&lt;font color=#0000ff face=Consolas&gt;&lt;font color=#0000ff face=Consolas&gt;&amp;nbsp;&amp;nbsp; If&lt;/font&gt;&lt;/font&gt;&lt;font face=Consolas&gt; kundengrid.Rows(I).Cells(&lt;/font&gt;&lt;font color=#a31515 face=Consolas&gt;&lt;font color=#a31515 face=Consolas&gt;"IsDeleted"&lt;/font&gt;&lt;/font&gt;&lt;font face=Consolas&gt;).Value = &lt;/font&gt;&lt;font color=#a31515 face=Consolas&gt;&lt;font color=#a31515 face=Consolas&gt;"J"&lt;/font&gt;&lt;/font&gt;&lt;font face=Consolas&gt; &lt;/font&gt;&lt;font color=#0000ff face=Consolas&gt;&lt;font color=#0000ff face=Consolas&gt;Then&lt;br/&gt;&lt;br/&gt;&lt;/font&gt;&lt;/font&gt;&lt;font face=Consolas&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; kundengrid.Rows(I).DefaultCellStyle.ForeColor = &lt;/font&gt;&lt;font color=#2b91af face=Consolas&gt;&lt;font color=#2b91af face=Consolas&gt;Color&lt;/font&gt;&lt;/font&gt;&lt;font face=Consolas&gt;.Red&lt;br/&gt;&lt;br/&gt;&lt;/font&gt;&lt;font color=#0000ff face=Consolas&gt;&lt;font color=#0000ff face=Consolas&gt;&amp;nbsp;&amp;nbsp; End&lt;/font&gt;&lt;/font&gt;&lt;font face=Consolas&gt; &lt;/font&gt;&lt;font color=#0000ff face=Consolas&gt;&lt;font color=#0000ff face=Consolas&gt;If&lt;br/&gt;&lt;br/&gt;&lt;/font&gt;&lt;/font&gt;&lt;font face=Consolas&gt;&lt;/font&gt;&lt;font color=#0000ff face=Consolas&gt;&lt;font color=#0000ff face=Consolas&gt;Next&lt;br/&gt;&lt;br/&gt;&lt;/font&gt;&lt;/font&gt;&lt;font face=Consolas&gt;&lt;/font&gt;&lt;font color=#0000ff face=Consolas&gt;&lt;font color=#0000ff face=Consolas&gt;End&lt;/font&gt;&lt;/font&gt;&lt;font face=Consolas&gt; &lt;/font&gt;&lt;font color=#0000ff face=Consolas&gt;&lt;font color=#0000ff face=Consolas&gt;Sub&lt;br/&gt;&lt;br/&gt;&lt;/font&gt;&lt;/font&gt;[/code]&lt;br/&gt;&lt;br/&gt;And then I call this sub in the paint-event of the datagridview.&lt;br/&gt;&lt;br/&gt;Everything works fine but somehow it does not feel right and I would like to know how this can be done better?&lt;br/&gt;&lt;br/&gt;Thanks in advance&lt;br/&gt;&lt;br/&gt;Thomas</description><pubDate>Tue, 24 Jul 2012 14:52:28 GMT</pubDate><dc:creator>Thomas Holste</dc:creator></item></channel></rss>