Please Respond Urgent !!!!!!!!! HelpMe

[RSAAVEDRA]

Hello all,

We have a DataSet bound to a DataGrid, this DataSet has a datetime column, coming from SQL Server.

We want to show this field on the DataGrid always as "DD/MM/YYYY", ignoring user's regional configuration.

For example if the user has the date regional configuration as "DD*MM*YYYY" (with stars), the DataGridTextBoxColumn shows the date as "DD*MM*YYYY" even if our code is:

DataGridTextBoxColumn oTextBoxNatural = new DataGridTextBoxColumn();
oTextBoxNatural.MappingName = "datetime_field";
oTextBoxNatural.HeaderText = "Show date as DD/MM/YYYY";
oTextBox.Format = "dd/MM/yyyy";
oTextBoxNatural.Width = 100;
dty.GridColumnStyles.Add(oTextBoxNatural);

How can we show the date always as "DD/MM/YYYY"? We do not want to depend on user's regional configuration since in our environment each user configurates this as they want.

Thanks a lot.

[jmcilhinney]

Please use descriptive thread titles, otherwise having titles at all is pointless. Help us help you. Also, this is a duplicate thread. Do not create duplicate threads as they simply clutter the forum and make it harder for people trying to help you and others trying to search for information. If you want to add information or bump your thread up the list simply add a new post to your existing thread. If noone has answered maybe noone knows. Try following the Windows Forms FAQ link in my signature. It has a wealth of information about using the DataGrid.

I have never used styles on a DataGrid before but I just tried something similar and it worked fine. Have you made sure that you add the column styles to the table style before adding the table style to the grid?

[jmcilhinney]

I'm using standard Australian date format, which is d/M/yyyy. Here's my code:

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim dt As New DataTable
 
        dt.Columns.Add("Date", GetType(Date))
 
        For i As Integer = 1 To 10
            Dim dr As DataRow = dt.NewRow()
 
            dr("Date") = Date.Today.AddDays(i)
            dt.Rows.Add(dr)
        Next
 
        Me.DataGrid1.DataSource = dt
 
        Dim dgtbc As New DataGridTextBoxColumn
 
        dgtbc.MappingName = "Date"
        dgtbc.HeaderText = "Formatted Date"
        dgtbc.Format = "yyyy/MM/dd"
 
        Dim dgts As New DataGridTableStyle
 
        dgts.GridColumnStyles.Add(dgtbc)
        Me.DataGrid1.TableStyles.Add(dgts)
    End Sub

and here's the result: