In my code behind I add a coloumn to a datgrid :
I then bind in code with :Code:lBlockUsedUp.DataField = "BlockUsedUp" lBlockUsedUp.HeaderText = "Blocks Used Up" lBlockUsedUp.ItemStyle.Width = New Unit(300) dgBiopsyLocation.Columns.Add(lBlockUsedUp)
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.Code:dgBiopsyLocation.DataSource = iDataset.Tables("ArrBiopsyLocation") dgBiopsyLocation.DataBind()
Can anyone help ?




Reply With Quote