How can we get a latest updated value from a column in a table of sql database

See more:

C#

SQL

database

table

I have a table in the database, and that table consists of 5 columns, in the 5th column there will be a number "139". That number will be updated from time to time. So in the database when i get 139 newly, i have to get the number in the same row which is in the 2nd column. and then i have to store value in one variable and compare it with the SQL database of another table.


The code i have tried is:-

static void Main(string[] args)
        {
            // Create the connection to the resource!
            // This is the connection, that is established and
            // will be available throughout this block.
            using (SqlConnection conn = new SqlConnection())
            {
                // Create the connectionString
                // Trusted Connection is used to denote that the connection uses Windows Authentication
                conn.ConnectionString = "Server=[(local)];Database=[ModelDB];Trusted_Connection=true";
                conn.Open();


                // Create the command
                SqlCommand command = new SqlCommand("SELECT Alarms.Text, Routetable.Latitude, Routetable.Longitude FROM Alarms INNER JOIN Routetable ON Alarms.Text=Routetable.Location;", conn);
               
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    Console.WriteLine("Text\t");
                    while (reader.Read())
                    {
                        Console.WriteLine(String.Format("{0} \t ",
                            reader[0]));
                    }
                }
                Console.WriteLine("Coordinates displayed!!");
                Console.ReadLine();
                Console.Clear();

            }
            // Final step, close the resources flush dispose them. ReadLine to prevent the console from closing.
            Console.ReadLine();
        }
    }
}

are there any suggestions?

How the value updates is as shown below:

http://postimg.org/image/rq6wbbw5b/