如何在datagridview中显示今天的数据

Question

Public Sub filltable()
Dim qry As String = "select filename as FileName,filesize as FileSize,time as Time from files"
Dim ds As DataSet = New DataSet()
ds = GetQueryResult_Mysql(qry)
DataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnMode.Fill)
If (ds.Tables(0).Rows.Count > 0) Then
''For i As Integer = 0 To ds.Tables(0).Rows.Count
''    Dim fname As String = ds.Tables(0).Rows(i).Item("filename").ToString()
''    Dim fsize As String = ds.Tables(0).Rows(i).Item("filesize").ToString()
''    Dim ftime As String = ds.Tables(0).Rows(i).Item("time").ToString()
''Next
DataGridView1.DataSource = ds.Tables(0)
End If

End Sub

Answer 1

假设time是一个包含日期的时间戳太

select filename as FileName,filesize as FileSize,time as Time from files WHERE time >= CURDATE()

请下次标记您的数据库(并标记版本(；我们不需要看到隐藏在代码中间的一个奇怪命名的方法就可以知道您正在使用MySQL