Sort field or expired date notifications, database

Question

I know nothing about database, I’m using one in Visual Studio (the standard SQL called "Service-based database"), I’ve integrated it into the form and made up the query fields.

But there is a field of one of the tables that would date, that date is like a 'loan', and it expires (one week from now, as an example).

Then comes the doubt (I researched and found nothing about it).

The question is:

How do I order a table of this database by the data, showing the field records of the data older to younger?

Another doubt (this is more advanced), but the first one is enough for me (I am humble kk), it’s like, this field of data, as I said, it’s like loan, so I wanted to know, taking example the record:

"Nome: José", "Data do empréstimo: 23/06/2015"

In this table, as I stimulated the due date is one week, the maturity would be today, so how to take this database record and store it in a variable (to be displayed in another form)?

The other field:

"Nome: João", "Data do empréstimo: 24/06/2015"

The expiration would be tomorrow, so tomorrow he would send this record to the other form automatically, as if it were an expiration notice.

Answer 1

at first just sort the dates you can use order by.

Ex: SELECT * FROM usuarios ORDER BY dataemprestimo ASC

descfor decreasing and asc to ascend, how much to catch the expiry date, in the function Load form, you can call a function to do this, you can create an instruction sql to get it in the bank something like:

Ex: SELECT * FROM usuarios where dataemprestimo > datalimite

so you would have all the records that exceeded the deadline, detail, to work that query you need a field that is stored the deadline for the user to return the product, simple thing to do on insertand on the schedule when registering.

Note: if you give me the name of the tables I put here the function.

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
   notificarUsuarios()
End Sub

 Private Sub notificarUsuarios()
 se quiser apenas armazenar 1 data, mais vc pode jogar em um datagrid
     Dim nomeDoUsuario As String = nomeDataSet.Tables("usuarios").Rows(0)("usuario")
     Dim dataVencida As String = nomeDataSet.Tables("usuarios").Rows(0)("dataexpira")
 End Sub

Answer 2

If you want the OLDEST date and not the NEWEST one, you want ascendant and not descending.

SELECT * FROM Emprestimo
ORDER BY dataemprestimo ASC

Sqlfiddle Example

About your second problem, you can use the Sql Server variable to get the current day and time GETDATE().

That way in a table the losers is:

SELECT * FROM Emprestimo
WHERE datalimite <= GETDATE()
ORDER BY dataemprestimo ASC

And on the table those who haven’t won yet are:

SELECT * FROM Emprestimo
WHERE datalimite > GETDATE()
ORDER BY dataemprestimo ASC