如何从ms访问中显示数据到datagrid，该访问具有与label.text = datetime.now.toshortdatestring（）相同的日期。 [英] How to display data to datagrid from ms access which has the same date from label.text=datetime.now.toshortdatestring().

问题描述

如何从ms访问中显示数据到datagrid，该访问权限与label.text = datetime.now.toshortdatestring（）具有相同的日期。



非常感谢!! ！thanks

How to display data to datagrid from ms access which has the same date from label.text=datetime.now.toshortdatestring().

deeply appreciated!!!thanks

推荐答案

使用..

a select查询类似：

use..
a select Query Like:

select * from table_Name where cDate(Date_column)=cDate(datetime.now)

请参阅链接..

Insert，更新，删除ASP.NET的GridView，数据源与SQL Server，MS访问（mdb / accdb），XML和Framework为2.0 / 3.0 / 3.5 / 4.0（VS 2005/2008/2010） [ ^ ]

http://stackoverflow.com/questions/16314070/retrieve-data-from-access-database-to -data-grid-view-in-vb-net [ ^ ]

// you have date time string from toshortdatestring 
var dateString = DateTime.Now.ToShortDateString();
// you need to conver above string back to DateTime 
DateTime dt = DateTime.ParseExact(dateString, 
		System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.ShortDatePattern,
		System.Globalization.CultureInfo.CurrentCulture);
//now you can retrive data from your database as below by filtering using 
//where condition and parameter 
using (OleDbConnection  con = new OleDbConnection(strConnect))
{
	con.Open();
	OleDbDataAdapter da = new OleDbDataAdapter("SELECT * TABLENAME WHERE COLNAME= ?", con);
	da.SelectCommand.Parameters.AddWithValue("@Date", dt.Date);
	DataTable dt = new DataTable();
	da.Fill(dt);
	yourgridview.DataSource = dt;
}

这篇关于如何从ms访问中显示数据到datagrid，该访问具有与label.text = datetime.now.toshortdatestring（）相同的日期。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！