我正在嘗試在 Access 資料庫中使用 DateTimePicker 搜索日期，并將結果顯示在 DataGridView 中，但它不起作用。沒有錯誤，但它只是不顯示資料庫/結果。這是資料庫和除錯表單的圖片，當它們不起作用時，以防它們有任何用處：
這是我的代碼：
Imports System.Data.OleDb
Public Class Form10
Dim connection As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Daily Sales.accdb;")
Private Sub DateTimePicker1_ValueChanged(sender As Object, e As EventArgs) Handles DateTimePicker1.ValueChanged
If connection.State = ConnectionState.Closed Then
connection.Open()
End If
Dim dt1 As DateTime = DateTime.Parse(DateTimePicker1.Value)
Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM [Table1] where [TDateField] = #" & dt1.ToString("MM/dd/yyyy"), connection)
Dim da As New OleDbDataAdapter
da.SelectCommand = cmd
DataGridView2.DataSource = da
connection.Close()
End Sub
Private Sub Form10_Load(sender As Object, e As EventArgs) Handles MyBase.Load
DateTimePicker1.Format = DateTimePickerFormat.Custom
DateTimePicker1.CustomFormat = "MM/dd/yyyy"
End Sub
End Class
uj5u.com熱心網友回復：
使用日期時間選擇器的真實日期值：
Dim dt1 As DateTime = DateTimePicker1.Value
Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM [Table1] where [TDateField] = #" & dt1.ToString("yyyy'/'MM'/'dd") & "#", connection)
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/439026.html
標籤：数据库 VB.net 毫秒访问 数据网格视图 日期时间选择器
上一篇：將結構中的字串轉換為[]字串