时间字段
FinanceData 文本 存储数据如下 10-8
11-1
11-2
11-15
...我想根据时间段查询数据库内容 如何实现public DataTable SelectAllFinaceByDataBound(string FinanceDataOne,string FinanceDataTwo)
{
strOleDb = new StringBuilder();
strOleDb.Append("select FinanceID as 编号,Department as 来文机关或部门,Sort as 类别,Amount as 份数,FinanceData as 收到日期,OrderNum as 顺序号,FileNum as 来文号,ArchivesNum as 归入案卷号,FileTitle as 拟办,FileStyle as 来文类型 from Finance");
strOleDb.Append(" where FinanceData between '" + FinanceDataOne + "' and '"+FinanceDataTwo +"'");
strOleDb.Append(" order by FinanceID desc"); return DB.Fill(strOleDb.ToString());
}我是这么写的 但是不对。。
FinanceData 文本 存储数据如下 10-8
11-1
11-2
11-15
...我想根据时间段查询数据库内容 如何实现public DataTable SelectAllFinaceByDataBound(string FinanceDataOne,string FinanceDataTwo)
{
strOleDb = new StringBuilder();
strOleDb.Append("select FinanceID as 编号,Department as 来文机关或部门,Sort as 类别,Amount as 份数,FinanceData as 收到日期,OrderNum as 顺序号,FileNum as 来文号,ArchivesNum as 归入案卷号,FileTitle as 拟办,FileStyle as 来文类型 from Finance");
strOleDb.Append(" where FinanceData between '" + FinanceDataOne + "' and '"+FinanceDataTwo +"'");
strOleDb.Append(" order by FinanceID desc"); return DB.Fill(strOleDb.ToString());
}我是这么写的 但是不对。。
没报错误,但是不是我想要的结果我的本意是:数据存进数据库 可以按日期范围查询而且取出来打印进WORD 只显示月和日 怎么实现。。