iX Talk

Code: Select all

namespace Neo.ApplicationFramework.Generated
{
	using System.Windows.Forms;
	using System;
	//import Data.SQLite, Reflection for interaction with DataLogger.
	using System.Data.SQLite;
	using System.IO;
	using System.Drawing;
	using System.Reflection;
	using Neo.ApplicationFramework.Tools;
	using Neo.ApplicationFramework.Common.Graphics.Logic;
	using Neo.ApplicationFramework.Controls;
	using Neo.ApplicationFramework.Interfaces;
    
    
	public partial class SQLiteConnection
	{
		public void readSql(){		
			try {
				bool UsbPresent = Directory.Exists("\\Hard Disk");
				if(UsbPresent) {
					//set up connection to internal SQLite database.
					using (var myDb = new SQLiteConnection())
					{
						string executingPath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().ManifestModule.FullyQualifiedName);
						myDb.ConnectionString = string.Format("data source={0}", Path.Combine(executingPath, "Database.db"));
						//open connection to SQLite database.
						myDb.Open();
						//select entire database table (DataLogger1) for readout, sorted by time of entry.
						string queryS = "select * from DataLogger1 order by Time asc";
					
						using (var command = new SQLiteCommand(queryS, myDb))				
						using (SQLiteDataReader reader = command.ExecuteReader())
						{
							//loop through all rows in SQLite database.
							while (reader.Read()) {
								//do whatever you wish with the data here (using reader[x] for data posititions).
								}
							}
						//close connection to SQLite database.
						myDb.Close();
					}
				else {
					//add actions to be run when USB is not found.
				}	
			}
			catch(Exception ex) {
				//any error handling is to be placed here.
			}
		}
	}
}