Get latest date record - SQL query
PROGRAMMING HELP 2017/10/05 03:02
To return the latest record (one record only) from data base table where one of the fields is in Date/Time format:
SELECT TOP 1 * FROM table_name ORDER BY date_time_column_name DESC
Notes:
- for ORACLE instead of TOP 1, ROWNUM shall be used
- the query may return NULL value - suitable exception handling must be provided
Programming in C# using data binding and data view
DataView dv = new DataView(DataSet_name.table_name); string sort = "Date_column_name DESC"; dv.Sort = sort; DateTime rdt; if (dv.Count > 0) rdt = Convert.ToDateTime(dv[0]["Date_column_name"]); // Do not forget to fill the corresponding table adapters before creating data view. TableAdapter.Fill(DataSet_name.table_name); // and only then DataView dv = new DataView(DataSet_name.table_name);