当前位置：文江博客话题详情

如何在 vb.net 中更改 DateTimePicker 的日期格式

发布于 2024-11-03 13:46:08 字数 109 浏览 4 评论 0原文

如何更改 vb.net 中 DateTimePicker 的日期格式，以便日期以 dd/mm/1990 格式显示，没有任何时间值？我尝试将格式更改为“短”，虽然这提供了我需要的日期格式，但它不会删除时间。

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

怀里藏娇 2024-11-10 13:46:08

您需要将 DateTimePicker 的 Format 设置为 Custom，然后分配 CustomFormat。

Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
    DateTimePicker1.Format = DateTimePickerFormat.Custom
    DateTimePicker1.CustomFormat = "dd/MM/yyyy"
End Sub

You need to set the Format of the DateTimePicker to Custom and then assign the CustomFormat.

Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
    DateTimePicker1.Format = DateTimePickerFormat.Custom
    DateTimePicker1.CustomFormat = "dd/MM/yyyy"
End Sub

回复收藏 0 原文

贱贱哒 2024-11-10 13:46:08

使用：

dateTimePicker.Value.ToString("yyyy/MM/dd")

参考以下链接：

http://www.vbdotnetforums.com /schedule-time/15001-datetimepicker-format.html

Use:

dateTimePicker.Value.ToString("yyyy/MM/dd")

Refer to the following link:

http://www.vbdotnetforums.com/schedule-time/15001-datetimepicker-format.html

回复收藏 0 原文

清眉祭 2024-11-10 13:46:08

试试这个代码，它可以工作：

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim CustomeDate As String = ("#" & DOE.Value.Date.ToString("d/MM/yyyy") & "#")
    MsgBox(CustomeDate.ToString)

    con.Open()

    dadap = New System.Data.OleDb.OleDbDataAdapter("SELECT * FROM QRY_Tran where FORMAT(qry_tran.doe,'d/mm/yyyy') = " & CustomeDate & "", con)

    ds = New System.Data.DataSet
    dadap.Fill(ds)
    Dgview.DataSource = ds.Tables(0)
    con.Close()

注意：如果你使用dd作为日期表示，它在选择1到9时不会返回任何内容，所以使用d进行选择

'Date time format
'MMM     Three-letter month.
'ddd     Three-letter day of the week.
'd       Day of the month.
'HH      Two-digit hours on 24-hour scale.
'mm      Two-digit minutes.
'yyyy    Four-digit year.

文档包含日期格式的完整列表。

Try this code it works:

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim CustomeDate As String = ("#" & DOE.Value.Date.ToString("d/MM/yyyy") & "#")
    MsgBox(CustomeDate.ToString)

    con.Open()

    dadap = New System.Data.OleDb.OleDbDataAdapter("SELECT * FROM QRY_Tran where FORMAT(qry_tran.doe,'d/mm/yyyy') = " & CustomeDate & "", con)

    ds = New System.Data.DataSet
    dadap.Fill(ds)
    Dgview.DataSource = ds.Tables(0)
    con.Close()

Note : if u use dd for date representation it will return nothing while selecting 1 to 9 so use d for selection

'Date time format
'MMM     Three-letter month.
'ddd     Three-letter day of the week.
'd       Day of the month.
'HH      Two-digit hours on 24-hour scale.
'mm      Two-digit minutes.
'yyyy    Four-digit year.

The documentation contains a full list of the date formats.

回复收藏 0 原文

~没有更多了~