This is a migrated thread and some comments may be shown as answers.

How can I convert value of checkbox column to Boolean

1 Answer 1238 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Perry
Top achievements
Rank 1
Perry asked on 14 Sep 2017, 04:00 PM
I have this RadGrid
<telerik:RadGrid ID="gvMembers" runat="server"
            AutoGenerateColumns="false"
            OnNeedDataSource="gvMembers_NeedDataSource"
            AllowSorting="true"
            AllowPaging="true"
            PageSize="10"
            AllowAutomaticUpdates="true"
            AllowAutomaticInserts="true"
            AllowAutomaticDeletes="true"
            OnItemCreated="gvMembers_ItemCreated"
            OnItemInserted="gvMembers_ItemInserted"
            OnPreRender="gvMembers_PreRender"
            OnInsertCommand="gvMembers_InsertCommand"
            OnItemDataBound="gvMembers_ItemDataBound"
            OnUpdateCommand="gvMembers_UpdateCommand"
            OnDeleteCommand="gvMembers_DeleteCommand"
 
            >
            <HeaderStyle CssClass="GridHeader" />
            <PagerStyle Mode="NextPrevNumericAndAdvanced" />
            <MasterTableView AutoGenerateColumns="false" DataKeyNames="UserID" CommandItemDisplay="Top" InsertItemPageIndexAction="ShowItemOnCurrentPage">
                <Columns>
                    <telerik:GridEditCommandColumn></telerik:GridEditCommandColumn>
                    <telerik:GridBoundColumn DataField="UserID" HeaderText="UserID" ReadOnly="true" UniqueName="UserID"></telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="FirstName" HeaderText="First Name" SortExpression="FirstName" UniqueName="firstname"></telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="FirstName" HeaderText="Last Name" SortExpression="LastName" UniqueName="lastname"></telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="UserName" HeaderText="User Name" SortExpression="UserName" UniqueName="username"></telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="EmailAddress" HeaderText="Email" SortExpression="EmailAddress" UniqueName="email"></telerik:GridBoundColumn>
 
                    <telerik:GridTemplateColumn UniqueName="TemplateColumn" HeaderText="Role">
                        <ItemTemplate>
                            <asp:Label ID="Label1" runat="server"
                                Text='<%# DataBinder.Eval(Container.DataItem, "Role") %>'>
                            </asp:Label>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:DropDownList ID="ddlRole" runat="server" DataTextField="Role1" DataValueField="RoleID"></asp:DropDownList>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridButtonColumn ConfirmText="Delete this Member?" ConfirmDialogType="RadWindow"
                        ConfirmTitle="Delete" ButtonType="PushButton" Text="Delete" CommandName="Delete" />
                </Columns>
            </MasterTableView>
        </telerik:RadGrid>

 

I am using  astored procedure to handle my updates this is My C# code

protected void gvMembers_UpdateCommand(object sender, GridCommandEventArgs e)
        {
            var editableItem = ((GridEditableItem)e.Item);
            var memberId = (int)editableItem.GetDataKeyValue("UserID");
            int Role = 1;
            CheckBox active = (CheckBox)editableItem["valid"].Controls[0];
            Boolean bactive = Convert.ToBoolean(active);
            string str = active.Text;
            string strFirstName = (editableItem["firstname"].Controls[0] as TextBox).Text;
            string strLastName = (editableItem["lastname"].Controls[0] as TextBox).Text;
            string strUserName = (editableItem["username"].Controls[0] as TextBox).Text;
            string strEmail = (editableItem["firstname"].Controls[0] as TextBox).Text;
 
 
 
            try
                {
                //save chanages to Db
DbContext.AAHomicideLogMembersUpdate(memberId, Role, strFirstName, strLastName, strUserName, strEmail, active);
                }
                catch (System.Exception)
                {
                   string srtt="Dosomething";
                }
            }

 

I am getting an error message on the conversion attempt what am I doing wrong here and what is the proper way to get those values from the checkbox

1 Answer, 1 is accepted

Sort by
0
Perry
Top achievements
Rank 1
answered on 14 Sep 2017, 06:02 PM

I was able to get this working by changing the C# code to

var editableItem = ((GridEditableItem)e.Item);
var memberId = (int)editableItem.GetDataKeyValue("UserID");
int Role = 1;
CheckBox active = (CheckBox)editableItem["valid"].Controls[0];
Boolean bactive = active.Checked;
string str = active.Text;
string strFirstName = (editableItem["firstname"].Controls[0] as TextBox).Text;
string strLastName = (editableItem["lastname"].Controls[0] as TextBox).Text;
string strUserName = (editableItem["username"].Controls[0] as TextBox).Text;
string strEmail = (editableItem["firstname"].Controls[0] as TextBox).Text;
Tags
Grid
Asked by
Perry
Top achievements
Rank 1
Answers by
Perry
Top achievements
Rank 1
Share this question
or