Skip to main content

How To Separate Date & Time For DateTime Format In SQL2005 With VB.Net

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)


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

Popular posts from this blog

CheckBox dalam DataGridView VB.Net

Pada saat membuat aplikasi (VB.Net) untuk materi skripsi, terbesit bagaimana cara baru untuk memberikan hak akses user secara dinamis pada sistem. setelah dicoba dengan tanya-tanya. akhirnya bisa mendapatkan cara itu... wah sesuatu banget dah.... inti dari posting ini hanya pada barisan kode berikut : Private Sub BtnSIMPAN_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnSIMPAN.Click         Dim Y As String = Mid(CmbUSER.Text, 1, 7)         Dim iROW As Integer         Dim AKSES As String         For iROW = 0 To DGVSample.Rows.Count - 1             'AksesBox = Nama CheckBox yang ada di DatagridView             If DGVSample.Rows(iROW).Cells("AksesBox").Value Then    ...

Catch Digit Before Specific Symbol (Desc "-") Using VB.Net 2010

This is the way how to catch digit before a specific symbol, for this case the symbol means (desc "-"). situation would be as follows : "XXXXX-NAME" we would need to catch all "X" before desc "-", so value would be "XXXXX". even "X" is only 4 digits or more less we will get that all digit. VB Script would be as below to support our case : Click below picture for more clear preference