public override bool Load() { bool ret = true; //List<long> idlist = new List<long>(); if (Common.Conn == null) { Common.Conn = new SQLiteConnection(Common.ConnectionString); Common.Conn.Open(); } SQLiteDataReader myReader = null; SQLiteCommand myCommand = new SQLiteCommand(); try { myReader = null; myCommand.CommandText = @"SELECT * FROM [tblAlarm] where VarNameID = " + m_VarNameID_tblVariable.VarNameID + ";"; myCommand.Connection = Common.Conn; myReader = myCommand.ExecuteReader(); while (myReader.Read()) { tblAlarm tblalarm = new tblAlarm(); tblalarm.m_VarNameID_tblVariable = this.m_VarNameID_tblVariable; tblalarm.AddFromRecordSet(myReader); this.Add(tblalarm); } myReader.Close(); myCommand.Dispose(); //int count = idlist.Count; //foreach (long id in idlist)// (int i = 0; i < count ; i++) //{ // tblAlarm tblalarm = new tblAlarm(); // tblalarm.ID = id;// idlist[i]; // tblalarm.m_VarNameID_tblVariable = this.m_VarNameID_tblVariable; // tblalarm.Select(); // this.Add(tblalarm); //} } catch (SQLiteException ae) { MessageBox.Show(ae.Message.ToString()); return(false); // } return(ret); }