<div>
If you are not using datagrid tablestyle, after you set the datasource of the datagrid, add the following code:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim myGridTableStyle As DataGridTableStyle = New DataGridTableStyle<br />
&nbsp; &nbsp; &nbsp; &nbsp; myGridTableStyle.MappingNa<wbr />me = DataGrid1.DataSource.Table<wbr />Name<br />
&nbsp; &nbsp; &nbsp; &nbsp; DataGrid1.TableStyles.Clea<wbr />r()<br />
&nbsp; &nbsp; &nbsp; &nbsp; DataGrid1.TableStyles.Add(<wbr />myGridTabl<wbr />eStyle)<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; 'ColumnNumber1 is the datetime column number <br />
&nbsp; &nbsp; &nbsp; &nbsp; Dim myTextBoxColumn1 As DataGridTextBoxColumn = DataGrid1.TableStyles(0).G<wbr />ridColumnS<wbr />tyles(Colu<wbr />mnNumber1)<wbr /><br />
&nbsp; &nbsp; &nbsp; &nbsp; myTextBoxColumn1.Format = &quot;yyyy/MM/dd HH:mm:ss&quot;<br />
<br />
If you are using table style, just add &nbsp;myTextBoxColumn1.Format = &quot;yyyy/MM/dd HH:mm:ss&quot; to that column.<br />
<br />

</div>


If you are not using datagrid tablestyle, after you set the datasource of the datagrid, add the following code:

        Dim myGridTableStyle As DataGridTableStyle = New DataGridTableStyle
        myGridTableStyle.MappingName = DataGrid1.DataSource.TableName
        DataGrid1.TableStyles.Clear()
        DataGrid1.TableStyles.Add(myGridTableStyle)

        'ColumnNumber1 is the datetime column number
        Dim myTextBoxColumn1 As DataGridTextBoxColumn = DataGrid1.TableStyles(0).GridColumnStyles(ColumnNumber1)
        myTextBoxColumn1.Format = "yyyy/MM/dd HH:mm:ss"

If you are using table style, just add  myTextBoxColumn1.Format = "yyyy/MM/dd HH:mm:ss" to that column.



<div>
that seems like a lot of lines of code just to change the format for one column. <br />
<br />
I don't quite understand what the code is doing here. Is it reading in a table that contains styles for each column?<br />

</div>


that seems like a lot of lines of code just to change the format for one column.

I don't quite understand what the code is doing here. Is it reading in a table that contains styles for each column?


<div>
<div class="content wysiwyg-content">
<br />
I am displaying data using a datagrid. However, when I display a datetime field from MS SQLserver, it only displays the date, and not the time. <br />
<br />
Is there a way to change the format of a column in a datagrid so that both the date and the time are displayed?<br />
<br />
-brokeMyLegBiking<br />
<br />

</div>
</div>



I am displaying data using a datagrid. However, when I display a datetime field from MS SQLserver, it only displays the date, and not the time. 

Is there a way to change the format of a column in a datagrid so that both the date and the time are displayed?

-brokeMyLegBiking



change datagrid column display format

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,