摘要：
var query = (from x in a.AsEnumerable() join y in b.AsEnumerable() on x.Field("col1") equals y.Field("col1") select new { col1= y.Field("col1"), col2=x.Field("col2") }).To... 阅读全文
摘要：
DateTime ConvertDate = DateTime.ParseExact("20140504", "yyyyMMdd", null, System.Globalization.DateTimeStyles.AllowWhiteSpaces).ToString("yyyy-MM-dd"); DateTime.ParseExact("18/05/2014", "dd/MM/yyyy"... 阅读全文
摘要：
class A { public int id { get; set; } public string name { get; set; } } class B { public int id { get; set; } public int age { ge... 阅读全文
摘要：
private static void DataTableToSQLServer( DataTable dt) { string connectionString = GetConnectionString(); using (SqlConnection destinationConnection =new Sql... 阅读全文
摘要：
SqlBulkcopy Loop Insert 阅读全文
摘要：
or File.ReadLines would read the file line by line. .Select(r => r.TrimEnd('#')) would remove the # from end of the line .Select(line => line.Split(', 阅读全文