how to save check box selected items to Database?

Question

4.00/5 (1 vote)

See more:

SQL-Server-2005

, +

XML

<asp:DataList ID="dlFav" runat="server" RepeatColumns="4"
            RepeatDirection="Vertical" ondeletecommand="dlFav_DeleteCommand">
    <ItemTemplate>
    <font color="red">Added User:</font><asp:Label ID="lblUserId" runat="server" Text='<%# Eval("AddedUserID") %>'></asp:Label><br />
    <font color="red">ProductID:</font><asp:Label ID="lblProductID" runat="server" Text='<%# Eval("ProductID") %>'></asp:Label><br />
    <font color="red">ProductName:</font><asp:Label ID="lblProductName" runat="server" Text='<%# Eval("ProductName") %>'></asp:Label><br />
    <font color="red">Price:</font><asp:Label ID="lblPrice" runat="server" Text='<%# Eval("Price") %>'></asp:Label><br />
    <font color="red">Image Url:</font><asp:Image ID="ImageUrl" runat="server" ImageUrl='<%#Eval("ImageUrl") %>'></asp:Image>
        <br />
        <asp:CheckBox ID="chkDl" runat="server" Text="Select" 
            CommandName="Select" />
        <br />


    </ItemTemplate>
    </asp:DataList>

XML

<table>
   <tr>
   <td>

       <asp:Button ID="btnadd" runat="server" Text="Add" />
   </td>
   </tr>

    </table>

hi this is my source code.in checkbox click i want to add data to database.,.can any one solve..i want to add multiply data to database while selcting checkbox and while clicking add button i want to save data to database..

Posted 3-Jan-12 19:47pm

ythisbug

Add a Solution

Comments

devbtl 4-Jan-12 2:18am

you are saving data by clicking checkbox or add btn ?

ythisbug 4-Jan-12 3:54am

first i want to select checkbox after that i want to click add then only it should add to database..u got my point??

ythisbug 4-Jan-12 4:14am

is there anyone to help??

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pr!y@ · Answer 1 · 2012-01-03T19:54:00

Solution 1

Visit This Link

http://stackoverflow.com/questions/919514/save-checkbox-value-to-a-database-when-clicked[^]

Posted 3-Jan-12 19:54pm

Pr!y@

Updated 3-Jan-12 20:21pm

v4

Comments

ythisbug 4-Jan-12 2:10am

can u give more explanation??

ythisbug 4-Jan-12 3:51am

bro thanks..bt this is jquery..can u give me asp.net wid c# link..

Rupa1 · Answer 2 · 2012-01-03T20:15:00

Solution 2

bool data;

C#

if (CheckBox1.Checked)
{
data=True;
}
else
data=False;


//data value u can save in database

Posted 3-Jan-12 20:15pm

Rupa1

Comments

ythisbug 4-Jan-12 4:29am

example..[ProductID][ProductName][Price][Image][checkbox][addbutton]if i select and click to add button then only it should add to database.....

Rupa1 11-Jan-12 5:56am

using findcontrol u can find [Checkbox] using that...we can get it.........

devbtl · Answer 3 · 2012-01-03T22:17:00

you can simply do it by defining your checkbox in rowdatabound of gridview and then pass the checkbox value to query.

C#

CheckBox chk1 = (CheckBox)GridView1.FooterRow.FindControl("chk1");
CheckBox chk2 = (CheckBox)GridView1.FooterRow.FindControl("chk2");

string chk1,chk2;
if ((chk1.Checked == true) && (chk2.Checked == true))
           {
               chk1 = "1";
               chk2 = "1";
           }
           else
           {
               if (chk1 .Checked == true)
               {
                   chk1 = "1";
                   chk2= "0";
               }
               else
                   if (chk2.Checked == true)
                   {
                       chk1 = "0";
                       chk2= "1";
                   }

           }

and use these values into ur insert query

for checkbox insertion

SQL

select cast('" + chk1+ "' + ',' + '" + chk2+ "' as varchar(100)) as db_column from tablename

m@dhu · Answer 4 · 2012-01-03T23:10:00

Solution 4

In your btnadd_Click event

foreach (DataListItem item in DataList1.Items)
            {
               
                CheckBox chk = (CheckBox)item.FindControl("CheckBox1");
                if (chk.Checked == true)
                {
                    //save data to database.
}
            }

Posted 3-Jan-12 23:10pm

m@dhu

Comments

ythisbug 4-Jan-12 5:37am

foreach (DataListItem item in DataList1.Items)
{
CheckBox chk = (CheckBox)item.FindControl("CheckBox1");
if (chk.Checked == true)
{
string UserID = "";
string ProductID = "";
string ProductName = "";
string Price = "";
string ImageUrl = "";

ProductID = lblProduct.Text;
ProductName = lblName.Text;
Price = lblPrice.Text;
ImageUrl = imgImage.ImageUrl;

@madhu m getting error here..like lblName doesnot exist like for all label too..

m@dhu 4-Jan-12 7:38am

You got to use findcontrol method to find all those labels and image, as it is for checkbox. Like
Label lblUSerID=(Label)item.FindControl("lblUserId");

how to save check box selected items to Database?

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us