I want to show Time Field of a MS Access table into a datagridview
C#
4
Posts
2
Posters
0
Views
1
Watching
-
I have a field in a table in a database (MS Access). I have defined datatype : Date/Time with format: Short Time. But when I view my table in a gatagridview, I see for example 12/09/2005 12:35 AM help me please
Sourie
-
Hi Sourie, u can use the following.. dataGridView1[e.ColumnIndex, e.RowIndex].CellStyle.Format = "HH:mm:ss" Not sure about the synatx but it will be just like the above Cheers Hem
-
Hi Hem, I used this syntax: DataGridView1.Columns[6].DefaultCellStyle.Format = "hh:mm:ss"; but its output is the same for both "08:35:00 AM" and "08:35:00 PM" what is your suggestion?
Sourie