public dbTSFLibrary getTSFLibraryByName(String libraryName )
{
dbTSFLibrary lb = new dbTSFLibrary();
String sql = "SELECT * FROM "
+ dbTSFLibrary._TABLE_NAME
+ " WHERE "
+ dbTSFLibrary._LIBRARY_NAME
+ " = ?";
OleDbParameter[] dbParams = { CreateParameter(dbTSFLibrary._ID, libraryName) };
OleDbDataReader reader = ExecuteSqlQuery(sql, dbParams);
if (reader != null)
{
while (reader.Read())
{
lb.load(reader);
lb.Signals = getTSFLibrarySignals(lb.id);
}
reader.Close();
reader.Dispose();
}
return lb;
}