Display Records In Ascending Order As Per Time

Vidya Yadav

Hi, All
In my datagridview application there are 3 columns(ID,Date,Time).
Now the records are displayed in ascending order regarding ID.
I want to display the records firstly as ascending order by date, and then as ascending order by Time.
How can i do that, is there any prpoerty of datagridview that can allow me to do that?

Regards,
Vidya

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nir Bar17y ago
Accepted answer
Hi Vidya,

SQL allows secondary sort:
You should do:

"SELECT Appointment.APId, PatientDetails.PId, PatientDetails.Name, Appointment.ADate, Appointment.ATime FROM PatientDetails INNER JOIN Appointment ON PatientDetails.PId = Appointment.PId ORDER BY Appointment.ADate ASC, Appointment.ATime ASC"

Please mark this post as an answer if it helps you

Nir
Vidya Yadav17y ago
Thanks, Nir
That's really worked!!

Regards,
Vidya
Vidya Yadav17y ago
Thanks,
But i don't want the user to manullay click on the datagridview header, it must be seen at the time records get inserted in the datagridview, can it be by any code.

I am inserting the data by using the sql query by using the ORDER BY method, but it only displayes the records as ORDER BY Date or Time and i want both of it.

SQL Query is used is--
"SELECT Appointment.APId, PatientDetails.PId, PatientDetails.Name, Appointment.ADate, Appointment.ATime FROM PatientDetails INNER JOIN Appointment ON PatientDetails.PId = Appointment.PId ORDER BY Appointment.ADate ASC"
Regards,
Vidya
Nagesh R17y ago
If you click on the heading of the individual column it should get sorted automatically as in windows explorer or try to handle mouse click event when you click on the column header...