public bool PopolaCamere(ListView obj)
        {
            if (m_oConn.State != ConnectionState.Open) return false;

            DataSet oDataSet = new DataSet();
            ListViewItem li;

            OleDbDataAdapter oDataAdapter = new OleDbDataAdapter("SELECT " +
                                                                            "camere.iID," +
                                                                            "camere.sCamera," +
                                                                            "tariffazioni.iID_Camera " +
                                                                            "FROM camere " +
                                                                            "LEFT JOIN tariffazioni ON (camere.iID = tariffazioni.iID_Camera) " +
                                                                            "GROUP BY camere.iID, camere.sCamera, tariffazioni.iID_Camera " +
                                                                            "ORDER BY camere.iID ASC;", m_oConn);

            try
            {
                oDataAdapter.Fill(oDataSet, "camere");
            }
            catch
            {
                return false;
            }

            DataTable oDataTable = oDataSet.Tables["camere"];

            obj.Items.Clear();

            foreach (DataRow oDataRow in oDataTable.Rows)
            {
                li = obj.Items.Add(oDataRow["iID"].ToString());
                li.SubItems.Add(oDataRow["sCamera"].ToString());

                if (oDataRow.IsNull("iID_Camera"))
                {
                    li.ForeColor = Color.Red;
                }
                else
                {
                    li.ForeColor = Color.Black;
                }
            }

            return true;
        }