public List<dbSignal> getRootSignals()
{
XmlDocument doc = new XmlDocument();
List<dbSignal> signals = new List<dbSignal>();
String sql = "SELECT * FROM signal_master WHERE parent_signal_id=? ORDER BY signal_name";
OleDbParameter[] dbParams = { CreateParameter("@parent_signal_id", 1) };
using (OleDbDataReader reader = ExecuteSqlQuery( sql, dbParams ))
{
if (reader != null)
{
while (reader.Read())
{
dbSignal signal = new dbSignal();
signal.load( reader );
signal.ChildSignals = getChildSignals( signal.signalId );
signal.Attributes = getSignalAttributes( signal.signalId );
signals.Add( signal );
}
reader.Close();
reader.Dispose();
}
}
return signals;
}