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
{
publicclassProgram
{
staticvoid Main(string[] args)
{
DataTable dt = newDataTable();
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'"));
}
}
}
Decker Dong ...
All-Star
118619 Points
18779 Posts
VS2012 Productivity Power Tools
Nov 09, 2012 12:15 AM|LINK