Checkbox in gridview with Sqldatasource - How to insert Bit value in db

Question

I am stuck with this. I have a gridview and a sqldatasource. I have created a footer row with a linkbutton to add records to MSSQL database.

enter image description here

I can insert all fileds except the last one, the checkbox, that is a BIT. This is my event handler:

protected void lnkInsert_Click(object sender, EventArgs e)
{
    SqlDataSource1.InsertParameters["name"].DefaultValue =
        ((TextBox)GridView1.FooterRow.FindControl("txtName")).Text;

    SqlDataSource1.InsertParameters["username"].DefaultValue =
        ((TextBox)GridView1.FooterRow.FindControl("txtUsername")).Text;

    SqlDataSource1.InsertParameters["pass"].DefaultValue =
        ((TextBox)GridView1.FooterRow.FindControl("txtPass")).Text;

    SqlDataSource1.InsertParameters["uread"].DefaultValue =
        ((TextBox)GridView1.FooterRow.FindControl("txtUread")).Text;

    SqlDataSource1.InsertParameters["udownload"].DefaultValue =
        ((TextBox)GridView1.FooterRow.FindControl("txtUdownload")).Text;

    SqlDataSource1.InsertParameters["udelete"].DefaultValue =
        ((TextBox)GridView1.FooterRow.FindControl("txtUdelete")).Text;

    SqlDataSource1.InsertParameters["umail"].DefaultValue =
       ((TextBox)GridView1.FooterRow.FindControl("txtUmail")).Text;

    SqlDataSource1.InsertParameters["is_admin"].DefaultValue =
        ((CheckBox)GridView1.FooterRow.FindControl("chkCredential")).Checked;

    SqlDataSource1.Insert();

}

I have tried different version of the line about the checkbox, I even tried using Bool, Boolean, etc, but I cannot find the way to make it working.I keep getting errors like "impossible to convert bool in string". How should I write this line:

SqlDataSource1.InsertParameters["is_admin"].DefaultValue =
        ((CheckBox)GridView1.FooterRow.FindControl("chkCredential")).Checked;

Aspx

<asp:TemplateField HeaderText="Admin" SortExpression="is_admin">
<EditItemTemplate>
  <asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Bind("is_admin") %>' />
    </EditItemTemplate>
     <FooterTemplate>
      <asp:CheckBox ID="chkCredential" runat="server" />
       </FooterTemplate>
         <ItemTemplate>
          <asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Bind("is_admin") %>' Enabled="false" />
         </ItemTemplate>
  </asp:TemplateField>

to make it working? Some help will be appreciated.

if((CheckBox)GridView1.FooterRow.FindControl("chkCredential")).Checked==true) then SqlDataSource1.InsertParameters["is_admin"].DefaultValue=1; else 0 — Anand
– Anand, Commented Sep 30, 2013 at 5:10
if((CheckBox)GridView1.FooterRow.FindControl("chkCredential")).Checked==true) then SqlDataSource1.InsertParameters["is_admin"].DefaultValue="1"; else "0" — Anand
– Anand, Commented Sep 30, 2013 at 5:24

Anand · Accepted Answer · 2013-09-30 06:52:49Z

2

if((CheckBox)GridView1.FooterRow.FindControl("chkCredential")).Checked==true) then SqlDataSource1.InsertParameters["is_admin"].DefaultValue="1"; else "0"

answered Sep 30, 2013 at 6:52

Anand

4093 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

iceheaven31 · Accepted Answer · 2013-09-30 05:11:28Z

1

Can you try this:

SqlDataSource1.InsertParameters["is_admin"].DefaultValue =
    ((CheckBox)GridView1.FooterRow.FindControl("chkCredential")).Checked.ToString().ToLower();

answered Sep 30, 2013 at 5:11

iceheaven31

8871 gold badge14 silver badges24 bronze badges

1 Comment

FeliceM Over a year ago

Thanks. I tried but I get an invalid cast exception here: <asp:CheckBox ID="CheckBox1" runat="server" Checked='<%#....

Collectives™ on Stack Overflow

Checkbox in gridview with Sqldatasource - How to insert Bit value in db

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related