can somebody tell m,
what's the error in below code-where all the columns with sex="male" should be displayed with color choclate in datagrid...plz
Protected Sub datagrid1_itemdatabound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles datagrid1.ItemDataBound
If (e.Item.ItemType = ListItemType.Item) Or (e.Item.ItemType = ListItemType.AlternatingItem) Then
Dim str As String
If (e.Item.Cells(3).Text.Equals("male")) Then
'If e.Item.DataItem(2) = Convert.ToString("male") Then
e.Item.Cells(0).BackColor = Color.Chocolate
End If

come on guyz,
someone plz help m-tell m what i have todo..i have been googling on this for last 3weeks.i have tried alltype of stuffs...guyz help m out,,,,,,

Hello preetham.saroja

i hope ds would help.

i did not use DataGrid instead i used DataGridView.

This is the code...

Private Sub btnFillGrid_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFillGrid.Click
Dim gRow As Integer
'Clear Content of DataGridView
For gRow = 0 To 9
'Add 10 Records
DataGridView1.Item("dgName", gRow).Value = gRow & " : " & "Sample Data"
DataGridView1.Item("dgAge", gRow).Value = (gRow + 4) * 2
If (gRow Mod 2) Then
DataGridView1.Item("dgSex", gRow).Value = "Male"
DataGridView1.Item("dgSex", gRow).Value = "Female"
End If
End Sub

Private Sub DataGridView1_CellFormatting(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles DataGridView1.CellFormatting
If DataGridView1.Columns(e.ColumnIndex).Name = "dgSex" Then
If Trim(UCase(DataGridView1.Item("dgSex", e.RowIndex).Value)) = "MALE" Then
e.CellStyle.BackColor = Color.Chocolate
End If
End If
End Sub

Note: I have put DataGridView1 and Commandbutton (btnFillGrid) on my form...

This article has been dead for over six months. Start a new discussion instead.