In the datagridview, take a look at the columns collection. On that column find the defaultcellstyle (top of list) hit the elipsis on the end of the line and in the Format property hit the elipsis again ( or just put a small d in the Format property )


>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