Data provider classes in ADO.NET

Question

Hi friends,

I want to know that what are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

Answer 1

Check ItemDataBound event of the grid.

i.e.

If e.Item.ItemType = ListItemType.Item OR e.Item.ItemType == ListItemType.AlternatingItem then

      Dim lbl as Label = e.Item.Cell(1).FindControl("YourLabelControl")

      Dim str as String = lbl.Text

      Select Case str
            Case "YES/YES"

                 e.Item.Cells(1).BackColor = Color.Green

            Case "NO/NO"

                 e.Item.Cells(1).BackColor = Color.Red

      End Select
End If

Hope this helps.

Regards,