我无法在datagridview中看到数据 [英] I cant see data in datagridview
问题描述
当我从访问数据网格视图中查看数据时
它只显示
数据表而不是条目记录
我尝试过:
con.Open()
Dim A As String
A = DateTime.Today.ToString(dd-MM-yyyy)
cmd =新OleDbCommand(选择*来自短信在哪里日期=+ A +)
cmd.Connection = con
dr =新OleDbDataAdapter(cmd)
dr.Fill(ds,sms)
DataGridView1.DataSource = ds.Tables(sms)
con.Close()
When I tring to retriew data from access to datagrid view
its showing only
data sheet but not entry records
What I have tried:
con.Open()
Dim A As String
A = DateTime.Today.ToString("dd-MM-yyyy")
cmd = New OleDbCommand("Select * From sms WHERE Date= " + A + "")
cmd.Connection = con
dr = New OleDbDataAdapter(cmd)
dr.Fill(ds, "sms")
DataGridView1.DataSource = ds.Tables("sms")
con.Close()
推荐答案
很可能,它是数据库中的数据:除非它保存为DATE而不是DATETIME列,否则它只适用于记录完全保存在午夜。但是......代码可能无论如何都不会起作用,因为它几乎肯定会引发格式异常。
尝试将日期作为参数传递:
Most likely, it's the data in your DB: unless it it saved as a DATE rather than DATETIME column then it will only work for records saved at midnight exactly. But...that code probably won't work anyway as it will almost certainly throw a format exception.
Try passing the date as a parameter:
cmd = New OleDbCommand("Select * From sms WHERE Date >= ? ")
cmd.Connection = con
cmd.Parameters.AddWithValue("@DT", DateTime.Today)
这篇关于我无法在datagridview中看到数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!