Friday 12 June 2020

The source contains no DataRows OR filter datatable datetime in c#

///////////////////////////


///////// Method 1
            DataTable dt = new DataTable();

            DataTable dt2 = dt.Clone();
            var rows = dt.Select().Where(p => (Convert.ToDateTime(p["DateTime"]).Date >= System.DateTime.Now.AddDays(-50)) && (Convert.ToDateTime(p["DateTime"]) <= System.DateTime.Now.Date));

            foreach (var row in rows)
                dt2.ImportRow(row);



///////// Method 2
            DataTable dtn = new DataTable();
            dtn = dt.Clone();
            dtn = dt.Select().Where(p => (Convert.ToDateTime(p["DateTime"]).Date >= System.DateTime.Now.AddDays(-50)) && (Convert.ToDateTime(p["DateTime"]) <= System.DateTime.Now.Date)).CopyToDataTable();



 ///////// Method 3
            DataTable dt3 = new DataTable();
            dt3 = dt.Clone();
            var reRows = dt.Select().Where(m => ((DateTime)m["DateTime"]).Date >= DateTime.Now.Date);

            if (reRows.Any())
                dt3 = reRows.CopyToDataTable();


No comments:

Post a Comment

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...