Bind value to checkbox from database in Asp.net using C#, MSSQL

Question

Am working on a registration page, Where here user has checkbox to select the location and services, Am saving the data in Database as 1 if checked , 0 if form is saved unchecked.

Now in the Edit page for the user Like profile page, am binding the data which is present in database.

I don't know how to bind the checkbox to bind if the user already checked and in database it is saved as '1"

Am using C# and Asp.net. Kindly Help

What is the column type in your database? is it int or bit? — Bharadwaj
– Bharadwaj, Commented May 27, 2014 at 9:24

Pranav Bilurkar · Accepted Answer · 2014-05-27 10:07:09Z

2

You will get either 0 or 1 from database right?? SO, store it in integer variable a;

{
if (a==0)
chkbox1.checked = false
else
chkbox1.checked = true;
}

answered May 27, 2014 at 10:07

Pranav Bilurkar

9751 gold badge9 silver badges26 bronze badges

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

Comments

शेखर · Accepted Answer · 2014-05-27 09:30:54Z

1

You can convert you int value 1 or 0 and then assign to your check-box checked property. If they are string type then convert them to int and then to Boolean

 CheckBox1.Checked = Convert.ToBoolean(0);  // False - Not checked.
CheckBox1.Checked = Convert.ToBoolean(1);   // True - checked.

You can use this method Convert.ToBoolean(value) to convert string to boolean

CheckBox1.Checked = Convert.ToBoolean("false");  // False - Not checked.
CheckBox1.Checked = Convert.ToBoolean("true");   // True - checked.

edited May 27, 2014 at 9:30

answered May 27, 2014 at 9:25

शेखर

17.6k14 gold badges64 silver badges123 bronze badges

5 Comments

Prhem Over a year ago

Thanks Mr. Sekar, My probl;em is how to get the value and bind it in Checkbok and it should be checked If the value is saved as True in Database

Prhem Over a year ago

<asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# !Convert.ToBoolean(Eval("Mycolumnname")) %>' /> In userprofile.aspx.cs file...How should i bind sir?!

Bharadwaj Over a year ago

<%# Convert.ToBoolean(Eval("Mycolumnname").ToString()) %>

Prhem Over a year ago

am using this in .cs SqlConnection con = new SqlConnection (@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\PRJT2\Documents\Visual Studio 2012\Projects\divlesson\divlesson\App_Data\divlession.mdf;Integrated Security=True"); con.Open(); SqlDataAdapter Comm = new SqlDataAdapter("SELECT HobbyID,IsChecked from Hobbies where HobbyID='1'", con); Boolean result; result = Convert.ToBoolean(CheckBox1.Checked); con.Close(); I couldn't get my Check box Checked Even the value is 'True' in the Database

Prhem Over a year ago

Sir , Any soultio0n how should in get checkbox binded from database?

Pranav Bilurkar · Accepted Answer · 2014-05-27 09:45:21Z

0

<asp:checkbox id="Cluster" runat="server" checked='<%# Eval("Cluster") == DBNull.Value ? false : Eval("Cluster") %>' />

answered May 27, 2014 at 9:45

Pranav Bilurkar

9751 gold badge9 silver badges26 bronze badges

4 Comments

Prhem Over a year ago

Kindly Tell me the code which i holud use in .cs page?

Pranav Bilurkar Over a year ago

above code is of design...cluster is the column name

Prhem Over a year ago

Say two columns in Database UserID(int) and Ischecked(bit)

Prhem Over a year ago

Mr pranav I understood that sir, I need help how to call the checkbox in pageload in cs page from my database

josliber · Accepted Answer · 2015-09-21 14:01:58Z

0

You can use the below code to get the value from the database and represent it in the web form:

CheckBox1.Checked = rdr.GetBoolean(3);

edited Sep 21, 2015 at 14:01

josliber

44.4k12 gold badges103 silver badges136 bronze badges

answered Sep 21, 2015 at 12:09

Ahmed sayed

195 bronze badges

Collectives™ on Stack Overflow

Bind value to checkbox from database in Asp.net using C#, MSSQL

4 Answers 4

Comments

5 Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

5 Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related