Donnie4572
asked on
Sort Datetime
Hi,
I'm using vb.net web application. I have this code to sort data in a datagrid. The data comes from sql 2000 database.
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If IsPostBack Then
Ds1 = CType(Session("Ds"), ds)
Else
da.Fill(Ds1)
Session("ds") = Ds1
dg.DataSource = Ds1.mytable.DefaultView
dg.DataMember = ""
dg.DataBind()
End If
End Sub
Private Sub dg_SortCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls. DataGridSo rtCommandE ventArgs) Handles dg.SortCommand
dg.DataSource = Dsschedview1.schedule.Defa ultView
Ds1.schedule.DefaultView.S ort = e.SortExpression
dg.DataBind()
End Sub
This Works for all my columns except it will not sort my datetime column.
Any idea why?
Donnie
I'm using vb.net web application. I have this code to sort data in a datagrid. The data comes from sql 2000 database.
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If IsPostBack Then
Ds1 = CType(Session("Ds"), ds)
Else
da.Fill(Ds1)
Session("ds") = Ds1
dg.DataSource = Ds1.mytable.DefaultView
dg.DataMember = ""
dg.DataBind()
End If
End Sub
Private Sub dg_SortCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.
dg.DataSource = Dsschedview1.schedule.Defa
Ds1.schedule.DefaultView.S
dg.DataBind()
End Sub
This Works for all my columns except it will not sort my datetime column.
Any idea why?
Donnie
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER