Can someone help me to set the bgcolor of an asp.net cell from code behind using a value from a sqldatasource?
I have a working sql data source that is used to populate labels in my html form using asp.net.
The background color of the cell depends on a comparison of the actual value versus the target value. If the actual daily value exceeds the limit I would like to change the bgcolor of a cell in the web page. The actual value comes from one datasource and the limit comes from a 2nd data source.
In vb code behind I would like to accomplish the following pseudo code:
If (sqlsource1Total > sqlsource2Limit) Then
bgXCell.BgColor = "#ccff99"
bgXCell.BgColor = "#ff9999"
Can someone show an example of how to code this?