dd-MM-yyyy format in datagrid

[chinhow]

Hi, all
I retrieved the date from the Access database, the date format was MM-dd-yyyy which displayed in Datagrid, but how do I convert to dd-MM-yyyy in Datagrid?


Thanks!

[jamesang5]

Dim strSQL As String
strSQL = "SELECT CAST(READINGS.READING_TIMESTAMP AS DATETIME) AS 'Time Stamp', "
strSQL += "READINGS.reading_value * tblMeterType.meter_multiplier AS 'Value' "
strSQL += "FROM READINGS INNER JOIN (tblMeters INNER JOIN tblMeterType ON tblMeters.meter_type_counter = tblMeterType.meter_type_counter) ON READINGS.meter_counter = tblMeters.meter_counter "
Dim data_Dataset As New DataSet
Dim data_adapter As OdbcDataAdapter
Dim myConnectString As String = MyConString

' Create the SqlDataAdapter.
data_adapter = New OdbcDataAdapter(strSQL, myConnectString)
Try
Cursor.Current = Cursors.WaitCursor
' Map Table to Contacts.
Me.dataGridList.TableStyles.Clear()
data_adapter.TableMappings.Add("Table", "Contacts")

' Fill the DataSet.
data_adapter.Fill(data_Dataset)

' Bind the DataGrid control to the Contacts DataTable.
Me.dataGridList.DataSource = data_Dataset.Tables("Contacts")

Dim DGTextColTime As New DataGridTextBoxColumn
With DGTextColTime
.MappingName = "TIME STAMP"
.HeaderText = "Time Stamp"
.Format = "MM/dd/yyyy HH:mm:ss"
.Width = 125
.ReadOnly = True
End With

Dim DGTextColVal As New DataGridTextBoxColumn
With DGTextColVal
.MappingName = "VALUE"
.HeaderText = "Value"
.ReadOnly = True
End With

Dim oTblStyle As New DataGridTableStyle
oTblStyle.MappingName = "Contacts"

Dim oGridColStyles As GridColumnStylesCollection
oGridColStyles = oTblStyle.GridColumnStyles
oGridColStyles.Add(DGTextColTime)
oGridColStyles.Add(DGTextColVal)

dataGridList.TableStyles.Add(oTblStyle)

Dim numRows As Integer = dataGridList.BindingContext(dataGridList.DataSource, _
dataGridList.DataMember).Count
Me.dataGridList.CaptionText = numRows & " records."


Hope this example can help you.

ANG

[MrNorth]

What about the CONVERT() method in sql? I sue that to fix dates. Or perhaps that only works in sql server... I don't know much access...


kind regards
Henrik