I have a date column in the database,
It needs to appear in the drop down box in a form.
I put the SQL Command as "select distinct PDate from OPayment order by PDate desc"
The dates appear in alphabetical order not date descending order.
then i created a dataview
Using dt As New System.Data.DataTable
adp.Fill(dt)
Dim dv As New DataView(dt)
dv.Sort = "PDate DESC"
dplPPEDate.DataSource = dv
dplPPEDate.DataTextField = "PDate"
dplPPEDate.DataValueField = "PDate"
dplPPEDate.DataBind()
End Using
This is sorting the date in right order but attaches time to the date 12/05/2014 12:00 AM
How to get rid of the time stamp please guide.
The SQLcolumn is of type date o ...
Go to the complete details ...