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