Conversion failed when converting the varchar value 'System.Web.UI.WebControls.CheckBox' to data type bit

Question

when i check on checkbox whose datatype is bit ,its value i.e 1 or 0 is not being store in database it is giving error

Conversion failed when converting the varchar value 'System.Web.UI.WebControls.CheckBox' to data type bit

if (CheckBoxDT.Checked) 
{ 
    cmd.CommandText = " Insert into ClientMaster(doTips) values ( 1 )";    
    cmd.Parameters.AddWithValue("doTips", bool.Parse("1")); 
    cmd.ExecuteNonQuery(); 
} 
else 
{ 
    cmd.CommandText = "insert into ClientMaster(doTips) values (0)";
    cmd.Parameters.AddWithValue("doTips", bool.Parse("0")); 
    cmd.ExecuteNonQuery(); 
}

i have added this code to convert checkbox into bit but it is not working giving same error.............. <asp:CheckBox ID="CheckBoxDL" runat="server" Checked='<%#(Convert.ToBoolean(Eval("isActive"))) %>' style="color: #FFFFFF" /> — Vikas Vanvi
– Vikas Vanvi, Commented Feb 18, 2013 at 8:25
What is "isActive"? Is that a column name? If yes, then are you trying to pass a datatable row value to the "Checked" attribute of your checkbox? — Niar
– Niar, Commented Feb 18, 2013 at 8:41

Developer · Accepted Answer · 2013-02-18 09:06:26Z

3

Inserting Bit value to the database

  cmd.Parameters.Add("@check", SqlDbType.Bit).Value = Convert.ToInt16(CheckBoxDT.Checked);

retrieving selected check boxes Try this

<asp:CheckBox ID="CheckBoxDT" runat="server" Checked='<%#((bool)Eval("isActive"))%>'
                        Style="color: #FFFFFF" />

enter image description here

Your code

if (CheckBoxDT.Checked) 
{ 
cmd.CommandText = " Insert into ClientMaster(doTips) values ( 1 )";    
cmd.Parameters.AddWithValue("doTips", bool.Parse("1")); 
cmd.ExecuteNonQuery(); 
} 
else 
{ 
cmd.CommandText = "insert into ClientMaster(doTips) values (0)"; 
cmd.Parameters.AddWithValue("doTips", bool.Parse("0")); 
cmd.ExecuteNonQuery(); 
}

Replace this with

cmd.CommandText = "insert into ClientMaster(doTips) values (@doTips)"; 
cmd.Parameters.Add("@doTips", SqlDbType.Bit).Value = Convert.ToInt16(CheckBoxDT.Checked)
cmd.ExecuteNonQuery();

edited Feb 18, 2013 at 9:06

answered Feb 18, 2013 at 8:43

Developer

8,69743 gold badges137 silver badges254 bronze badges

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

4 Comments

Vikas Vanvi Over a year ago

when i write this code in .cs file it wont work either ` if (CheckBoxDT.Checked) { cmd.CommandText = " Insert into ClientMaster(doTips) values ( 1 )"; cmd.Parameters.AddWithValue("doTips", bool.Parse("1")); cmd.ExecuteNonQuery(); } else { cmd.CommandText = "insert into ClientMaster(doTips) values (0)"; cmd.Parameters.AddWithValue("doTips", bool.Parse("0")); cmd.ExecuteNonQuery(); } `

Developer Over a year ago

Why you are parsing to bool value when your data type is bit

Vikas Vanvi Over a year ago

well it is not giving error but in database checkbox field have this value instead of 1 or 0 , System.Web.UI.WebControls.CheckBox

Developer Over a year ago

Can you post the code you wrote with my code that didn't happen as I posted the working image too

Grant Thomas · Accepted Answer · 2013-02-18 08:23:48Z

1

Chances are you're passing the control, rather than the value of its state; you should be passing the state, and converting that explicitly if necessary:

CheckBox         // a web control, and no standard db type to represent it
CheckBox.Checked // a boolean value, generally translatable to db bit

answered Feb 18, 2013 at 8:23

Grant Thomas

45.1k10 gold badges88 silver badges129 bronze badges

Comments

Karl-Johan Sjögren · Accepted Answer · 2013-02-18 08:25:00Z

0

You are most probably passing the actual control to your database and not the state of it. You need to use myCheckBox.Checked instead of just myCheckBox.

answered Feb 18, 2013 at 8:25

Karl-Johan Sjögren

17.8k7 gold badges66 silver badges75 bronze badges

Collectives™ on Stack Overflow

Conversion failed when converting the varchar value 'System.Web.UI.WebControls.CheckBox' to data type bit

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related