Need to set datagrid column to readonly based on values

[Mike G]

I have a datagrid that is editable by the user. Some of the columns are readonly and others can be edited. I have one column that I need to be able to make readonly based on the values of other columns, otherwise it remains editable.

I want to set this property in the itemdatabound event as the datagrid is loaded. Below is my ItemDataBound routine to show what I'm trying to do. Everything else works; I just need to be able to conditionally set a cell to be ReadOnly.

Private Sub grdShipItems_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles grdShipItems.ItemDataBound
Select Case e.Item.ItemType
Case ListItemType.AlternatingItem, ListItemType.Item
If rdoActionType.SelectedValue.ToString = "Serial" Then
e.Item.Cells(0).Controls(0).Visible = False 'Hide the Edit btn
End If
If rdoActionType.SelectedValue.ToString = "Detail" Then
Dim strSQL, strConn As String
strConn = Session("ConnectString").ToString
strSQL = "SELECT Count(*) FROM tblSerialNums WHERE LineItemID = "
strSQL &= e.Item.Cells(5).Text
If DataHandler.ExecuteScalar(strSQL, strConn) > 0 Then
NEED TO SET READONLY PROPERTY OF CELL HERE
End If
End If
End Select
End Sub


TIA,
Mike

[Mike G]

Does anybody know how to do this? TIA!!