DataList : DataBinding : Visible

Question

I am trying to databind a Button.Visible member to a bit field from a query from sql server. Bit field values are 1 and 0 and Visible is a bool so I get a cast exception. Is there a way to format the value to true/false or someone I could do this in the databinding field?

nick 0 · Answer

I am not sure you fully understood what I am heading for probably because I did not explain it well enough. I am talking about the late databinding that Visual Studio provides when you are in design mode of a page. I am not in a regular code block... for example. If you have a TextBox in a template field of a table then you can use the interface to data bind to the Text property. This translates to HTML code that looks like this... Text=' ' In this case the value is a string and that is acceptable for the Text property. This is called after a datasource has been set on a table and DataBind is called. Now as I said I want to bind to Visible and I have a bit field which is not a bool so the CastException occurs. The same thing if I wanted to do this with ForeColor which in HTML can technically be text (Blue) or a value #FFFFFF but when it hits the Eval function that is not a Color type and a CastException occurs. There must be a way to do this that I am overlooking otherwise why would they have exposed those properties in the IDE?

sofialimohd · Answer

Hi This is the best way to do... but u need to do explicit conversion... for that use Cbool() function to convert bitfield into boolean value.... also u can do that same job as button.visisble=iif(bitfieldvalue=1truefalse) 'where bitfieldvalue is the sql bitfiled u r using... thanks..