¹ØÓÚAccess ÎÊÌâ¡£²éѯÎÊÌâ

ʱ¼ä×Ö¶Î
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());