|
|
|
VB.NET สอบถามเรื่อง datetimepicker ครับ แปลงจาก คศ >> พศ |
|
|
|
|
|
|
|
VB.NET
Code (VB.NET)
Dim D1, D2, M1, M2, Y1, Y2, MDY1, MDY2 As String
D1 = DateTimePicker1.Value.Day.ToString
M1 = DateTimePicker1.Value.Month.ToString
Y1 = DateTimePicker1.Value.Year.ToString
MDY1 = M1 & "/" & D1 & "/" & Y1
D2 = DateTimePicker2.Value.Day.ToString
M2 = DateTimePicker2.Value.Month.ToString
Y2 = DateTimePicker2.Value.Year.ToString
MDY2 = M2 & "/" & D2 & "/" & Y2
Dim sd As String = ""
sd = "Select OrderDate,OrderID From Orders"
sd &= " Where OrderDate between '" & MDY1 & "' AND '" & MDY2 & "'"
|
|
|
|
|
Date :
2012-02-22 17:36:06 |
By :
l3kaing |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Code (VB.NET)
Format(DateValue(CDate(txttime.Text).ToString(New System.Globalization.CultureInfo("en-GB", True))), "MM/dd/yyyy")
|
|
|
|
|
Date :
2016-06-19 11:59:21 |
By :
thot |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Load balance : Server 02
|