How to insert muntiple chechbox values into database using asp.net

Posted by Mandlaa under ASP.NET on 5/2/2013 | Points: 10 | Views : 18934 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi every one ,how to insert multiple checkbox values into database using asp.net

Please give me one simple complete example on this

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Santhi on: 5/2/2013 [Member] Starter | Points: 25

0	Hi Do you want to insert all the selected checkbox list values in to a single column??????????? or in multiple columns???????????? Thanks & Regards, Santhi .V Mandlaa, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Santhi on: 5/2/2013 [Member] Starter | Points: 25

0	Hi If you are going to insert all the values in a single column.......... Do like this. For example: protected void Button1_Click(object sender, EventArgs e) { String str = ""; for (int i = 0; i <=CheckBoxList1.Items.Count-1; i++) { if (CheckBoxList1.Items[i].Selected) { if (str == "") { str = CheckBoxList1.Items[i].Text; } else { str += "," + CheckBoxList1.Items[i].Text; } } } con.Open(); SqlCommand cmd = new SqlCommand("insert into tablename values('" +str + "')", con); cmd.ExecuteNonQuery(); } Thanks & Regards, Santhi .V Mandlaa, if this helps please login to Mark As Answer. \| Alert Moderator

Hi

If you are going to insert all the values in a single column..........
Do like this.
For example:

protected void Button1_Click(object sender, EventArgs e)

{

       String str = "";



    for (int i = 0; i <=CheckBoxList1.Items.Count-1; i++)

    {



        if (CheckBoxList1.Items[i].Selected)

        {



            if (str == "")

            {

                str = CheckBoxList1.Items[i].Text;

            }

            else

            {

                str += "," + CheckBoxList1.Items[i].Text;



            }



        }

    }

    con.Open();

    SqlCommand cmd = new SqlCommand("insert into tablename values('" +str + "')", con);

    cmd.ExecuteNonQuery();

  }

Thanks & Regards,
Santhi .V

Mandlaa, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts