I am making a scheduling system. And I am having trouble sorting my datagrid by the times in the grid. For example if you insert a surgery [email protected]
12:00pm and then insert another one @ 2:00pm the one @ 2:00 pm will display before the 12:00pm ; if someone can help me with this I am greatly appreciative. I am going to post an example of the search function that displays the datagrid with the information I am talking about.
Public Function Search()
Dim table As String = "Schedule"
Dim SearchCrit As String = Dtpdate.Value.Date
Dim dsschedule As New DataSet()
dsschedule = dsFill("SELECT * FROM Schedule" _
+ " WHERE Dates = '" + SearchCrit + _
"' ORDER BY Times ASC", table, "select")
.DataSource = dsschedule
.DataMember = table
.ReadOnly = True