How to insert different selected checkbox values into database using ASP.NET?

Question

<tr>
 <td>
   <asp:CheckBox ID="checkdoc" runat="server" Checked="false" />:Document
 </td>
 <td>
   <asp:CheckBox ID="checktwocheque" runat="server" Checked="false" />:Two Cheques
 </td>
 <td>
   <asp:CheckBox ID="checkIdprf" runat="server" Checked="false" />:ID Proof
 </td>
</tr>
<tr>
  <td>
   <asp:CheckBox ID="checkpancrd" runat="server" Checked="false" />:PAN Card
  </td>
  <td>
   <asp:CheckBox ID="checkAddrssprf" runat="server" Checked="false" />:Address Proof
  </td>
</tr>
<tr>
  <td colspan="4" align="center">
   <asp:Button ID="btnfarmrecordsave" runat="server" Text="Save" OnClientClick="return Validations();"
    OnClick="btnfarmrecordsave_Click" />
  </td>
</tr>

iam not using checkboxlist control then how to write code for inserting values into database using asp.net.Can anyBody helpme out.

i have 5 checkboxes if i selected any two or three checkboxes then i have to insert those values into database using asp.net — santhosha
– santhosha, Commented Dec 9, 2013 at 11:41
what is your insert query can you post it ?and what is your expected datatype in database ? — Suraj Singh
– Suraj Singh, Commented Dec 9, 2013 at 11:43
datatype is varchar and Normal insertion Procedure in sql server — santhosha
– santhosha, Commented Dec 9, 2013 at 11:47
So you are providing parameters ? Just convert your checkbox.checked value to string it will do . — Suraj Singh
– Suraj Singh, Commented Dec 9, 2013 at 11:51

Suraj Singh · Accepted Answer · 2013-12-09 11:56:38Z

2

It would be better if your expected datatype is Bit rather than varchar ,However you can insert your values as ,

 string IdProof =Convert.ToString(checkIdprf.Checked);

Change your query use column name in insert query and use ISNULL to so that if a checkbox
value is null it would be entered as FALSE rather than NULL. HERE

 INSERT INTO TABLE_NAME (COL1 ,COL2,....) values (COL1,ISNULL(IdProof,'FALSE'),COL3, etc.. )

edited Dec 9, 2013 at 11:56

answered Dec 9, 2013 at 11:50

Suraj Singh

4,0871 gold badge23 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

How to insert different selected checkbox values into database using ASP.NET?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related