I would like to access the data within a datagrid eg

if datagrid1.column2.value = false then
end if

What is the syntax for this?

Thanks in Advance

Louisa

What row of data would you like to access?
What are you trying to achieve with this?

The syntax will be very different depending on what you are attempting to do.

Peter
------------------------------------------------------
Work smarter, not harder.

What I am trying to do is change the colour of the rows depending upon the values in certain fields. For example if it is a week before a date in the date field I would like the row to go red to warn the user that the date is approaching.

This may not be exactly what you need, though may help. It is for a flexiGrid and is VB6

Public Sub fnColourOngoingIssues()
Dim iLoop As Single
Dim dtPlaceHolder As Double
Dim iCol As Single
Dim iFlag As Single

On Error GoTo fnColourOngoingIssuesErr

  iCol = 4
  iFlag = 7
  With vsOngoingIssues
    For iLoop = 1 To .Rows - 1
      If IsDate(.TextMatrix(iLoop, iCol)) Then
        dtPlaceHolder = DateDiff("d", Date, Format(.TextMatrix(iLoop, iCol), "dd/mm/yy"))

        Select Case dtPlaceHolder
          Case Is > iFlag: .Cell(flexcpForeColor, iLoop, iCol) = vbBlack 'In the future
          Case 0 To 7: .Cell(flexcpForeColor, iLoop, iCol) = vbBlue 'Needs to be dealt with
          Case Is = 0: .Cell(flexcpForeColor, iLoop, iCol) = vbBlack 'Today/Overdue
          Case Is < 0: .Cell(flexcpForeColor, iLoop, iCol) = vbRed
          Case Else 'Should never reach here
        End Select
      End If
    Next
  End With
Exit Sub
fnColourOngoingIssuesErr:
  fnDisplayVBError
End Sub

Ian

Try this out:

Private Sub DataGrid1_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles DataGrid1.ItemDataBound
    Dim objItem As DataGridItem = e.Item
    'Do NOT deal with header, footer
    If Not(objItem.ItemType = ListItemType.Header And objItem.ItemType = ListItemType.Footer) Then
        If CType(objItem.Cells(0).Text, Date) > DateTime.Now.AddDays(-7) Then
            objItem.BackColor = System.Drawing.ColorTranslator.FromHtml("FF0000")
        End If
    End If
End Sub

You'll need to set the proper cell index to match the cell with your date in it.

Peter
------------------------------------------------------
Work smarter, not harder.

Note: The example I provided is for a datagrid in ASP.net, you might need to change it to work properly for a windows form datagrid.

A datagrid in VB.Net does not have a cell property for me to be able to index, what property what can I use instead?

Thanks again

Louisa

datagrid1.item(rowindex, columnindex)

For example:

datagrid1.Item(0,0)

would return the value of the first cell of the first row. I believe this is what you are looking for.

Perfect

Thank you very much

Louisa