I have several checkboxes on a web form whose values I need to save to a database, then be able to retrieve them to an editable form. I know that to retrieve them, I need the check box to save not as the usual true/false answer but as a tinyint 1 or 0 in a SQL database table.

Is there C# code available to help me figure this out?

rdove84

Just create a variable

int i;
if(checkbox.checked){
 i = 1;
}
else{
 i = 0;
}

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

Thank you for such a quick reply.

I have one more question. I'm saving my information via a stored procedure into a column marked tinyint. All of my other columns from my form are saved via lines like this:

f1.ELECTRICITY = this.electricity.SelectedValue; (or Text, etc)

However, when I try to save the Checkbox items I get one of two messages. The item cannot be implicitly converted from string to int or cannot implicitly convert bool. I thought at first after the making my checkbox equal 1 or 0 that I then should call a line like the one above (f1.HUMANSUBJECT = this.humanSubject.Checked) but I keep getting errors. Is there something else I should be doing?

rdove84

ok you can't do f1.HUMANSUBJECT = this.humanSubject.Checked if you have declared f1.HUMANSUBJECT as an integer because the return type of this.humanSubject.Checked is a boolean. I see 2 choices:

1)Change your database datatable column from tinyint to a BIT datatype and you can pass in a bool value (TRUE/FALSE)
2)You will have to use an If statement to determine what the value of your int will be.

hth

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

Thank you so much that did the trick.

No problem glad it worked. =]

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature