Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Date displays as DateTime
Message
From
18/12/2009 19:21:29
 
 
To
All
General information
Forum:
ASP.NET
Category:
Other
Title:
Date displays as DateTime
Miscellaneous
Thread ID:
01439892
Message ID:
01439892
Views:
100
I have a GridView control on a form. There is a button which populates the grid
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim tvPage1 As TreeView = CType(Session("treeview"), TreeView)

        Dim strConn As String = CType(Me.Master, MasterPage).connectString
        Dim objConn As New MySqlConnection(strConn)
        Dim objDS As New DataSet

        Dim ldDate As String = (CType(ddlDates.SelectedValue, Date).GetDateTimeFormats())(66)

        Dim strSql As String
        strSql = "SELECT action,totNumberActions,Status,totCountStatus,categoryname,createdate " & _
                 "  FROM kpi_mrpactions " & _
                 " WHERE savedate = '" & ldDate & "'" & _
                 "  ORDER BY action,status "

        Dim daMrp As New MySqlDataAdapter(strSql, objConn)
        daMrp.Fill(objDS, "dtMrp")
        GridView1.DataSource = objDS
        GridView1.DataBind()

End Sub
The data is coming from a MySql table.
The < createdate > column is of type DATE (definitely not DATETIME -- I checked). But the column in the gridview is showing a Time portion (for example: 12/12/2009 12:00:00 AM).

Is there a setting somewhere that maps Dates to DateTime displays????

Is there some way to modify the display so that only the date portion shows???

Is there some way to modify the query to ensure a date value is returned and displayed as a date???

All replies greatly appreciated............Rich
Next
Reply
Map
View

Click here to load this message in the networking platform