เลือกข้อมูลเฉพาะข้อมูลที่วันที่ตรงกับวันที่ปัจจุบันมาแสดงครับ VB.Net+SQL Server

Quote:

Dim SelectQry = "SELECT DateTime AS 'Date Time',Product_ID AS 'Product Code',Actual_Weight AS 'Actual Weight',Upper_Weight AS 'Upper Weight',Lower_Weight AS 'Lower Weight' FROM RunWeight Where CONVERT(CreateDate,101) = GetDate() order by DateTime ASC"
Dim DBSource As New DataSet
Dim TableView As DataView

Quote:

Dim en As New System.Globalization.CultureInfo("en-US")
Dim dateAd As DateTime
dateAd = DateTimePicker1.Value
Textdate.Text = dateAd.ToString("yyyy-MM-dd", en)
Dim SelectQry = "SELECT DateTime AS 'Date Time',Product_ID AS 'Product Code',Actual_Weight AS 'Actual Weight',Upper_Weight AS 'Upper Weight',Lower_Weight AS 'Lower Weight' FROM RunWeight Where DateTime=Textdate.Text order by DateTime ASC"

Quote:

Dim en As New System.Globalization.CultureInfo("en-US")
Dim dateAd1 As DateTime
Dim dateAd2 As DateTime
dateAd1 = DateTimePicker1.Value
Textdate.Text = dateAd1.ToString("yyyy-MM-dd ", en)
dateAd2 = DateTimePicker2.Value
Textdate2.Text = dateAd2.ToString("yyyy-MM-dd ", en)
Dim SelectQry = "SELECT DateTime AS 'Date Time',Product_ID AS 'Product Code',Actual_Weight AS 'Actual Weight',Upper_Weight AS 'Upper Weight',Lower_Weight AS 'Lower Weight' FROM RunWeight Where fDate BETWEEN '" & Textdate.Text & "' and '" & Textdate2.Text & "'order by DateTime ASC"