DataGrid Cell: Custom Font/Backcolor/Format cell by cell (VB.NET)

[DraguVaso]

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/WinForms/FAQ_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/WinForms/FAQ_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

 

[Jared]

Do you have to use a datagrid? I think its much easier to format the
datalist control, use can use the custom bindings and the DataBinder.Eval
function to set your datasource and then use any vb functions and methods to
supply the formatting it needs. The drawback is you have to create the
interface yourself. The visual basic resource kit has great examples; I got
mine in a software bundle that I bought, I think you can download it from
Microsoft. You may want to look into it.

Jared

 

[Jared]

I just realized that I was talking about the asp datagrid and pieter was
referring to the windows.forms datagrid.
I apologize, please disregard.