Display Records In Ascending Order As Per Time

Question

Hi All In my datagridview application there are 3 columns(IDDateTime). 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

Nir Bar · 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 Yadav · Answer

Thanks Nir That's really worked!! Regards Vidya

Vidya Yadav · Answer

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 R · Answer

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...