我使用帶有日期格式的行列的資料網格。
這是資料網格創建代碼
dg_datos.Columns.Add("tarea", "Tarea")
dg_datos.Columns.Add("horas", "Horas")
dg_datos.Columns.Add("descripcion", "Descripcion")
dg_datos.Columns.Add("fecha", "Fecha")
dg_datos.Columns("fecha").DefaultCellStyle.Format = "dd/MM/yyyy"
dg_datos.Rows.Add("Ada Lovelace", "1", "desc.1", "10/11/2002")
dg_datos.Rows.Add("Rafael Nadal", "1.4", "desc.2", "11/11/1822")
dg_datos.Rows.Add("Lewis Hamilton", "0.4", "desc.3", "19/11/1978")
dg_datos.Rows.Add("Charles Leclerc", "5", "desc.4", "02/01/1992")
dg_datos.Rows.Add("HOLA HOLA", "5", "desc.5", "20/04/2022 0:00:00")
Dim table As New DataTable
BindingSource1.DataSource = table
dg_datos.DataSource = BindingSource1
Private Sub Calendario_DateSelected(sender As Object, e As DateRangeEventArgs) Handles calendario.DateSelected
BindingSource1.Filter = String.Format("fecha = #{0:M/dd/yyyy}#", calendario.SelectionStart)
End Sub
我不知道為什么這不起作用
uj5u.com熱心網友回復：
我決定只發布一個答案以避免進一步的痛苦，盡管不能保證你不會做不在答案中的事情。無論如何，您應該像這樣系結資料：
Dim table As New DataTable
Using adapter As New SqlDataAdapter(query, connectionString)
adapter.Fill(table)
End Using
BindingSource1.DataSource = table
DataGridView1.DataSource = BindingSource1
然后，您完全按照我在評論中反復告訴您的那樣過濾資料：
Private Sub Calendario_DateSelected(sender As Object, e As DateRangeEventArgs) Handles calendario.DateSelected
BindingSource1.Filter = String.Format("fecha = #{0:M/dd/yyyy}#", calendario.SelectionStart)
End Sub
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/465787.html