Display the date in the DATAGRID in the long Date Format

Environment: Win2000, vb.net 2002,. net framework 1.0, and SQL server 2000

By default, only the date section is displayed in the datetime column of SQL SERVER 2000 displayed in the DATAGRID.

Phase format (yyyy-mm-dd hh: mm: ss)

Dim myDataGridTableStyle As New DataGridTableStyle ()
MyDataGridTableStyle. MappingName = ctype (datagrid1.datasource, datatable)

Dim aDataGridTextBoxColumn As DataGridTextBoxColumn
Dim aDataGridBoolColumn As DataGridBoolColumn

Application date
ADataGridTextBoxColumn = New DataGridTextBoxColumn ()
ADataGridTextBoxColumn. MappingName = "application date"
ADataGridTextBoxColumn. HeaderText = "application date"
ADataGridTextBoxColumn. Format = "yyyy-mm-dd hh: mm: ss"
MyDataGridTableStyle. GridColumnStyles. Add (aDataGridTextBoxColumn)

Other columns must also be styalized. As a result, only the columns whose style is applied are displayed in the DATAGRID1, and the columns without style are not displayed.

FrmShopAlarmInfo. DefInstance. Maid. Add (myDataGridTableStyle)