VS2012 Productivity Power Tools RSS

• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  VS2012 Productivity Power Tools

  Nov 09, 2012 12:15 AM|LINK

  using System;
  using System.Collections.Generic;
  using System.Linq;
  using System.Security.Cryptography;
  using System.Text;
  using Microsoft.Win32;
  using System.IO;
  using System.Text.RegularExpressions;
  using System.Diagnostics;
  using System.Xml.Linq;
  using System.Data;
  using System.Linq.Expressions;
   
  namespace CSharp
  {
      public class Program
      {
          static void Main(string[] args)
          {
              DataTable dt = new DataTable();
              dt.Columns.Add("count", typeof(int));
              dt.Columns.Add("datetime", typeof(DateTime));
              for (int i = 1; i < 11; i++)
              {
                  dt.Rows.Add(i, new DateTime(2012, 12, 20+i, 21, 21, 21));
              }
              dt.Rows[3][0] = DBNull.Value;
              Console.WriteLine(dt.Compute("avg(count)", "datetime>'2012-12-21 21:21:21' and datetime<'2012-12-25 21:21:21'"));
          }
      }
  }