<div>
I do not really want to code for every color. &nbsp;Previous solution from (nepaluz) works best for me.
</div>


I do not really want to code for every color.  Previous solution from (nepaluz) works best for me.

<div>
<div class="content wysiwyg-content">
A color for each instrument is stored in the database. &nbsp;i need to change the cell background base on the instrument color assignment.<br />
Instrument1 color.lightGray<br />
Instrument2 color.yellow<br />
Instrument3 color.Blue<br />
<br />
Celle(17) has the value &quot;color.Blue&quot; &nbsp;which of couse is a string<br />
<br />
&nbsp;Me.dgvJobStatusHistory.Row<wbr />s(e.RowInd<wbr />ex).Cells(<wbr />3).Style.B<wbr />ackColor = Me.dgvJobStatusHistory.Row<wbr />s(e.RowInd<wbr />ex).Cells(<wbr />17).Value<br />
<br />
Error: &nbsp;Specific cast is invalid.<br />
<br />
Any suggestions on how to store of convert would be appreciated.
</div>
</div>


A color for each instrument is stored in the database.  i need to change the cell background base on the instrument color assignment.
Instrument1 color.lightGray
Instrument2 color.yellow
Instrument3 color.Blue

Celle(17) has the value "color.Blue"  which of couse is a string

 Me.dgvJobStatusHistory.Rows(e.RowIndex).Cells(3).Style.BackColor = Me.dgvJobStatusHistory.Rows(e.RowIndex).Cells(17).Value

Error:  Specific cast is invalid.

Any suggestions on how to store of convert would be appreciated.

Change datagrid view cell backgroud color based on color name stored in sql table

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.