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);
}