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);