listbox如何遍历所有记录写入数据库?

Question

我想把listbox中所有记录存入car_park_fee表，现在提示我找不到属性selected和text是什么原因。
 for(int i=0;i<l_sd_list.Items.Count;i++)
                    {
                        if(l_sd_list.Items[i].selected == true) //object不包含select的定义
                        {
                            lsd_text = l_sd_list.Items[i].text //object不包含text的定义
                            fee_end = "insert into car_park_fee (sd_syjh) values ('" + sd_syjh + "’)";
                            SqlConnection conn_up = new SqlConnection(fee_conn.sql_conn());
                            SqlCommand update = new SqlCommand(fee_end, conn_up);
                            conn_up.Open();
                            update.ExecuteNonQuery();
                            conn_up.Close();
                        }
                    }

Answer 1

string lsd_text = l_sd_list.selectitem.tostring();
fee_end = "insert into car_park_fee (sd_syjh) values ('" + sd_syjh + "’)";
SqlConnection conn_up = new SqlConnection(fee_conn.sql_conn());
                            SqlCommand update = new SqlCommand(fee_end, conn_up);
                            conn_up.Open();
                            update.ExecuteNonQuery();
                            conn_up.Close();
                            SqlCommand update = new SqlCommand(fee_end, conn_up);
                            conn_up.Open();
                            update.ExecuteNonQuery();
                            conn_up.Close();
                        }
                    }