Change the row color in DataGridView based on the quantity of a cell value

Question

I need to change the color of a row in datagridview but my code is not working for me  I always get a error that says  Column named Quantity  cannot be found  Parameter name  columnName    Here is my code   Private Sub DataGridView1 CellFormatting ByVal sender As Object  ByVal e As DataGridViewCellFormattingEventArgs  Handles DataGridView1 CellFormatting     For i As Integer   0 To Me DataGridView1 Rows Count - 1         If Me DataGridView1 Rows i  Cells  Quantity    Value  lt  5 Then             Me DataGridView1 Rows i  Cells  Quantity    Style ForeColor   Color Red         End If     Next End Sub   Please help me fix it  Thank you

User · Answer

Dim dgv As DataGridView   Me TblCalendarDataGridView  For i As Integer   0 To dgv Rows Count - 1     For ColNo As Integer   4 To 7         If Not dgv Rows i  Cells ColNo  Value Is DBNull Value Then              dgv Rows i  Cells ColNo  Style BackColor    vbcolor blue         End If     Next Next

User · Answer

Using the CellFormating event and the e argument   If CInt e Value   lt  5 Then e CellStyle ForeColor   Color Red

User · Answer

If drv Item  Quantity   Value  lt  5  Then   use this to like this  If Cint drv Item  Quantity   Value   lt  5  Then

User · Answer

Just remove the   in your Quantity  Make sure that your attribute is the same with the parameter you include in the code  like this   Private Sub DataGridView1 CellFormatting ByVal sender As Object  ByVal e As DataGridViewCellFormattingEventArgs  Handles DataGridView1 CellFormatting     For i As Integer   0 To Me DataGridView1 Rows Count - 1         If Me DataGridView1 Rows i  Cells  Quantity   Value  lt  5 Then             Me DataGridView1 Rows i  Cells  Quantity   Style ForeColor   Color Red         End If     Next End Sub

User · Answer

This might be helpful   Use the  RowPostPaint  event The name of the column is NOT the  Header  of the column  You have to go to the properties for the DataGridView    then select the column    then look for the  Name  property   I converted this from C    From  http   www dotnetpools com Article ArticleDetiail  articleId 74       Private Sub dgv EmployeeTraining RowPostPaint sender As Object  e As System Windows Forms DataGridViewRowPostPaintEventArgs       Handles dgv EmployeeTraining RowPostPaint      If e RowIndex  lt  Me dgv EmployeeTraining RowCount - 1 Then         Dim dgvRow As DataGridViewRow   Me dgv EmployeeTraining Rows e RowIndex         lt    This is the header Name          If CInt dgvRow Cells  EmployeeStatus Training e26   Value   lt  gt  2 Then           lt    But this is the name assigned to it in the properties of the control         If CInt dgvRow Cells  DataGridViewTextBoxColumn15   Value ToString   lt  gt  2 Then                 dgvRow DefaultCellStyle BackColor   Color FromArgb 236  236  255           Else             dgvRow DefaultCellStyle BackColor   Color LightPink          End If      End If  End Sub

User · Answer

Try this  Note  I don t have right now Visual Studio  so code is copy paste from my archive I haven t test it     Private Sub DataGridView1 CellFormatting ByVal sender As Object  ByVal e As System Windows Forms DataGridViewCellFormattingEventArgs  Handles DataGridView1 CellFormatting     Dim drv As DataRowView     If e RowIndex  gt   0 Then         If e RowIndex  lt   ds Tables  Products   Rows Count - 1 Then             drv   ds Tables  Products   DefaultView Item e RowIndex              Dim c As Color             If drv Item  Quantity   Value  lt  5  Then                 c   Color LightBlue             Else                 c   Color Pink             End If             e CellStyle BackColor   c         End If     End If End Sub

User · Answer

I fixed my error  just removed  Value  from this line   If drv Item  Quantity   Value  lt  5  Then   So it will look like  If drv Item  Quantity    lt  5  Then

[vb.net] Change the row color in DataGridView based on the quantity of a cell value

Examples related to vb.net

Examples related to winforms

Examples related to datagridview