checkbox?

[pavankumar106]

hi i need to update checkbox values to database which is in formview control depending upon wat the user selects?
i ve written the code lik dis but here its updating depending upon the first checkbox
for ex if the first checkbox is true its taking the remaining checkboxes values also as true no matter if their value is false and the same happens for viceversa?
can any1 help me regarding dis?
the code i ve written is below

  CheckBox EmployeeRequestUploadedMailIntranet = ((CheckBox)frmviewpreference.FindControl("chkbxClientRegisMail"));
                   bool  EmployeeRequestUploadMailIntranet=EmployeeRequestUploadedMailIntranet.Checked;
                    CheckBox EmployeeRequestUploadedInternet = ((CheckBox)frmviewpreference.FindControl("chkbxClientRegisMail"));
                   bool  EmployeeRequestUploadInternet=EmployeeRequestUploadedInternet.Checked;
                   //Updating the preferences of the client using SqlHelper.
                   SqlHelper.ExecuteNonQuery(trans, CommandType.Text, "Update tClient set EmployeeRequestUploadedMailIntranet='" + EmployeeRequestUploadMailIntranet + "',EmployeeRequestUploadedInternet='" + EmployeeRequestUploadInternet + "' where ClientID=" + Session["clientId"]);
                   lblmsg.Text = "Preferences Updated";

[Frinavale]

hi i need to update checkbox values to database which is in formview control depending upon wat the user selects?
i ve written the code lik dis but here its updating depending upon the first checkbox
for ex if the first checkbox is true its taking the remaining checkboxes values also as true no matter if their value is false and the same happens for viceversa?
can any1 help me regarding dis?
the code i ve written is below

  CheckBox EmployeeRequestUploadedMailIntranet = ((CheckBox)frmviewpreference.FindControl("chkbxClientRegisMail"));
                   bool  EmployeeRequestUploadMailIntranet=EmployeeRequestUploadedMailIntranet.Checked;
                    CheckBox EmployeeRequestUploadedInternet = ((CheckBox)frmviewpreference.FindControl("chkbxClientRegisMail"));
                   bool  EmployeeRequestUploadInternet=EmployeeRequestUploadedInternet.Checked;
                   //Updating the preferences of the client using SqlHelper.
                   SqlHelper.ExecuteNonQuery(trans, CommandType.Text, "Update tClient set EmployeeRequestUploadedMailIntranet='" + EmployeeRequestUploadMailIntranet + "',EmployeeRequestUploadedInternet='" + EmployeeRequestUploadInternet + "' where ClientID=" + Session["clientId"]);
                   lblmsg.Text = "Preferences Updated";

You are setting both EmployeeRequestUploadedMailIntranet and EmployeeRequestUploadedInternet to the same value...being:

((CheckBox)frmviewpreference.FindControl("chkbxClientRegisMail"));

This is why both of your values are the same.

Cheers!
-Frinny