public CDeviceListItem[] CSQL_GetDeviceList() { string sql = "SELECT devices.device_id " + "FROM devices;"; string sql_count = "SELECT devices.device_id, count(*) as TotalDevices " + "FROM devices;"; SqliteCommand dbhCmd = null; SqliteDataReader dbhReader = null; CDeviceListItem[] _device_list = null; int device_count = 0; int count = 0; if (CSQL_Connected()) { dbhCmd = new SqliteCommand(sql_count, dbh); dbhReader = dbhCmd.ExecuteReader(); /** * Get the number of devices for the array size. */ if (dbhReader.HasRows) { dbhReader.Read(); device_count = dbhReader.GetInt32(1); if (device_count == 0) { cleanup(); return(null); } } else { cleanup(); return(null); } } _device_list = new CDeviceListItem[device_count]; dbhCmd = new SqliteCommand(sql, dbh); dbhReader = dbhCmd.ExecuteReader(); if (dbhReader.HasRows) { while (dbhReader.Read()) { _device_list [count++] = new CDeviceListItem(dbhReader.GetString(0)); } cleanup(); return(_device_list); } else { cleanup(); return(null); } cleanup(); return(null); }
public CDeviceListItem[] CSQL_GetDeviceList() { string sql = "SELECT devices.device_id " + "FROM devices;"; string sql_count = "SELECT devices.device_id, count(*) as TotalDevices " + "FROM devices;"; SqliteCommand dbhCmd = null; SqliteDataReader dbhReader = null; CDeviceListItem[] _device_list = null; int device_count = 0; int count = 0; if (CSQL_Connected ()) { dbhCmd = new SqliteCommand (sql_count, dbh); dbhReader = dbhCmd.ExecuteReader (); /** * Get the number of devices for the array size. */ if (dbhReader.HasRows) { dbhReader.Read (); device_count = dbhReader.GetInt32 (1); if (device_count == 0) { cleanup (); return null; } } else { cleanup (); return null; } } _device_list = new CDeviceListItem[device_count]; dbhCmd = new SqliteCommand (sql, dbh); dbhReader = dbhCmd.ExecuteReader (); if (dbhReader.HasRows) { while (dbhReader.Read ()) { _device_list [count++] = new CDeviceListItem (dbhReader.GetString (0)); } cleanup (); return _device_list; } else { cleanup (); return null; } cleanup (); return null; }