Format how a field is displayed in grid

[Poppy]

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

lBlockUsedUp.DataField = "BlockUsedUp"

lBlockUsedUp.HeaderText = "Blocks Used Up"

lBlockUsedUp.ItemStyle.Width = New Unit(300)

 dgBiopsyLocation.Columns.Add(lBlockUsedUp)

I then bind in code with :

 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 ?

 

[mortb]

If it is an option you can try to do this in the SQL statement

Something like:

SELECT
col1,
CASE col2
WHEN 1 THEN 'True'
ELSE ''
END AS newCol2
FROM
myTable

/mortb

 

[John Saunders]

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

lBlockUsedUp.DataField = "BlockUsedUp"

lBlockUsedUp.HeaderText = "Blocks Used Up"

lBlockUsedUp.ItemStyle.Width = New Unit(300)

 dgBiopsyLocation.Columns.Add(lBlockUsedUp)

I then bind in code with :

 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 ?

What kind of column is it? A BoundColumn? You may need to use a
TemplateColumn.

bit(1) in SQL is translated to bool in .NET.