Esempio n. 1
0
        private void GetLastUpdated()
        {
            string SQL = "SELECT TOP 1 CONVERT(varchar, ExecutionTime, 1) AS LastUpdated FROM SavingsEventLog ORDER BY ExecutionTime DESC";

            cmd = new SqlCommand(SQL, con);
            con.Open();
            SqlDataReader dr = cmd.ExecuteReader();

            if (dr.Read())
            {
                string lastUpdated = (dr["LastUpdated"].ToString());
                LastUpdated.AppendText(lastUpdated);
            }
            con.Close();
        }