Hi,

I'm looking for a nice way to format the cell of my datagrid according to
some predefined 'rules'. I found a lot on the site of George shepherd, but
it wasn't really what I was looking for:

I found there: How can I change the font used in a Gridcell on a cell by
cell or row by row basis. Wih this code I am able to change the
Font/Background/... based on the position of the field (column and row). The
problem is: it only changes the font etc, and not the format of it.
http://www.syncfusion.com/FAQ/WinFor...c44c.asp#q927q

Another usefull thing: How can I perform custom formatting on the cells in
my datagrid: This changes the format of a cell: like "1234" becomes "12-34"
and stuff like that.
http://www.syncfusion.com/FAQ/WinFor...c44c.asp#q881q

BUT (and now it comes): I'm not able to make something liek a 'merge' of
these two things. What I actually need is being able to change Font,
Backgroundcolor, Format, etc based on the entire row!!

For example: If the value in one field is zero, another Field has to get
marked in a specific Color (in the same record offcourse).

Anybody got any idea? Or better: A nice working example, or somewhere a
Class that takes care for all this stuff.

Thanks a lot in advance!

Pieter

To do this, you'd have to do quite of bit of extending of the datagrid and
override some of the draw events to achieve the desired results. When I
looked at the amount of time it would take I ended up buying Infragistics
..NET Advantage 3.0. I downloaded & installed it (5min), and used their
UltraGrid, which has quite a few of these features available during design
time.

I got everything I wanted in about an hour, which included much more complex
logic than you seem to need. As a brief example, I had a cell that I wanted
to color blue of cell 3 and cell 7 if they both equalled "yes". I simply
utilized the Initialize_Row event, which passes in RowEventArgs for each row
as it it retrieved from your datasource and/or class.

From there I could just
/**/
if (e.Row.Cells["ColName3"].Value == "Yes" &&
e.Row.Cells["ColName7"].Value == "Yes")
{
e.Row.Cells["MyCellToHightlightColName"].CellAppearance.BackColor =
System.Drawing.Color.Blue;
}
/**/

or something to that effect.

Hope this helps!

Nick Harris, MCP, CNA, MCSD
Director of Software Services
http://www.VizSoft.net



"DraguVaso" <(E-Mail Removed)> wrote in message
news:3fdf2716$0$16026$(E-Mail Removed)...
> Hi,
>
> I'm looking for a nice way to format the cell of my datagrid according to
> some predefined 'rules'. I found a lot on the site of George shepherd, but
> it wasn't really what I was looking for:
>
> I found there: How can I change the font used in a Gridcell on a cell by
> cell or row by row basis. Wih this code I am able to change the
> Font/Background/... based on the position of the field (column and row).
The
> problem is: it only changes the font etc, and not the format of it.
> http://www.syncfusion.com/FAQ/WinFor...c44c.asp#q927q
>
> Another usefull thing: How can I perform custom formatting on the cells in
> my datagrid: This changes the format of a cell: like "1234" becomes
"12-34"
> and stuff like that.
> http://www.syncfusion.com/FAQ/WinFor...c44c.asp#q881q
>
> BUT (and now it comes): I'm not able to make something liek a 'merge' of
> these two things. What I actually need is being able to change Font,
> Backgroundcolor, Format, etc based on the entire row!!
>
> For example: If the value in one field is zero, another Field has to get
> marked in a specific Color (in the same record offcourse).
>
> Anybody got any idea? Or better: A nice working example, or somewhere a
> Class that takes care for all this stuff.
>
> Thanks a lot in advance!
>
> Pieter
>
>
>
>
>
>
>
>

Hi DraguVaso,

if you override the column's Paint method, you should be able to access other fields of the _DataSource_. The necessary information
is passed in the parameters - CurrencyManager and rowNum:

protected override void Paint( Graphics g, Rectangle bounds, CurrencyManager source, int rowNum, bool alignToRight )

In the paint method you have the complete control over the cell painting.
hth, urlich.


"DraguVaso" <(E-Mail Removed)> schrieb im Newsbeitrag news:3fdf2716$0$16026$(E-Mail Removed)...
> Hi,
>
> I'm looking for a nice way to format the cell of my datagrid according to
> some predefined 'rules'. I found a lot on the site of George shepherd, but
> it wasn't really what I was looking for:
>
> I found there: How can I change the font used in a Gridcell on a cell by
> cell or row by row basis. Wih this code I am able to change the
> Font/Background/... based on the position of the field (column and row). The
> problem is: it only changes the font etc, and not the format of it.
> http://www.syncfusion.com/FAQ/WinFor...c44c.asp#q927q
>
> Another usefull thing: How can I perform custom formatting on the cells in
> my datagrid: This changes the format of a cell: like "1234" becomes "12-34"
> and stuff like that.
> http://www.syncfusion.com/FAQ/WinFor...c44c.asp#q881q
>
> BUT (and now it comes): I'm not able to make something liek a 'merge' of
> these two things. What I actually need is being able to change Font,
> Backgroundcolor, Format, etc based on the entire row!!
>
> For example: If the value in one field is zero, another Field has to get
> marked in a specific Color (in the same record offcourse).
>
> Anybody got any idea? Or better: A nice working example, or somewhere a
> Class that takes care for all this stuff.
>
> Thanks a lot in advance!
>
> Pieter
>
>
>
>
>
>
>
>

Thanks!

I was indeed able to to this by overriding the paint-method for the colors
etc.
For the formatting of the cells I had to override the
GetcolumnValueAtRow-event.

I found most of these things on the site:
http://www.syncfusion.com/FAQ/WinForms

Thanks anyway!

Pieter

If compiled some of the features on the Windows Forms FAQ, plus a lot more,
in my ExtendedDataGrid:
http://dotnet.leadit.be/extendeddatagrid/

It's a free control, so if your intrested: feel free to try it!

--
Greetz,
Jan
__________________________________
Read my weblog: http://weblogs.asp.net/jan
"DraguVaso" <(E-Mail Removed)> schreef in bericht
news:3fe80519$0$5252$(E-Mail Removed)...
> Thanks!
>
> I was indeed able to to this by overriding the paint-method for the colors
> etc.
> For the formatting of the cells I had to override the
> GetcolumnValueAtRow-event.
>
> I found most of these things on the site:
> http://www.syncfusion.com/FAQ/WinForms
>
> Thanks anyway!
>
> Pieter
>
>
>

Really GREAT!!!

Jan, I've been working on datagrid columnstyles a little bit, too:

http://www.i-syn.gmxhome.de/devcom/colstyles/intro.htm

Perhaps we can join our forces? I'd be delighted!
Cheers,
ulrich



"Jan Tielens" <(E-Mail Removed)> schrieb im Newsbeitrag news:#(E-Mail Removed)...
> If compiled some of the features on the Windows Forms FAQ, plus a lot more,
> in my ExtendedDataGrid:
> http://dotnet.leadit.be/extendeddatagrid/
>
> It's a free control, so if your intrested: feel free to try it!
>
> --
> Greetz,
> Jan
> __________________________________
> Read my weblog: http://weblogs.asp.net/jan
> "DraguVaso" <(E-Mail Removed)> schreef in bericht
> news:3fe80519$0$5252$(E-Mail Removed)...
> > Thanks!
> >
> > I was indeed able to to this by overriding the paint-method for the colors
> > etc.
> > For the formatting of the cells I had to override the
> > GetcolumnValueAtRow-event.
> >
> > I found most of these things on the site:
> > http://www.syncfusion.com/FAQ/WinForms
> >
> > Thanks anyway!
> >
> > Pieter
> >
> >
> >
>
>