My guess would be just intellisense your way to the property.

I just tried it and got

dgvMyGrid.Columns.Item(1).CellTemplate.Style.Format = "d"
or
dgvMyGrid.Columns.Item("MydateColumn").CellTemplate.Style.Format = "d"

( I have to admit it wasn't immediately apparent <s> )

Of course I haven't done any webforms yet and I'm just assuming the control works the same way there, but give it a try and let me know

oh, and there is a cellformatting event for the dgv, so you may have to handle that and set it there if you are doing it programmatically.

But is this necessary on a web form? Can't you set the property on the grid control itself at design time?




>Hi Charles. Thanks for taking the time to respond. I'm not sure your suggestion works for me because I'm doing everything in the VB Code-behind rather than on the Properties sheet.
>
>Do you have any suggestions/samples for how to apply the formatting to a particular column in code?
>
>Thanks............Rich
>
>
>>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