[Resolved]-Datagrid formatting in code behind

In my code behind I add a coloumn to a datgrid :

Code:

---

lBlockUsedUp.DataField = "BlockUsedUp"
lBlockUsedUp.HeaderText = "Blocks Used Up"
lBlockUsedUp.ItemStyle.Width = New Unit(300)
dgBiopsyLocation.Columns.Add(lBlockUsedUp)

---

I then bind in code with :

Code:

---

dgBiopsyLocation.DataSource = iDataset.Tables("ArrBiopsyLocation")
dgBiopsyLocation.DataBind()

---

The problem I am having is that the field "BlockUsedUp", which is a bit field in SQL SERVER always shows "FALSE" when the value = 0. I want this to be "" if it is 0 and I want to do it all in my code behind.

Can anyone help ?

You have to handle the ItemDataBound event and change the value of the column. I would add a literal control to the column, then in the ItemDataBound event handler, do a find on the control and set it this way.