using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace test
{
    class Program
    {
        static void Main(string[] args)
        {
            var dTable = new DataTable(); //列名假设有文件名称FileName、创建时间CreateTime、
            var staTime = DateTime.Now;
            var EndTime = DateTime.Now;

            //查找dTable中CreateTime >= staTime && CreateTime <= EndTime  其他查询同理
            DataRow[] arrRows = dTable.Select("CreateTime >= '" + staTime + "' " + "and CreateTime <= '" + EndTime + "'");

            //查找并排序
            DataRow[] arrRows1 = dTable.Select("CreateTime >='" + staTime + "'", "CreateTime desc");

            //模糊查询
            DataRow[] arrRows2 = dTable.Select("FileName like '文%'");

        }
    }
}

分享到：

赞(0)