Need help resolving "Specified cast is not valid" error thrown when attempting to bind datatable to radgrid having checkbox column.

 

<telerik:gridtemplatecolumn headertext="Input" uniquename="TemplateColumn1">

  <itemtemplate>

    <asp:checkbox id="CheckBox1" runat="server" checked='<%# Eval("STATUS") %>' />  --> ERROR

  </itemtemplate>

  <edititemtemplate>

    <asp:checkbox id="CheckBox1" runat="server" checked='<%# Eval("STATUS") %>' />

  </edititemtemplate>

</telerik:gridtemplatecolumn>

 

the stored procedure (or SQL) needs to return a Bit

 

 

I'm using an Oracle database, and they don't have a BIT data type, so I tried
DECODE(V.SUPPLIER_NO, NULL, 'FALSE', 'TRUE') AS STATUS

DECODE(V.SUPPLIER_NO, NULL, 0, 1) AS STATUS

DECODE(V.SUPPLIER_NO, NULL, '0' , '1' ) AS STATUS
All 3 variations rendered the same result: Specified cast is not valid
I could get the first option to work with the gridview, but I was hoping to use the radgrid. 

any ideas? 

I haven't used Oracle for over 10 years
I Google'd and found that Oracle 9 has a Boolean datatype - can you CAST Status to Boolean?

if that doesn't work - then you'll have to go into the ItemDataBound event and get the Status out of the table cell and manually populate every row

Marianne,
Thank you for your suggestions.  Oracle doesn't have a Boolean data type, but rather a NUMBER data type that has a sub type of Boolean. I tried:

 

DECODE(V.SUPPLIER_NO, NULL, CAST(0 AS NUMBER) , CAST(1 AS NUMBER) ) AS STATUS

DECODE(V.SUPPLIER_NO, NULL, CAST(0 AS CHAR) , CAST(1 AS CHAR) ) AS STATUS
both of these options did not work unfortunately... :(

 

Oracle 9i has a Boolean datatype

I am not a Telerik employee- I am just a mid-level developer who had a bit of trouble with the CheckBox grid column-and that was using SQL Server

hopefully, a Telerik person will read this thread tonight and give you an answer you can use

Hello guys,

I assume that the error is caused by binding the Checked property of the CheckBox to null value.
You can overcome this by setting it to false when the Status is null:

I hope this helps.

Best regards,
Mira
the Telerik team

this code snippet produced a runtime error: "Cannot create an object of type 'System.Boolean' from its string representation '(DataBinder.Eval(Container.DataItem,"Status") is DBNull ? false : Eval("Status")' for the 'Checked' property.
and a design time error:
  Validation (ASP.Net): The values permitted for this attribute do not include '(DataBinder.Eval(Container.DataItem,"Status") is DBNull ? false : Eval("Status")'

The DECODE statement I'm using in my Oracle sp prevents NULL values from being returned in the results set.  What value should I be returning?  True, 1 or '1' and what data type?  Oracle does not have a BIT data type.
I have tried all of these so far: 

DECODE(V.SUPPLIER_NO, NULL, 'FALSE', 'TRUE') AS STATUS

DECODE(V.SUPPLIER_NO, NULL, 0, 1) AS STATUS

DECODE(V.SUPPLIER_NO, NULL, '0' , '1' ) AS STATUS

DECODE(V.SUPPLIER_NO, NULL, CAST(0 AS NUMBER(1,1)) , CAST(1 AS NUMBER(1,1)) ) AS STATUS

DECODE(V.SUPPLIER_NO, NULL, CAST(0 AS NUMBER) , CAST(1 AS NUMBER) ) AS STATUS

DECODE(V.SUPPLIER_NO, NULL, CAST(0 AS CHAR) , CAST(1 AS CHAR) ) AS STATUS

DECODE(V.SUPPLIER_NO, NULL, CAST(0 AS NUMBER(1)) , CAST(1 AS NUMBER(1)) ) AS STATUS

the above function should work in Oracle 9i

if it doesn't you'll have to break your column up with a templated coulmn or manually populate the column in the ItemDataBound event

The bit data type is used to hold a single boolean value, 0 or 1. MS SQL does not support assigning NULL to this fields ( found this online)

However, either of these should work according to this description, but both ways render the same error

 

DECODE(V.SUPPLIER_NO, NULL, 0, 1) AS STATUS
DECODE(V.SUPPLIER_NO, NULL, CAST(0 AS NUMBER(1)) , CAST(1 AS NUMBER(1)) ) AS STATUS

Marianne, Oracle won't allow:
DECODE(V.SUPPLIER_NO, NULL, FALSE, TRUE) AS STATUS  -- this is the equivalent to your suggestion
it has to be either:

DECODE(V.SUPPLIER_NO, NULL, 'F', 'T') AS STATUS
DECODE(V.SUPPLIER_NO, NULL, 'FALSE', 'TRUE') AS STATUS
but neither of these work either. 

Telerik team suggested:

but this doesn't compile.

Telerik team suggested this, and it is now working!
<

 

 

asp:CheckBox ID="CheckBox2" runat="server" Checked='<%# Eval("Status").ToString() == "TRUE" %>' />

 

Hello Jim,

I am posting the code from a support ticket concerning the same issue here, as it might be useful for the community:

Best wishes,
Mira
the Telerik team

Thanks for the solution

Thanks boss. very nice reply.