Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Date displays as DateTime
Message
De
18/12/2009 19:21:29
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Titre:
Date displays as DateTime
Divers
Thread ID:
01439892
Message ID:
01439892
Vues:
99
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform