store multiple selection from listbox into sql database
I Have list box called listbox1, proprties : multiple selection , what i need to is to store these multiple selections into sql database field 

**NOTE : I AM USING WEB FORMS , ASP.NET , C# , VISUAL STUDIO WEB DEVELOPER 2010 EXPRESS**

here is my code

    SqlCommand insertNL = new SqlCommand("insert into dbo.newsletter (newsletter_subject,newsletter_body,newsletter_sentto) VALUES ('" + TextBox1.Text + "', '" + TextBox2.Text + "', '" + ListBox1.SelectedItem + "')", badersql);
            badersql.Open();
            insertNL.ExecuteNonQuery();
            badersql.Close();

when i run the code , it stores only the first selected value in the attribute "newsletter_sentto" , any suggestions ?


store multiple selection from listbox into sql database
===

I Have list box called listbox1, proprties : multiple selection , what i need to is to store these multiple selections into sql database field 

**NOTE : I AM USING WEB FORMS , ASP.NET , C# , VISUAL STUDIO WEB DEVELOPER 2010 EXPRESS**

here is my code

    SqlCommand insertNL = new SqlCommand("insert into dbo.newsletter (newsletter_subject,newsletter_body,newsletter_sentto) VALUES ('" + TextBox1.Text + "', '" + TextBox2.Text + "', '" + ListBox1.SelectedItem + "')", badersql);
            badersql.Open();
            insertNL.ExecuteNonQuery();
            badersql.Close();

when i run the code , it stores only the first selected value in the attribute "newsletter_sentto" , any suggestions ?

