public void PullLongitudeAndLatitude(string dbName)
{
string databasePath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
string databaseFile = databasePath + @"\db_psychrometric_project.s3db";
string connString = @"Data Source=" + databaseFile + ";Version=3;";
string sql = "SELECT * From " + dbName + " WHERE selection=1";
using (SQLiteConnection thisConnection = new SQLiteConnection(connString))
{
using (SQLiteCommand cmdCount = new SQLiteCommand(sql, thisConnection))
{
SQLiteDataReader reader = null;
thisConnection.Open();
reader = cmdCount.ExecuteReader();
while (reader.Read())
{
latValueFromDB = double.Parse(reader["latitude"].ToString());
longValueFromDB = double.Parse(reader["longitude"].ToString());
}
}
}
}