Posted on: 5/16/2014 12:20:32 AM | Views : 255

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