I'm sure few people just like i did a few hours ago. i have a problem when having a code and debugging an application in VB.Net.
case :
i want to show data in datagridview from a database with field using DateTime type. but sure it was confused me, how to show data for only the time not include the date (sample, 13:30:00). as datetime format is should always shows (29/07/2013 13:30:00).
then after fighting couple hours finally i get this code. so i hope it can solve if one of you having same trouble as i did...
DTA = New SqlDataAdapter("SELECT IdMaintenance, IdMesin, IdSistemUser, IdSimpulMasalah, " & _
"IdSeksi, Convert(Varchar,JamMulai,101) as Mulai, " & _
"Convert(Varchar,JamMulai,108) as JMulai, " & _
"Convert(Varchar,JamSelesai,101) as Selesai, " & _
"Convert(Varchar,JamSelesai,108) as JSelesai, " & _
"InformasiMain, PenyebabMain, PerbaikanMain, TindakanMain, PesanMain " & _
"FROM MaintenanceTabel ORDER BY IdMaintenance ASC", MeKONEKSI.BUKAKONEKSI)
"IdSeksi, Convert(Varchar,JamMulai,101) as Mulai, " & _
"Convert(Varchar,JamMulai,108) as JMulai, " & _
"Convert(Varchar,JamSelesai,101) as Selesai, " & _
"Convert(Varchar,JamSelesai,108) as JSelesai, " & _
"InformasiMain, PenyebabMain, PerbaikanMain, TindakanMain, PesanMain " & _
"FROM MaintenanceTabel ORDER BY IdMaintenance ASC", MeKONEKSI.BUKAKONEKSI)
pay more attention to codes :
Convert(Varchar,JamMulai,101) as Mulai
above code is to show only DATE data from field name JamMulai (29/07/2013)
Convert(Varchar,JamMulai,108) as JMulai
above code is to show only TIME data from field name JamMulai (13:30:00)
Comments
Post a Comment