how to save listbox value in sqlserver

Hi,

Have a look at the below code:
It iterates for the number of items in your listbox and inserts them into the table in sql.
Just a sample code..you can enhance it further, and don't forget to use try-catch-finally block..

protected void Button1_Click(object sender, EventArgs e)
    {

        foreach (ListItem item in ListBox1.Items)
        {
            
            SqlCommand cmd =new SqlCommand( "Insert into TableName(ColumnName) Values ("+item.Text+")",xconn);

            xconn.Open();
            cmd.ExcuteNonQuery();
            xconn.Close();

        }

    } 

Hope it helps..

-Anurag