[Resolved] Set datagrid cell enabled to false

[indydavid32]

When a user hits the edit button, I want to either make a certain cell not enabled, or not visible. I don't care which. I can't seem to get either to work.

Here is my code that I tried:

Dim cn As New OleDb.OleDbConnection("Provider=SQLOLEDB.1;Integrated Security=SSPI;" _
                                 & "Persist Security Info=False;" _
                                 & "Initial Catalog=fuel info;" _
                                 & "UID=;PWD=;" _
                                 & "Data Source=Server7")
        cn.Open()
 
        Dim datAdapt As New OleDb.OleDbDataAdapter("Select Vendor_No as [Vendor No], " & _
        "Vendor_Name as [Vendor Name], Vendor_Terminal as [Vendor Terminal], " & _
        "Vendor_Trmnl_No As [Terminal No], Vendor_City As [City], Vendor_State As " & _
        "[State], ID From Other_Vendors Order By Vendor_Name", cn)
 
        Dim datSet As New Data.DataSet
 
        datAdapt.Fill(datSet, "Other_Vendors")
 
        DataGrid1.DataSource = datSet
        DataGrid1.DataKeyField = "ID"
        DataGrid1.EditItemIndex = e.Item.ItemIndex
        e.Item.Cells(3).Enabled = False
        DataGrid1.DataBind()
        cn.Close()
        cn.Dispose()
        datAdapt.Dispose()
        datSet.Dispose()

As you can see, the line that is not working is "e.item.cells(3).enabled = false"

Also, if anyone knows how to set the width of the cell on the fly as well, I would appreciate that as well.

Thanks