[Solved] RadGrid Checkbox Conversion problem

[Nicole Griesmeyer]

Hello,

I would like a textbox column in my RadGrid. Unfortunately, I must have a boolean data type to get this to work, and what I have now is a char of 1 length (Y and N values). I looked into the sql conversion tables and couldn't find a compatible conversion. Is there a way to get the boxes to check or uncheck based on Y and N values, or a way to convert to boolean that I've missed?

I hope this question is clear, and appreciate any help.

[Shinu]

Hello Nicole,

I guess the field value returns Y or N and you want to set the CheckBox status accordingly. If so you could use a CheckBox in ItemTemplate of GridTemplateColumn as shown below.

aspx:

<telerik:GridTemplateColumn>
    <ItemTemplate>
        <asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Convert.ToString(Eval("MartalStatus"))== "Y" ? true: false %>' />
    </ItemTemplate>
</telerik:GridTemplateColumn>

Hope this help,
Shinu.

[Nicole Griesmeyer]

Thank you so much for your fast and helpful reply. I have two quick follow-up questions.

Your code worked perfectly. One error in the database, though, is that some of the values are actually lowercase y. Is there some sort of an "or" statement that could work here?

Also, I don't want them to be editable unless in edit mode. How do I specify this?

Thanks again, you are very helpful.

-Nicole

[Shinu]

Hi Nicole,

Try with the following code.

ASPX:

<telerik:GridTemplateColumn UniqueName="CopyEmail" Display="false" HeaderText="Copy?">
    <ItemTemplate>
    <asp:CheckBox ID="CheckBox1" runat="server" Enabled="false" Checked='<%# Convert.ToString(Eval("MartalStatus")).ToLower() == "y" ? true: false %>' />
    </ItemTemplate>
    <EditItemTemplate>
        <asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Convert.ToString(Eval("MartalStatus")).ToLower() == "y" ? true: false %>' />
    </EditItemTemplate>
</telerik:GridTemplateColumn>

-Shinu.